My CSV Export has Characters That Don't Display in Excel

Document created by 08b21bd4b65c4441fd72920f489da6afa097beae on Dec 29, 2014Last modified by 9588451ecc601f1a2620c0a3338f73ddec06dbf4 on Sep 27, 2017
Version 2Show Document
  • View in full screen mode

Your CSV exports with special characters (like foreign languages) may look funny when you open them in Excel.  This is due to a known problem in Excel; it does not correctly handle those characters if you open the CSV directly.

First, try these instructions to export your CSV file in Excel 2007 format:

 

Export a list

 

If that export is formatted incorrectly, try the following:

 

  1. Create a new Excel spreadsheet
  2. Open the Import External Data feature:
    • in Excel 2003 or earlier. open the Data menu, pick Import External Data, then pick Import Data
    • in Excel 2007, open the Data tab and pick From Text
  3. Pick the file you want to import.  The data import wizard will open
  4. In the dialog, select Delimited, then under File Origin pick "Unicode (UTF-8)" then click Next
  5. Select Comma and uncheck the other options. Click Next.
  6. Click Finish
  7. Follow the remaining steps and place the imported data in your spreadsheet

 

Your data should now look correct.

Attachments

    Outcomes