Home - Information Services - Get Help - How-to-Guides - Report Manager - Export Report Data - Export Report Data to a CSV File

Export Report Data to a CSV File

1. After you run the report, click the Select a format down arrow and select CSV (comma delimited).
   
   
2. Click Export.
3. Click Save. (Do not click Open.)
   
   
4. Save the CSV file to your computer.
5. Open Excel.
6. On the File tab, click Open.
7. Across from File name, click the down arrow and select All Files.
   
   
   
8. Select the CSV file.
9. Click Open. The Text Import Wizard appears.
   
10. On the Text Import Wizard, make sure that Delimited is selected.
    
    
11. Click Next.
12. Uncheck the Tab checkbox and select the Comma checkbox.
    
    
    
13. Click Next.
14. Click Finish.
15. On the File tab, click Save As.
16. In the File name field, enter a file name.
17. Click the Save as type down arrow and select Excel Workbook. (This is the first option in the drop-down list.)
    
    
18. Save the Excel file to the desired location on your computer.