Opening the file ( the same dish.csv file) with OpenRefine, the default column separator is on "customer" which shows the data like a csv and not in a table and Chenging it to "commas(CSV)" messes up all the column completely. What I'm doing wrong here?
It's probably a bit late, but maybe helpful for others: Don't open the CSV file in Excel. In some countries Excel uses Commas for decimal numbers (instead of a dot like in the US) and doesn't understand the meaning of the commas in a CSV-file. Opening the file in Excel will corrupt it, and that's why the file shows up completely wrong in OpenRefine. Use an Editor instead to open and editn the file.
Much better than reading instructive blog posts, thanks!
Thanks dear for this nice introduction.
Hi! A lot of thanks to this video. Very helpful. Learned a lot even to this single video. 😇👌 🙇
Awesome! Thank you so much!
Thank you so much for this.
I wonder you're cutting dataset in MS Excel while openrefine can do it well.
Thanks Sarah!!
Opening the file ( the same dish.csv file) with OpenRefine, the default column separator is on "customer" which shows the data like a csv and not in a table and Chenging it to "commas(CSV)" messes up all the column completely. What I'm doing wrong here?
It's probably a bit late, but maybe helpful for others: Don't open the CSV file in Excel. In some countries Excel uses Commas for decimal numbers (instead of a dot like in the US) and doesn't understand the meaning of the commas in a CSV-file. Opening the file in Excel will corrupt it, and that's why the file shows up completely wrong in OpenRefine. Use an Editor instead to open and editn the file.