Importing csv data (with semicolons) into excel
 

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).

Importing csv data (with semicolons) into excel
 

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

--
Regards,
Tom Ogilvy


"markshunter" wrote:

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).

Importing csv data (with semicolons) into excel
 

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

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"markshunter" wrote:

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).

Importing csv data (with semicolons) into excel
 

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.

--
Regards,
Tom Ogilvy



"markshunter" wrote:

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

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"markshunter" wrote:

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).