Jun 21 2021 11:12 AM
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.
Jun 21 2021 11:33 AM
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.
Jun 21 2021 11:47 AM
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.
Jun 21 2021 12:01 PM
Jun 21 2021 12:02 PM
Jun 21 2021 12:21 PM
Either change your system settings to use point as decimal separator and comma as list separator, or change the delimiters in Excel:
CSV files that you save from now on should use comma as separator.
Jun 21 2021 12:24 PM
As variant you may add in front
perhaps your system will recognize it. In Excel if open initial file
if open the file with sep=;
Not all version of Excel and not all other systems support sep definition, even it is in CSV standard, but you may try.
Jun 21 2021 01:20 PM
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.