SOLVED
Home

SEMI COLON (;) COLUMN SEPARATOR INSTEAD OF COMMA (,) WHEN WE EXPORT AS CSV UTF-8 FILE FORMAT

%3CLINGO-SUB%20id%3D%22lingo-sub-414983%22%20slang%3D%22en-US%22%3ESEMI%20COLON%20(%3B)%20COLUMN%20SEPARATOR%20INSTEAD%20OF%20COMMA%20(%2C)%20WHEN%20WE%20EXPORT%20AS%20CSV%20UTF-8%20FILE%20FORMAT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414983%22%20slang%3D%22en-US%22%3E%3CP%3EHI%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20sheet%20with%20multiple%20columns%20and%20When%20I%20export%20that%20as%20CSV%20UTF-8%20file%20format%2C%20column%20separator%20comes%20as%20comma.%20Is%20there%20anyway%20I%20can%20change%20comma%20to%20semicolon%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20snapshot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKrish%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-414983%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-415405%22%20slang%3D%22en-US%22%3ERe%3A%20SEMI%20COLON%20(%3B)%20COLUMN%20SEPARATOR%20INSTEAD%20OF%20COMMA%20(%2C)%20WHEN%20WE%20EXPORT%20AS%20CSV%20UTF-8%20FILE%20FORMAT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-415405%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F317114%22%20target%3D%22_blank%22%3E%40krish86%3C%2FA%3E%26nbsp%3B%2C%20that's%20only%20if%20change%20system%20separator%3C%2FP%3E%0A%3CP%3E-%20open%20your%20file(s)%20you'd%20like%20to%20save%20as%20csv%3C%2FP%3E%0A%3CP%3E-%20Win%2BR%20and%20type%20%22control%20international%22%2C%20click%20Additional%20settings%3C%2FP%3E%0A%3CP%3E-%20Change%20List%20separator%20on%20semicolons%20and%20click%20Apply%3C%2FP%3E%0A%3CP%3E-%20save%20your%20Excel%20files%20as%20csv%3C%2FP%3E%0A%3CP%3E-%20Change%20back%20List%20separator%20on%20comma%20and%20Apply%20(or%20Ok)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESure%20you%20may%20keep%20your%20list%20separator%20as%20semicolon%2C%20but%20that%20could%20be%20side%20effect%20in%20different%20places%2C%20better%20to%20keep%20default%20one%20for%20your%20locale%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-485060%22%20slang%3D%22en-US%22%3ERe%3A%20SEMI%20COLON%20(%3B)%20COLUMN%20SEPARATOR%20INSTEAD%20OF%20COMMA%20(%2C)%20WHEN%20WE%20EXPORT%20AS%20CSV%20UTF-8%20FILE%20FORMAT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-485060%22%20slang%3D%22en-US%22%3EThanks%20Sergei%2C%20been%20googling%201h%20now%20and%20this%20was%20the%20solution%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-486534%22%20slang%3D%22en-US%22%3ERe%3A%20SEMI%20COLON%20(%3B)%20COLUMN%20SEPARATOR%20INSTEAD%20OF%20COMMA%20(%2C)%20WHEN%20WE%20EXPORT%20AS%20CSV%20UTF-8%20FILE%20FORMAT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-486534%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%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
krish86
New Contributor

HI,

 

I have an excel sheet with multiple columns and When I export that as CSV UTF-8 file format, column separator comes as comma. Is there anyway I can change comma to semicolon?

 

Attached snapshot.

 

Thanks,

 

Krish

3 Replies
Solution

@krish86 , that's only if change system separator

- open your file(s) you'd like to save as csv

- Win+R and type "control international", click Additional settings

- Change List separator on semicolons and click Apply

- save your Excel files as csv

- Change back List separator on comma and Apply (or Ok)

 

Sure you may keep your list separator as semicolon, but that could be side effect in different places, better to keep default one for your locale

Thanks Sergei, been googling 1h now and this was the solution
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
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies