In many cases all you can do is export your data to CSV format but what you really need is your data in the pretty Excel format.
So what is a CSV file?
CSV stands for Comma-Separated Values
Now you are like… and that means what?
It means that each value is separated by a value. Let’s do an example from Excel to CSV
Now if you have a CSV file that you want to open in Excel all you need to do is in Excel click File Open and browse to your CSV file and click Open. You may get a prompt that asks you what is your delimiter or separator and in your case its a comma so select that.
Click Next and Excel should open up with your .txt file or your .csv file all arranged in the columns and rows like you want it to be.
This is just a short summary of how to convert .csv or .txt to Excel.
In some cases when users are utilizing Office 365 at work, the Admin locks down the ability to open anything but Excel files. So what do you do in this instance?
Open your .csv or .txt file with notepad which should be allowed and select all and copy.
Now go to you Excel Office 365 and create a New Workbook
Click in the upper left corner cell and paste
Now it looks real ugly because everything will more then likely be in the first column but thats okay because we are going to fix that.
With column A selected, look at your toolbar across the top for Data and click on that then click on Split Text to Columns. Now you will get the display on what is your delimiter and you select comma and it typically gives you a preview. If that looks good then click OK you got your CSV imported into Excel.
