1



When my customers exports a CSV file of the current orders, the export seems very strange.
Here is a image that shows the layout of the CSV file: CSV file.
Any ideas what the problem could be?
Thanks in advance!

Improve this question

1 Answer 1

Reset to default
0

I think it might be because MS Office is using semicolon column separators for CSV format as default. Try changing it to commas, or use OpenOffice - it allows to choose which column separators to use before opening the document.

Improve this answer
2
  • Hi Dimitry, I tried this but it doesn't seem to work :(..
    – David
    Feb 16, 2015 at 8:00
  • Hi David. Only now I've managed to examine the screenshot - it looks a bit strange. It seems like there is used some extension which alters orders grid view, and adds href elements with "myparcel-consignment-*" classes. But anyway, line 33 of the screenshot shows that semicolons used as delimiters for inline CSS are treated as column delimiters in Excel. Which software have you tried for opening this document except MS Excel?
    – Dmytro
    Feb 16, 2015 at 10:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.