Converting Comma-Separated File in Excel
By default, reports are downloaded as CSV (Comma-Separated Value) files and opened in Microsoft Excel. If you open a report and it is comma-separated, then follow these instructions to convert it to general format.
This example task assumes the use of Microsoft Windows 7 with Microsoft Office 2007 Excel and Internet Explorer 9. Steps can vary with other operating system, browser and Excel combinations.
- Navigate to the file on your local system and open it in Excel.
- Navigate to the Data tab and click "Text to Columns".
- In the converter wizard screen step 1, choose "Delimited" and click Next.
- In the converter wizard screen step 2, select "Comma" and click Next.
- In the converter wizard screen step 3, select "General" and click Finish.
- Save.
The table results are converted to general format.
View the data in the Excel report.