Generating a simple CSV file, opens in excel all on one line?

This is a quick post to help out my fellow programmers out there. When generating a csv file, using php or other languages, its a good idea to stipulate the delimiter type. If this not done you might end up with the data loading on one line, instead of in its separate cells. To do this add the following to the first line of the 'text' document.

"sep=," #for comma separated or 
"sep=\t" #for tabs


Read more
Posted date: 30th May 2018
General Help and Tips