Introducing The Law Community, the online community just for Clio customers. Sign up now.

How Do I Import CSV Files With Special Characters Into Excel?

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. 

 

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality