I often like to work with two or more excel files side-by-side.
You can’t do this in the same session as you can only flip between files.
To have separate windows, you will need to run a separate copy of Excel and then browse to open the file in question.
Tip: If you have an icon for Excel in Win7/8, a quick way to run a separate copy is to hold Shift while you click.
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
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.