Home - Accompa  |  Home - Online Help
Home > Miscellaneous Questions > How can I get Excel to properly display accented c...
   

How can I get Excel to properly display accented characters in the CSV file saved from Accompa?

 Print This

Accompa creates CSV files that are compliant with the UTF-8 standard. We do this to ensure that it works well for our customers using different operating systems and different software packages to process these CSV files, and to ensure that the processed CSV files can be imported back into Accompa.

If you use Microsoft Excel to open the CSV files, everything works fine when the file contains just English characters. However, you may run into an issue when your CSV file also contains non-English characters (such as é, ç, ü, etc):

  • Microsoft Excel is unable to properly display UTF-8 compliant CSV files when they contain non-English characters.

To resolve this issue, please do the following after saving the CSV file from Accompa.

On a Windows machine:

Method 1

  • On a Windows computer, open the CSV file using Notepad.
  • Click "File > Save As".
  • In the dialog window that appears - select "ANSI" from the "Encoding" field. Then click "Save".
  • That's all! Open this new CSV file using Excel - your non-English characters should be displayed properly.

Method 2

  • On a Windows computer, click "File > New" in Excel.
  • Click "Data" tab.
  • Then click "From Text" option. Select the CSV you file you saved from Accompa.
  • Excel will display "Text Import Wizard".
  • In step-1 of this wizard:
    • Select "Delimited" radiobutton.
    • In "File origin" field - select "65001 : Unicode (UTF-8)".
  • Click "Next >" button.
  • In step-2 of this wizard:
    • Select "Comma" checkbox.
  • Click "Finish" button.
  • In the dialog window that appears - click "OK" button.
  • Excel will display your CSV file - including non-English characters - properly.

On a Mac:

Use the "Numbers" application instead of Excel.

 
You may also be interested in...
Search Online Help
 
Top-5 Articles
1. What is a "SmartView"?
2. I forgot my password. Can you help?
3. What are "SmartForms"?
4. How can I customize Accompa?
5. How do I login to my Accompa account?
 
Look Up Terminology
Glossary
 
Contact Support
Contact Accompa Support
   
   
Home - Requirements Management Software - Terms of Service - Privacy Policy
© Accompa, Inc. 5201 Great America Pkwy, Ste 320, Santa Clara, CA 95054 (United States)