Friday, December 20, 2013

Automatic Sorting columns .csv file for Microsoft Excel using the line separator sep =,

Jornals and the results of scripts is very convenient to keep in format csv, and then opened in Microsoft Excel for easy sorting / filtering. However, the data in the columns may contain separator and Microsoft Excel in this case correctly divide the data by columns. But if in the csv file to insert first row "sep=," (or "sep=;") where "," delimiter opens all wonderful.

No comments:

Post a Comment