CSV Output in 2nd cell instead of only in 1st

[exwul]

When using:

exiftool -g -csv test.jpg > test.csv

and importing the csv file into excel, using text to columns, the first line (field headers) is okay.
all the data was in cell A1

However, the 2nd line (with exif-data) the data is in both A2 and B2

Not sure whether that is correct.

Meanwhile, is there a way to get the data into a .csv file, the same way as it is presented on screen?
(by using just exifttool -g test.jpg)

Thanks
=

=

[Hayo Baan]

Works fine for me, so my guess is that you using an incorrect field separator. You need to split the input on a comma. Then you should be fine, I think.

[exwul]

Okay, it works fine with me for the first row (A1).
You can see that in the screenshot (text to columns, comma separated).

However, in the 2nd row there is in B2.
So when I were to do the text to columns on A2 it will warn me that it will override existing data (existing in B2)

What is the contents in B2 at yours?
You have only A1 and A2 filled?
=

[Hayo Baan]

Strange, looking at you screenshot again, it looks as if excel is putting all data of the following lines into one. This is weird.

If I try this, I get the spreadsheet I expect:
The first row (cells A1, B1, C1, etc) have the column names, and the next rows all have the data for a single file in them (the way it should be).

Something is odd at your place... Can you perhaps post the csv you created (including the exact command that created it), I can then have a look to see what's wrong.