How to import .csv data into Excel spreadsheet?

  Pineman100 13:08 13 Aug 07
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 07

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 07

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 07

Job done!

I'm most grateful.

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac