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