Matthew has attended:
Excel Intermediate course
Excel Intermediate course
CSV - converting from Excel to CSV
Hi,
Am trying to convert a excel document to CSV. It is not working. It saves a CSV file but is not seperating the columns. Why is this? When converting I get a warning message about not being compatible and possibility of losing data.
Regards
RE: CSV - converting from Excel to CSV
Hi Martin
Thank you for your question; and welcome to the forum.
The most likely reason that the data is not displaying correctly in columns when you import the CSV file into Excel is that the incorrect delimiter is selected.
There should be an import wizard (3 steps) that comes up on your screen when you open the CSV file in Excel.
At one of the steps (I think the first or second step) there is an option to select which type of delimiter is used to separate the columns from each other. You will need to tick/select the Comma delimiter (the C in CSV stands for comma, the delimiter which is used to separate data between columns).
The message you see about compatibility is just to explain that the CSV file format cannot deal with/display all the features/functions that you have in Excel. For example, the CSV file format cannot store formulas, so it will display the result of a formula as a number in the CSV file. The same applies to most formatting as well (colours, bolding, number formatting etc).
I hope this helps.
Amanda
