pulling data from a csv file

[chachie22]

Hi all,

Just curious if there is a way to pull data from a csv file without converting it. I have a csv file which is automatically updated daily with appended data. I have an index and match formula set up in my excel worksheet(thanks martindwilson) but only reads from excel files. I'd like it to pull the data from a csv.

I guess I could have a batch file set up to open the csv and save it as xls but there must be a way excel can do it on it's own.

Thanks for the help

[MarvinP]

Hi chachie22,

I do this daily with a csv file. The answer is to open the csv and pull all your data and then close, without saving, the csv. I copy values only from the csv to my master XL sheet.

I hope this helps.

[chachie22]

Thanks but I'd like excel to do this automatically. Basically open the excel worksheet and have it query all the data required. This worksheet pulls data from websites and other excel spreadsheets. Data is entered manually but it would be great to not have to do it.