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:
- In a new Worksheet in Excel click Data
- Click From Text
- Select the CSV
- Click Get Data
- Under File origin select Unicode (UTF-8)
- Select the Delimitated option
- Click Next
- Under Delimiters ensure Comma is the only one selected
- Click Next
- Click Finish
- Select field A1 in the spreadsheet
- Click OK
Once the file is opened, it can be Saved As and re-opened without difficulty.