Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » CSV - converting from Excel to CSV

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

CSV - converting from Excel to CSV

Resolved · High Priority · Version 2003

Reply Wed 21 May 2008, 12:32Delegate Matthew said...

Matthew has attended:
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

For upcoming training course dates see: Pricing & availability

Reply Wed 28 May 2008, 16:24Trainer Amanda said...

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

Excel articles

· Microsoft Excel Training: Essential for Today's Employees
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How Excel Can Transform All Of Your Office Documents
· Make More of your Money with Excel 2007
· Reasons Why VBA for Excel Training Fails

Please browse our web site to find out more about
excel training and other Microsoft training courses.

Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips