Hey everybody, I just posted a new video on how to change the delimiters when you create a CSV with Excel. By default you can only export to a comma-delimited file, but quite often you need a real delimiter. Unfortunately, you can do this from within Excel itself.
Anyway, here’s the link to the vid.
Enjoy.
any chance of putting a text based article on how to do this?
I am still amazed Excel does not allow to create CSV files with a choice of delimiters, most often the double-quote and comma “”, delimiters due to embedded commas in the Excel cells.
thanks