Importing csv data (with semicolons) into excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

markshunter - 20 Mar 2006 19:51 GMT

Anyone have any way to import a csv file that is separated by semi-colons
into a spreadsheet?
I am hoping i can take the file and parse it out by the semicolons and use
the top line as the heading line (titles).

Reply to this Message

Tom Ogilvy - 20 Mar 2006 20:31 GMT

http://www.cpearson.com/excel/imptext.htm import/export text files
Chip Pearson's site.

Signature

Regards,
Tom Ogilvy

> Anyone have any way to import a csv file that is separated by semi-colons
> into a spreadsheet?
> I am hoping i can take the file and parse it out by the semicolons and use
> the top line as the heading line (titles).

Reply to this Message

markshunter - 20 Mar 2006 21:21 GMT

Thanks Tom. I got this to work. I guess there is no "Automatic" way to get
this to work (ie hands off)

> http://www.cpearson.com/excel/imptext.htm import/export text files
> Chip Pearson's site.
[quoted text clipped - 3 lines]
> > I am hoping i can take the file and parse it out by the semicolons and use
> > the top line as the heading line (titles).

Reply to this Message

Tom Ogilvy - 20 Mar 2006 21:50 GMT

If you have xl2002 or xl2003, there is an international tab in
tools=>options, but I only saw settings for decimal separator and thousands
separator. In international setting in the control panel, there is a setting
for list separator. but changing that changes it for all windows
applications.

This all assumes you tried just opening the file in Excel and it didn't work
as you wanted.

Signature

Regards,
Tom Ogilvy

> Thanks Tom. I got this to work. I guess there is no "Automatic" way to get
> this to work (ie hands off)
[quoted text clipped - 6 lines]
> > > I am hoping i can take the file and parse it out by the semicolons and use
> > > the top line as the heading line (titles).

Reply to this Message