Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file into the Excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file into the Excel
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. -- Kevin Backmann "Drahos" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file into the Excel
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). Drahos wrote: 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. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file into the Excel
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. "Dave Peterson" wrote: 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). Drahos wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) |