Adobe Acrobat Pro: How do I convert data (containing Thai characters) in fillable form to excel?

[Kornkamon Kamkom]

I have created a fillable form in Adobe Acrobat Pro. This form reqruies users to fill out the form in Thai and I am supposed to export the filled information by converting it to txt. file and get data in Excel, using Power Query to prepare those data in tables.

However, when importing the submitted form into Adobe Acrobat Pro and tried converting it to txt. file, the fields where users filled the information with Thai language are displayed as "........" instead of the actual Thai characters.

For example, in the section for an address, if I type "10/10 หมู่ 8 หมู่บ้านสลาลม," it will displayed as "......" instead (both in txt. file and in Excel). But, if I were to convert the file to RTF. file, Thai data was displayed and works perfectly there when open it in Microsoft Word.

-

Is there any solution for this problem? I have tried exported it to txt. file (plain) with UTF-8 in the preference setting but it still doesn't work. I have also tried changing and installing fonts that support Thai language but the resul remains such a failure. How can I export the file to txt. file properly? This is an urgent matter and I would appricate any input/suggestions. Thank you for your help!

[try67 · Accepted solution]

Export to XML, then open the XML file using Excel. It worked fine for me, although the field names were gone in the process, but their values remained in tact.

Another option is to export the data using a script to a UTF-8 (or 16) encoded text file.

[Kornkamon Kamkom]

Thank you for your input! You litterally saved my (coporate) life lol. 

Exporting to XML works like a charm! Your help is much appreciated.