Home - Accompa  |  Home - Online Help
Home > Miscellaneous Questions > Can I import an Excel file containing Japanese or ...
   

Can I import an Excel file containing Japanese or Chinese characters?

 Print This

Do you need to import an Excel (or other spreadsheet) file that contains Japanese or Chinese characters?

As long as you can create a CSV file with UTF-8 (also referred to as "Unicode - UTF8") encoding - you can import it without any problems. The Japanese and Chinese characters characters will be saved properly within Accompa.

If you're using Microsoft Excel to create your CSV file, you may run into an issue:

  • When you're using Japanese or Chinese characters - Microsoft Excel does not generate a UTF-8 compliant CSV file that retains the Japanese and Chinese characters.

To resolve this issue, please do the following:

  • Download OpenOffice - this is a free, open-source office suite, much like "Microsoft Office". It will take a while to download. After the download completes, install it on your PC.
    • If your company prevents downloading/installing software, you may have to do this on your home PC.
  • Open your Excel file with "OpenOffice Calc".
    • "Calc" is the spreadsheet program in the OpenOffice suite - i.e. their equivalent of Excel.
  • Click "File > Save As", and select "Text CSV (.csv)" as File Type. Then, click the "Save" button.
  • In the dialog box that appears, select "Unicode (UTF-8)" in the "Character set" field. Then click "OK".
    • A proper CSV file will be created, with UTF-8 encoding and retaining all Japanese and Chinese characters.
  • Now import the CSV file into Accompa - we recommend doing a test run with just 5 requirements first, before importing the entire CSV file.

The reason this works is - OpenOffice properly creates UTF-8 encoded CSV files containing Japanese or Chinese characters. Excel does not seem to create proper CSV files in this scenario.

 
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)