98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » CSV - converting from Excel to CSV
CSV - converting from Excel to CSV
Resolved · High Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:LARGE and SMALL functions and their usesTwo of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest? |