ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copying data from Web Site to Excel spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/176381-copying-data-web-site-excel-spreadsheet.html)

Elenora

Copying data from Web Site to Excel spreadsheet
 
Bonjour,

I need to do the following, and I am trying to find the fastest way in doing
it.

1- Copy collums of add. from a web page.
2- Paste inside an Excel speadsheet.
3- Collums have to be paste in 1 horizontal row, ie. name, add, tel. number
etc.

I have tried the Data transfer function, and for some reason it does not
work. I have a program to which I can copy the data from the web, which
automaticly turns it to Text.
Once the data is in the text format, I have to clean out the 'crap" data,
then copy paste to excel. What I am trying to find is a program, that will
turn the text to a CSV format, so that I do not need to clean the data again
inside of excel!

Making sense??


All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com