Why is Excel showing the schedule data incorrectly or all in one column?
If your export shows all the data within one column, the problem is with how Excel is opening the file.
The data is getting exported in the .CSV file properly. However, it is not being interpreted correctly when you open it inside Excel. You can force Excel to treat the data differently and open the export as it should be presented. There a couple of different ways to do this and have all the data in the proper columns:
A. Save File to Desktop
- You will see a file called "report.csv."
- Open Excel and click on the File > Open option. Browse to the "report.csv" file saved to your computer.
- The Text Wizard prompt opens and follow these directions:
- Make sure that Delimited is selected and then click Next.
- On the next page, make sure that Comma is the only checkbox selected.
- Select Text in the next prompt.
- Click the Finish button to open it correctly.
B. Save File in Word and then Open in Excel
Another option is to do the following:
- Open the .csv file with MS Word. A prompt opens initially so just keep the default as "Unicode." You will not need to modify or change any settings here.
- Next save is as Text Only (.txt) in Word. You can save it to your desktop or in a folder on your computer.
- Open Excel and choose the File > Open prompt from the tool bar. Choose to open the ".txt" file that you saved in Word. The Text Import Wizard will open and you will go through the steps described above.
C. Open File on a Mac
If you are using a Mac, then you have to open Excel first and then go to the Data menu and select -> Import External Data -> Import Data.
You will be able follow the wizard from there to view the data correctly.