How to import .csv data into Excel spreadsheet?

  Pineman100 13:08 13 Aug 2007
Locked

I can download account information from my bank in .csv format. Does anyone know how I can then turn this data into an Excel spreadsheet?

I run Excel 2000 under XP.

Many thanks.

  VoG II 13:19 13 Aug 2007

File > Open, navigate to the folder with the .csv file, on Files of Type select Text files. The file should then open in Excel.

  Picklefactory 13:23 13 Aug 2007

Do you mean save it as Excel file? I also do this, Excel will open the .csv file, you can then edit format to how you like it, but when you save again, use 'Save as' and (As VoG™ stated) use the 'Save as type' dialogue box and select 'Microsoft Excel workbook'

  Pineman100 16:33 13 Aug 2007

Job done!

I'm most grateful.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Microsoft Surface Book 2 hands-on review – bigger and 5x faster

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?