# Opening CSV reports with Excel

Reports downloaded from the Instructor Dashboard are by default in CSV format. 

*\*It is not possible to download the report in any other format than CSV.* 

CSV is a standard file known as "comma separated values" ​. Once you have downloaded your CSV file, you can ready it using Apple Notes, Microsoft Excel, Google Sheets or another suitable CSV file reader. 

Unfortunately Microsoft does not automatically convert .CSV files into .XLSX, and you must use their **Import Text Wizard**. This is also outlined and explained in more depth on the Microsoft website here ([reference URL](https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba))

## Open your MOOCit CSV Reports in Excel using the Import Text Wizard 

### Step One: 

Download the desired report from the instructor dashboard

![](https://670111484-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4y57zV2xVTpLls44ok%2F-M_zbeA_5cP9buNZlw3V%2F-M_zfdABHXKbHbYIxdT6%2FScreen%20Shot%202021-05-18%20at%2015.32.52.png?alt=media\&token=54a005fc-e7a3-488f-8254-a6ab3d020089)

### Step Two: 

Open Microsoft Excel. Select to "**Open"** and file, and then open the report. 

![](https://670111484-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4y57zV2xVTpLls44ok%2F-M_zbeA_5cP9buNZlw3V%2F-M_zhv08tHgZ0h1JVpy6%2FScreen%20Shot%202021-05-18%20at%2015.38.50.png?alt=media\&token=5e503c50-83ce-45ce-a85b-8a97aef1c10e)

### Step Three: 

Follow the Text Import Wizard to open the CSV file. Chose "**Delimited**" in step 1.

![](https://670111484-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4y57zV2xVTpLls44ok%2F-M_zbeA_5cP9buNZlw3V%2F-M_zi9vfu7b8JQAvmhUl%2FScreen%20Shot%202021-05-18%20at%2015.39.12.png?alt=media\&token=faef0bbc-e648-4fe9-9b7d-ebbaa93add77)

Select '**Next**'. 

In step 2 of the Text Import Wizard, Select "**Comma"** as the delimiters. 

![](https://670111484-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4y57zV2xVTpLls44ok%2F-M_zbeA_5cP9buNZlw3V%2F-M_zi6DhSZT4SJLEfkCu%2FScreen%20Shot%202021-05-18%20at%2015.39.58.png?alt=media\&token=ef723eaa-62d9-4819-999a-f14518ef1a50)

Finally in Step 3 you may simply select "Finish". 

![](https://670111484-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4y57zV2xVTpLls44ok%2F-M_zbeA_5cP9buNZlw3V%2F-M_zidIOB5KhdwRymYnb%2FScreen%20Shot%202021-05-18%20at%2015.40.45.png?alt=media\&token=ce9a70da-13df-46af-9c4e-24bd6c55d16c)

### Step Four: 

Your data has been transformed, now you can work with it in excel. You may want to save a new copy of your document in the .xlsx format. 

![](https://670111484-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4y57zV2xVTpLls44ok%2F-M_zbeA_5cP9buNZlw3V%2F-M_zk1r58WLeky-AYh2W%2FScreen%20Shot%202021-05-18%20at%2015.52.11.png?alt=media\&token=04ab088b-28d9-41c3-b78f-dd9fe2f54138)