Exporting CSV files to Microsoft Excel

If you have exported a Report from DDHAPT, you will probably want to open it with MS Excel in order to carry out additional analysis. In order to do this, follow the following steps (valid for MS Excel 2010):

1. Open Microsoft Excel
2. Click on the “Data” tab
3. Click on the “From Text” icon from the “Get External Data” subgroup
4. Navigate to the CSV file in question using the MS file selector; select the file in question, and click “Import”
   1. This will open the “Text Import Wizard”
5. Step 1 of 3: The default settings should be fine (“Delimited” file type selected, Start import at row: 1) – click on “Next >”
6. Step 2 of 3: Check the “Comma” box under the “Delimiters” column
7. Click “Finish” (Step 3 is not necessary)
8. An “Import Data” input box pops up – simply click “OK” to complete the import process
9. Select “File” – “Save” in order to save the report as an Excel spreadsheet (.xlsx or .xls)