Converting Comma-Separated File in Excel

Before you start

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.

Here's what to do

1. Navigate to the file on your local system and open it in Excel.
2. Navigate to the Data tab and click "Text to Columns".
3. In the converter wizard screen step 1, choose "Delimited" and click Next.
4. In the converter wizard screen step 2, select "Comma" and click Next.
5. In the converter wizard screen step 3, select "General" and click Finish.
6. Save.

Results:

The table results are converted to general format.

What to do next

View the data in the Excel report.