How to load data into excel?

[Eric]

Does anyone have any suggestions on how to load data into excel?
There is the link for dat
http://download.finance.yahoo.com/d/quotes.csv?s=XAUUSD=X&f=sl1d1t1c1ohgv&e=.csv

Thanks in advance for any suggestions
Eric

 

[Kevin B]

Have you tried Data/Import External Data/New Web Query.

You supply the URL and then select the tables from the web page you want to
import.

 

[Eric]

When I load following link, it requests for open / save cvs file.
Do you have any suggestions on how to load it without opening or saving any
file?
Thank you very much for any suggestions
Eric

 

[Gord Dibben]

That link is to a *.csv file. not a data table.

You must find an alternate link to get to the source data for the quote.csv
file.


Gord Dibben MS Excel MVP