Forum Discussion
Paulagiron1
Jun 21, 2021Copper Contributor
Export CSV documents error
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.
<<Attachment re...
Detlef_Lewin
Jun 21, 2021Silver Contributor
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.
- Paulagiron1Jun 21, 2021Copper Contributorbut 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?