How do I import a CSV file to excel

[lorraine knight]

I have a csv file seperated by a ; in a notepad. one line has 10 bits of
data, there are upto 40 lines or records. I want to import the data to
excel, when I use the Data/Import wizard, it places each record within
the notepad to one column, how do I get it to split the data within
each of the ; into a seperate column, using one row for each record.

Lorraine

 

[Guest]

Do you have each bit of data seperated with , or some other character. When
you do the Data Import make sure you choose delimited on the 1st screnn and
then specify how the data is seperated. HTH
Sheila

 

[Guest]

If I understand your problem, your data is seperated by semi-colons. When
using the 'Wizard' did you select 'Delimited' then 'Semicolon?' If not, this
could do the trick.

 

[Dave Peterson]

What do you have for your windows list separator?

Close excel
windows start button|settings|control panel|Regional and language options

Click the customize button
Numbers Tab
List separator

Make sure it matches your data.

Alternatively, you could always select that column and do data|text to columns.
Choose delimited by.


=====
Another alternative is to rename the *.csv file to *.txt. Then you'll be able
to specify delimited by a semicolon in the wizard.

 

[Gord Dibben]

Change the *.csv filename to *.txt

Open that *.txt file in Excel and you should get the Text Import Wizard which
allows you to split the data into the 10 columns via the "delimited by" which in
your case would be the ;


Gord Dibben MS Excel MVP