Orders CSV fields broken?

[AllisonKrause]

I used to check my monthly store profits loading the CSV file with orders for the month, and calculating all in Excel.
Last time I load it, all seems broken, now each order is in one line taking one field, separated by commas which makes it unusable.
Seems something broken. It's impossible to do any analytics on that now.

All of that should be in different fields each.

How to fix that if anyone knows?

[Arwen Serpente]

Try downloading the xcf file instead. Xcf is the native format for excel and will organize the data in different columns and rows.

[AllisonKrause]

1 minute ago, Arwen Serpente said:

Try downloading the xcf file instead. Xcf is the native format for excel and will organize the data in different columns and rows.

There is only CSV or Txn CSV, both broken.

[Arwen Serpente]

So sorry. I thought it was a download from the dashboard. There are csv to xcf converters - Google that and there should be a free one you can use.

[Fritigern Gothly]

You do realize that CSV stands for Comma Separated Values, right?
So this should tell you that you are NOT importing the CSV file as a CSV file.

Check your workflow and try again.

[animats]

Excel can load a CSV file and put into columns. If that's not happening, with a file that consists of fields separated by commas, you have some kind of problem in Excel. An Excel forum might be more helpful. There are more Excel users than the population of major countries, so expertise there is not hard to find.

[AllisonKrause]

Okay, found the problem, seems Excel after some updates just stopped making CSV information into columns itself.
So all you have to do now is to make it manually.

[Kardargo Adamczyk]

Hiya Alisson, pls search google for "excel legacy text import" once activated you will be able to import csv as usual with the legacy import wizzard