SOLVED

What's the difference between "CSV-File (.csv)" and "Microsoft Excel-CSV-File (.csv)"?

Iron Contributor

Hi,

 

I have noticed that a .csv file opens differently on my two machines.

On machine A) the opened file displays everything in separate columns:

 

1.png

 

 

On machine B) the opened file displays everything in the same column:

 

2.png

 

I can't figure out why that is.

 

The Windows and Office versions on both machines are identical.

Windows: 1709 (Build 16299.431)

Office: 1802 (Build 9029.2253 CTR)

 

I noticed that the file icon is different on both machines.

 

Machine A):

1_2.png

 

Machine B):

2_2.png

 

Moreover, I file type (Dateityp) seems to be different (please don't mind the German):

 

Machine A) says "CSV-Datei":

1_3.png

 

Machine B) says "Microsoft Excel-CSV-Datei":

2_3.png

 

Furthermore, I opened the file in Excel Online and it opens like on Machine B).

 

One more thing I did is use PowerShell Get-Service | Export-Csv "C:\users\[xxx]".

I would expect each property to show in it's own column. It does that on machine A) but not on B).

 

I have attached the file for you to test it.

Ideally I would like the file to opened on every machine as it does on A).

 

Thanks in advance for your help.

 

1 Reply
best response confirmed by Olf (Iron Contributor)
1 best response

Accepted Solutions