Opening .csv-files in Excel
 

I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who shall
work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

Opening .csv-files in Excel
 

Hi Bengt

Its probable that the Regional settings are different on the computers.
Yours must be set to use ; as the separator, hence Excel knows exactly how
to parse the data.
Other machines may be set with ' as the separator, so Excel doesn't know how
to parse the data with ;

If you cannot make the Regional settings the same on all computers, when
Excel imports it all into column a, select column ADataText to
ColumnsDelimitedOther ; Finish
--
Regards
Roger Govier

"Bengt" wrote in message
...
I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who
shall work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

Opening .csv-files in Excel
 

Perhaps you have semicolon set as list separator in Windows Regional
settings, while some other Character is set on the other Computers. Check it!

Regards,
Stefi


€žBengt€� ezt Ã*rta:

I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who shall
work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

Opening .csv-files in Excel
 

I'm not sure, but it might be that on your computer the list separator is set to a semicolon, while on the other it is a space (or
even something else)
look in Control Panel, Date, Time. Language and Regional Options

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bengt" wrote in message ...
|I write semicolon separated .csv-files from another application and open
| them in Excel. It works excellent on my computer. I just open the file and
| data is organised in columns as I would expect.
| If I do the same thing on certain other computers with the same Excel
| version (2003), all data of each row is imported to the first Excel colums
| as one string. I have looked a lot for a setting in Excel that contol this
| import, but not found any. Have I missed something?
| It is of course possible to import data from the csv-file by data/import
| external data, but that is a more complicated way, and the people who shall
| work with this is not so familiar with Excel.
| To sum it up: How is data import controlled when a text file is opened in
| Excel?
|
|
|
|
|
|
|
|
|
|

Opening .csv-files in Excel
 

What list separator is defined in your Windows Regional Settings? [It's a
Windows setting, not Excel.]

Try changing it from a comma to a semi-colon, then try to open your CSV.
--
David Biddulph

"Bengt" wrote in message
...
I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file and
data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel colums
as one string. I have looked a lot for a setting in Excel that contol this
import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who
shall work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

Opening .csv-files in Excel
 

Of course, there is semicolon listed as a separator - use that, no need to
use Other.

--
Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Bengt

Its probable that the Regional settings are different on the computers.
Yours must be set to use ; as the separator, hence Excel knows exactly how
to parse the data.
Other machines may be set with ' as the separator, so Excel doesn't know
how to parse the data with ;

If you cannot make the Regional settings the same on all computers, when
Excel imports it all into column a, select column ADataText to
ColumnsDelimitedOther ; Finish
--
Regards
Roger Govier

"Bengt" wrote in message
...
I write semicolon separated .csv-files from another application and open
them in Excel. It works excellent on my computer. I just open the file
and data is organised in columns as I would expect.
If I do the same thing on certain other computers with the same Excel
version (2003), all data of each row is imported to the first Excel
colums as one string. I have looked a lot for a setting in Excel that
contol this import, but not found any. Have I missed something?
It is of course possible to import data from the csv-file by data/import
external data, but that is a more complicated way, and the people who
shall work with this is not so familiar with Excel.
To sum it up: How is data import controlled when a text file is opened in
Excel?

Opening .csv-files in Excel
 

<while on the other it is a space

I meant a comma.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| I'm not sure, but it might be that on your computer the list separator is set to a semicolon, while on the other it is a space
(or
| even something else)
| look in Control Panel, Date, Time. Language and Regional Options
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Bengt" wrote in message ...
||I write semicolon separated .csv-files from another application and open
|| them in Excel. It works excellent on my computer. I just open the file and
|| data is organised in columns as I would expect.
|| If I do the same thing on certain other computers with the same Excel
|| version (2003), all data of each row is imported to the first Excel colums
|| as one string. I have looked a lot for a setting in Excel that contol this
|| import, but not found any. Have I missed something?
|| It is of course possible to import data from the csv-file by data/import
|| external data, but that is a more complicated way, and the people who shall
|| work with this is not so familiar with Excel.
|| To sum it up: How is data import controlled when a text file is opened in
|| Excel?
||
||
||
||
||
||
||
||
||
||
|
|