Exporting to csv does not work well
-
When I tried exporting the signature file to csv and opened it with Excel, it did not break into columns as it should, each row was just one column, with the data separated by quotes and commas. I think it’s the quotes that confuses Excel, usually there are only commas in a csv.
I was able to get it to work by first renaming the file with a “.txt” extension, then opening that with Excel. That gives you the option of choosing the delimiter, which it normally finds automatically, but because of the quotes (I assume), it does not. But if you choose comma during that process, it will open it properly, separated into columns, then you can save it as a .csv (or .xlsx) file.
Another person tried it on their machine as well (mine is Windows, theirs is Mac), and had the same problem. I have exported csv files from many plugins and had them work perfectly, so I know it’s not me.
Please change the export to not use quotes, or fix the problem in whatever way works.
The topic ‘Exporting to csv does not work well’ is closed to new replies.