Forum Discussion
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...
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.
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?