Fixing Comma Separated Values (.csv)

  • Thread starter Thread starter dickives
  • Start date Start date
D

dickives

I am trying to export my bank statement to excel. The only option
have that will work in excel is .csv. The problem is that this forma
does not separate the data. It keeps it all in one cell, with comma
separating it (hence the name). For example, cell A2 contains th
date, description and amount. What I want is for date to be in A2
description to be in B2 and amount to be in C2.

Is there an easy way to break the lines up into separate cells?
Thanks
 
Hi,

as csv does simply mean "comma seperated values" the data in the csv is
seperated by comma... ;)

Therefore you simply have to load the file in Excel - done.

If this - for any reason - does not work correctly (as you claimed), try this:
Rename the file to *.txt and load it in Excel again.
The Import-Assistant should come up and you should be able to import the
data correctly.

Did this help?

Best wishes,
Eric
 
Back
Top