Transfer Alphanumeric Data from Website to ..

Closed
Pauline - Aug 17, 2010 at 04:33 AM
 Pauline - Aug 17, 2010 at 07:45 AM
Hello,

Newbie here. I want to know what's the easiest way to transfer alphanumeric data from a website to a spreadsheet? Also, would you know what tools or programs I can use for this?

Thanks,
Pauline



2 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 17, 2010 at 06:35 AM
It depends upon type of data in web page. Is it in a table form or running matter.
If you are going download in excel I presume you need a table to be downloaded into excel

In excel sheet you click date-import external data=new web query. it will open a new web query window. in the address type or copy the web page address and hit "go" (next to the address). the webpage will open and normally each table will have a yellow cross mark and if you click the mark in the required table it will turn into a tick. then you can click "import" at the bottom right. it will ask the cell where you want to download and choose it and hit ok. the table in webpage will be downloaded into excel.

After some practice and trial and error you will get the hang of it.
0
Thanks venkat1926 I'll try that.
0