I was really happy that I wouldn't have to do something like this on my own but once I gave the script a shot the CSV produced was all messed up. The first column had almost all the data dumped into it. I've added a screenshot of what it looks like and a link to the csv as well. Would you please have a look and try to fix it? I'd appreciate it.
rednoah wrote:Make sure that you select ; as separator when importing the CSV file.
Excel 2016 doesn't allow me to do that from what I've gathered. I did find a solution on SuperUser that said that this is region dependent. So, if you've got some free time, would you please modify the script in such a way that we can specify what delimiter we can use and as a precaution, append sep=<selected seperator> to the first line to ensure proper compatibility. I've posted a link to the answer below. Please have a look and fix it if you can. Thank you!
You can just use Google Sheets instead. That'll let you define the separator when importing csv files. I'm inclined to change the separator to TAB through.
rednoah wrote:You can just use Google Sheets instead. That'll let you define the separator when importing csv files. I'm inclined to change the separator to TAB through.
That works! Although, is it difficult to change the script to add a user-defined delimiter? Too much work? I'm still inclined towards commas as they "just work". Will TABs work in the same way?