CSV file into the Excel

[Guest]

Hi all,
can somebody help me? Usually when opening an CSV file in the Excel the
file is automatically loaded as the excel spreadsheet. But we have in the
office one PC where the CSV file is not automatically converted/imported into
different columns but it is imported/loaded as txt file where are rows only
and there are all data delimited by comma.
What is the reason for it? What should be done/set up to make that Excel
Application to load/import the CSV file automatically as an excel spreadsheet?

Thanks a lot.
Drahos.

 

[Guest]

Have you tried to open the file from Excel by clicking on FILE, selection
OPEN, changing the FILES OF TYPE to text and selecting your text file. This
should launch the text import wizard, where you can define the composition of
the data, indicate what row to start the import on, etc....

I'm guessing that perhaps the text file in question has one or more header
rows and Excel uses the first row of the text file to determine its layout.

 

[Dave Peterson]

I think I'd make the windows list separator on the problem pc match the windows
list separator on the pcs that had no problem.

Under the Regional settings Applet under Windows control panel.

In winXP, you can click on the Advanced button on the "regional options" tab.

Then on the numbers tab, change the list separator character so that it matches
the data (usually a comma in the USA and a semicolon in Europe and who knows
what for you).

 

[Guest]

Dear Dave and Kevin,

thank you very much for your help. Dave, you are right. I have changed
the Regional Windows setup and now it is OK.

Best Regards
Drahos.