Charles L. Cotton wrote:Thanks guys. I looked at Excel and found the import function. However, it didn't show a csv file as an option.
Could I create a master report in Excel for each event, then import the data from the csv file? Or do I have to import the csv file, then do the formatting like column headings, etc.?
Chas.
Easiest is just to open the file vs. import.
Start Excel, choose File, Open, then in the box below the filename that says Files of Types, choose the Text file option and find the file on your computer. It should open right up as it knows how to delimit the file with he commas, and should be pretty well formatted. Add headings if they were not part of the .csv file to begin with. Save as a .xls file and you are there!!!