Category Archives: Microsoft Excel

Make Excel automatically divide and conquer your csv files

I have been working with power shell and creating .csv files for import with another script.

I need to work with my .csv in Excel to massage the data and was finding it annoying that Excel wouldn’t convert my comma separated data for me into columns. CSV stands for Comma Seperated Values doesn’t it??

I did some digging and found a line I now add to the top of my .csv that tell excel what my separation character is.

Add the line below to top of your output to get the same result

sep=,

You can interchange the comma with whatever character you prefer.

Note: depending where you are and the character you like, you may want to review your regional settings as some countries use comma to separate sections when writing currency values.