how to download csv data from web page?

A

Andy

Sorry if this has been covered, I couldn't find this specific issue in
the archives. I'm trying to download data from the Penn World Tables
(http://pwt.econ.upenn.edu/php_site/pwt61_form.php). It gives you an
option to download as csv, which gives you a web page with the data on
it (it doesn't download a file). The instructions are then (obviously
for PC):

"You can copy the data and paste them to NOTEPAD. Then save the file as
"mydata.csv" (keep the double quotes). After that, you can open it in
MS Excel or import it to some statistics analysis packages."

I tried using TextEdit, with or without quotes (not sure why this would
be necessary), and changing the extension to .csv, but Excel won't
recognize it. Is there a way to do this?
 
M

Mike Middleton

Andy -

You probably don't need an intermediate text file. Try this:

Use the web site's csv option. Copy the data in the browser window. Select
cell A1 in Excel, and paste. Select column A, and choose Data | Text To
Columns, etc.

- Mike
www.mikemiddleton.com
 
Top