Export CSV documents error

%3CLINGO-SUB%20id%3D%22lingo-sub-2466579%22%20slang%3D%22en-US%22%3EExport%20CSV%20documents%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466579%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20issues%20to%20upload%20a%20file%20in%20CSV%20format%2C%20when%20I%20save%20it%20and%20another%20person%2Fsystem%20opens%20the%20file%20they%20get%20a%20document%20fill%20of%20dots%20and%20commas%20and%20they%20can't%20change%20it.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2466579%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2466774%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20CSV%20documents%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466774%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1084448%22%20target%3D%22_blank%22%3E%40Paulagiron1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENEVER%20open%20a%20CSV%20file%20with%20Excel.%20ALWAYS%20import%20the%20CSV%20file%20via%20Power%20Query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithin%20PQ%20you%20can%20change%20the%20datatype%20as%20it%20fits%20your%20locale.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2466838%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20CSV%20documents%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466838%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1084448%22%20target%3D%22_blank%22%3E%40Paulagiron1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20csv%20file%20uses%20semicolon%20as%20separator.%3C%2FP%3E%0A%3CP%3EIf%20the%20recipient%20uses%20comma%20as%20list%20separator%2C%20all%20data%20will%20be%20dumped%20into%20the%20first%20column.%3C%2FP%3E%0A%3CP%3ESolution%3A%20change%20the%20file%20extension%20from%20.csv%20to%20.txt.%3C%2FP%3E%0A%3CP%3EWhen%20the%20recipient%20opens%20the%20.txt%20file%2C%20Excel%20will%20display%20the%20Text%20Import%20Wizard.%3C%2FP%3E%0A%3CP%3ESelect%20Delimited%2C%20then%20click%20Next.%3C%2FP%3E%0A%3CP%3ESelect%20Semicolon%2C%20then%20click%20Finish.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2466898%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20CSV%20documents%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466898%22%20slang%3D%22en-US%22%3Ebut%20if%20I%20have%20to%20upload%20it%20to%20a%20system%20that%20requests%20CSV%20document%20file%20it%20tells%20me%20there%20is%20an%20error%20with%20the%20file%20and%20doesn't%20recognized%20and%20it's%20not%20excel%20it%20is%20an%20upload%2C%20will%20this%20help%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2466901%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20CSV%20documents%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2466901%22%20slang%3D%22en-US%22%3EThank%20you%2C%20yes%20that's%20what%20we%20normally%20do%20but%20I%20have%20to%20upload%20it%20into%20a%20system%20that%20doesn't%20recognized%20the%20file%20and%20the%20system%20requires%20CSV%20file...%20don't%20know%20how%20to%20do%20it%20because%20it's%20only%20me%20getting%20this%20issue%20when%20saving%20it%20as%20CSV%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2467050%22%20slang%3D%22en-US%22%3ERe%3A%20Export%20CSV%20documents%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2467050%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1084448%22%20target%3D%22_blank%22%3E%40Paulagiron1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEither%20change%20your%20system%20settings%20to%20use%20point%20as%20decimal%20separator%20and%20comma%20as%20list%20separator%2C%20or%20change%20the%20delimiters%20in%20Excel%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20File%20%26gt%3B%20Options.%3C%2FLI%3E%0A%3CLI%3ESelect%20Advanced.%3C%2FLI%3E%0A%3CLI%3EIn%20the%20Editing%20options%20section%2C%20clear%20the%20check%20box%20'Use%20system%20separators'%2C%20then%20specify%20point%20as%20decimal%20separator%20and%20comma%20as%20thousands%20separator.%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3ECSV%20files%20that%20you%20save%20from%20now%20on%20should%20use%20comma%20as%20separator.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am having issues to upload a file in CSV format, when I save it and another person/system opens the file they get a document fill of dots and commas and they can't change it. 

9 Replies

@Paulagiron1 

NEVER open a CSV file with Excel. ALWAYS import the CSV file via Power Query.

 

Within PQ you can change the datatype as it fits your locale.

 

@Paulagiron1 

The csv file uses semicolon as separator.

If the recipient uses comma as list separator, all data will be dumped into the first column.

Solution: change the file extension from .csv to .txt.

When the recipient opens the .txt file, Excel will display the Text Import Wizard.

Select Delimited, then click Next.

Select Semicolon, then click Finish.

but if I have to upload it to a system that requests CSV document file it tells me there is an error with the file and doesn't recognized and it's not excel it is an upload, will this help?
Thank you, yes that's what we normally do but I have to upload it into a system that doesn't recognized the file and the system requires CSV file... don't know how to do it because it's only me getting this issue when saving it as CSV

@Paulagiron1 

Either change your system settings to use point as decimal separator and comma as list separator, or change the delimiters in Excel:

  • Select File > Options.
  • Select Advanced.
  • In the Editing options section, clear the check box 'Use system separators', then specify point as decimal separator and comma as thousands separator.
  • Click OK.

CSV files that you save from now on should use comma as separator.

@Paulagiron1 

As variant you may add in front

image.png

perhaps your system will recognize it. In Excel if open initial file

image.png

if open the file with sep=;

image.png

Not all version of Excel and not all other systems support sep definition, even it is in CSV standard, but you may try.

the sep=; should go on the name?
I will change this and try, thank you

@Paulagiron1 

sep=;

shall the first line in the file. Most probably you need to add it manually in Notepad or so.

Please check in attached file.