Home

CSV formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-326905%22%20slang%3D%22en-US%22%3ECSV%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326905%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20evening.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20just%20reinstalled%20Windows%2010%20Home%20in%20my%20notebook%20and%20installed%20O365%20as%20well.%20However%2C%20now%20my%20CSV%20files%20I%20used%20to%20download%20and%20use%20without%20issues%20now%20do%20not%20work%20anymore%20-%20it%20is%20all%20without%20format%20and%20impossible%20for%20me%20to%20work%20-%20does%20anyone%20know%20what%20might%20be%20the%20issue%3F%20I%20open%20the%20CSV%20file%20using%20Excel%20and%20it%20is%20not%20usable.%20Below%20the%20example%20of%20what%20I%20see%20in%20the%20CSV%20file%20in%20Excel%20and%20my%20regional%20formatting%20already%20has%20decimal%20with%20comma.%20What%20should%20I%20do%3F%3F%3C%2FP%3E%3CP%3ETks%2C%3C%2FP%3E%3CP%3EAndr%C3%A9%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71257iDA2545A08779B6B1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Example%20CSV%20format.JPG%22%20title%3D%22Example%20CSV%20format.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20and%20regards%2C%3C%2FP%3E%3CP%3EAndr%C3%A9%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-326905%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecsv%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326919%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326919%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F273638%22%20target%3D%22_blank%22%3E%40deruas%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20are%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20show%20a%20screen%20shot%20of%20the%20file%20in%20notepad%3F%20It%20may%20help%20to%20see%20how%20it's%20laid%20out%20to%20determine%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-484952%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-484952%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20got%20the%20same%20problem.%3C%2FP%3E%3CP%3EIt%20seems%20like%20excel%20does%20not%20use%20%22%3B%22%20as%20a%20separator%2C%20can't%20find%20the%20settings%20for.%20it%20uses%20%22%2C%22%20instead%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F110586i36FE019CDB84E74F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486786%22%20slang%3D%22en-US%22%3ERe%3A%20CSV%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486786%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F328092%22%20target%3D%22_blank%22%3E%40Jon_The_IT_Man%3C%2FA%3E%26nbsp%3B%2C%20I%20guess%20you%20found%20the%20answer%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FSEMI-COLON-COLUMN-SEPARATOR-INSTEAD-OF-COMMA-WHEN-WE-EXPORT-AS%2Fm-p%2F414983%23M28663%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FSEMI-COLON-COLUMN-SEPARATOR-INSTEAD-OF-COMMA-WHEN-WE-EXPORT-AS%2Fm-p%2F414983%23M28663%3C%2FA%3E%2C%20but%20that's%20mainly%20if%20you%20would%20like%20to%20save%20Excel%20file%20as%20csv%20with%20not-default%20separator%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20task%20is%20to%20open%20csv%20file%20with%20another%20separator%2C%20you%20may%20as%20well%20to%20manually%20add%20(e.g.%20in%20Notepad)%20first%20line%20with%20the%20separator%20to%20use%20sep%3D%3B%20like%3C%2FP%3E%0A%3CPRE%3Esep%3D%3B%0Aa%3Bb%3Bc%0Ax%3By%3Bz%3C%2FPRE%3E%0A%3CP%3EIt'll%20be%20opened%20correctly%20even%20if%20your%20system%20list%20separator%20is%20comma%2C%20first%20line%20with%20sep%20will%20be%20not%20shown%20by%20Excel%3C%2FP%3E%3C%2FLINGO-BODY%3E
deruas
Occasional Visitor

Good evening. 

I have just reinstalled Windows 10 Home in my notebook and installed O365 as well. However, now my CSV files I used to download and use without issues now do not work anymore - it is all without format and impossible for me to work - does anyone know what might be the issue? I open the CSV file using Excel and it is not usable. Below the example of what I see in the CSV file in Excel and my regional formatting already has decimal with comma. What should I do??

Tks,

André

 

Example CSV format.JPG

 

Thanks and regards,

André

3 Replies

Hi @deruas 

 

Hope you are well.

 

Could you please show a screen shot of the file in notepad? It may help to see how it's laid out to determine the issue.

 

Cheers

Damien

I've got the same problem.

It seems like excel does not use ";" as a separator, can't find the settings for. it uses "," instead

 

 

image.png

@Damien Rosario 

Highlighted

@Jon_The_IT_Man , I guess you found the answer here https://techcommunity.microsoft.com/t5/Excel/SEMI-COLON-COLUMN-SEPARATOR-INSTEAD-OF-COMMA-WHEN-WE-EX..., but that's mainly if you would like to save Excel file as csv with not-default separator,

 

If the task is to open csv file with another separator, you may as well to manually add (e.g. in Notepad) first line with the separator to use sep=; like

sep=;
a;b;c
x;y;z

It'll be opened correctly even if your system list separator is comma, first line with sep will be not shown by Excel

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies