Objective:

• Data exported from Clio looks wrong when imported
• Strange letters in Excel after pulling data from Clio

Environment:

• Microsoft Excel

Additional Information:

The steps listed below are for the Mac version of Excel. The PC steps should be similar, if not identical. 

Procedure:

1. In a new Worksheet in Excel click Data
2. Click From Text
3. Select the CSV
4. Click Get Data
5. Under File origin select Unicode (UTF-8)
6. Select the Delimitated option 
7. Click Next
8. Under Delimiters ensure Comma is the only one selected
9. Click Next
10. Click Finish
11. Select field A1 in the spreadsheet
12. Click OK

Once the file is opened, it can be Saved As and re-opened without difficulty.