AllisonKrause Posted November 13, 2019 Share Posted November 13, 2019 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? Link to comment Share on other sites More sharing options...
Arwen Serpente Posted November 13, 2019 Share Posted November 13, 2019 Try downloading the xcf file instead. Xcf is the native format for excel and will organize the data in different columns and rows. Link to comment Share on other sites More sharing options...
AllisonKrause Posted November 13, 2019 Author Share Posted November 13, 2019 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. Link to comment Share on other sites More sharing options...
Arwen Serpente Posted November 13, 2019 Share Posted November 13, 2019 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. Link to comment Share on other sites More sharing options...
Fritigern Gothly Posted November 14, 2019 Share Posted November 14, 2019 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. Link to comment Share on other sites More sharing options...
animats Posted November 14, 2019 Share Posted November 14, 2019 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. 1 Link to comment Share on other sites More sharing options...
AllisonKrause Posted November 14, 2019 Author Share Posted November 14, 2019 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. Link to comment Share on other sites More sharing options...
Kardargo Adamczyk Posted November 14, 2019 Share Posted November 14, 2019 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Please take a moment to consider if this thread is worth bumping.
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now