What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Forms with Chinese characters - I cannot export the results

    Asked by yvesfb on January 13, 2012 at 04:57 AM


    I made a form for Chinese target audience (http://www.jotform.com/13473650635) and one reply has been posted.

    When I export the form in Excel or CSV, I don't receive all the information, only the heading line (that I can read when transforming the csv in txt files and opening it as a text file) without the raw of data.

    1°) Any idea about the configuration to receive a full Excel file or a full CSV file?

    2°) ANy idea about the coding character set to use (because the Excel and CSV files I can download don't display properly).

    I send you the exported files if needed.

    Best Regards


    Page URL:

  • Profile Image

    Answered by fxr on January 13, 2012 at 01:29 PM

    Hello yves,

    I have downloaded your submissions and they show fine in MS Excel Viewer. 

    I am not sure of exactly where the setting for this is in Excel, but can you confirm you have the Chinese Simplified Language installed for MS Office?

    This may be a way to do that: 

    You can click Start >Programs>Microsoft Office Tools>Language Settings>Click on Chinese Simplified

    Then Add it


    If you are asked about character encoding always select UTF-8.


    Can you let me know if any of those 2 suggestions help.

  • Profile Image

    Answered by yvesfb on January 13, 2012 at 03:16 PM


    thank you for your feedback and support.

    I found the problem: it comes from the Excel version that I am using: EXCEL MAC 2011 (latest update). I tried under the emulated windows environment and Excel 2010 for windows (latest update as well under parallel desktop emulation), then I have the same result as you have. It works fine.

    So the file can not be properly read under Ecxel 2011 for MAC (even after having imported and saved it under windows). I also tried to use the CSV version and import it into excel using all the proposed Chinese encoding by Excel MAC, but it was not succcessful.

    So if I want to work on the data, then I will do it via the windows emulation. I don't know if you may have a possibility to report that to Microsoft, but it would be nicer to use the whole process without being obliged to switch between environments (or then we may simply use Apple's office tools without microsfot office for MAC).

    Remark: I just also open the generated report in excel format with the Apple Numbers application (the calc application of iWorks by Apple), and it works fine in the MAC environment.

    Best Regards


  • Profile Image

    Answered by fxr on January 13, 2012 at 03:26 PM

    I did a quick search on this issue of MS Office on MAC and it seems recurring and common problem. 

    Have a read of this -> http://www.yale.edu/chinesemac/pages/applications.html maybe something in there may help. 

    Personally, I prefer Open Office, a free alternative to MS Office as I find niggly little issues like the one you are suffering from less commonplace. 


  • Profile Image

    Answered by yvesfb on January 13, 2012 at 03:43 PM

    I agree with you about Open Office. :-)

    and thank you for your link about the Chinese language on MAC and office software packages.