Fix Thai Characters Appearing as Dots When Exporting PDF Form Data
Question details
Users encounter dots instead of readable Thai characters when exporting data from PDF forms.
- Product
- PDF Editors
- Device & OS
- not provided
- Scenario
- Exporting form data containing Thai characters from a PDF file to view or process in another application.
- Observed behavior
- Exported Thai text renders as dots in the viewing application, indicating a failure to process or display Unicode characters.
Ensure you have a modern text editor or spreadsheet application installed that fully supports Unicode (UTF-8) encoding and contains standard Thai fonts.
Import Data using UTF-8 Encoding in a Supported Application
The dots appear because the viewing application fails to read Unicode characters properly. Forcing a UTF-8 import in a spreadsheet or opening it in a Unicode text editor resolves this.
The underlying exported form data is usually intact. The issue is purely a display or import error caused by the viewer defaulting to a non-Unicode encoding (like ANSI) instead of UTF-8.
Export the PDF form data as usual and save the resulting file (typically a CSV or TXT) to your local drive.
Open a spreadsheet program (like WPS Spreadsheet or Microsoft Excel) rather than double-clicking the file directly. Go to the 'Data' tab and choose 'Import Data' or 'From Text/CSV'.
In the Text Import Wizard, select 'Delimited' and change the File Origin or Encoding dropdown to 'UTF-8' (or '65001: Unicode (UTF-8)').
Finish the import wizard. Select the imported cells and ensure the font is set to one that supports Thai scripts, such as Tahoma, Arial Unicode MS, or Leelawadee.
Use a Modern Code Editor to Verify the Data
If you just need to quickly verify the exported data, a dedicated code editor will automatically detect the Unicode encoding.
Handle PDF Form Data and Encodings with WPS Office
WPS Office provides an all-in-one suite for managing PDFs, exporting form data, and viewing complex characters accurately. With WPS Spreadsheet, you can easily import UTF-8 data to display Thai characters without encoding glitches.
- 1. Open WPS Spreadsheet: Launch WPS Office and create a new blank spreadsheet.
- 2. Navigate to Import Data: Click on the 'Data' tab in the top ribbon and select 'Import Data'.
- 3. Select the Exported File: Choose the CSV or TXT file exported from your PDF form.
- 4. Apply UTF-8 Encoding: In the import dialog, select 'UTF-8' as the file origin to ensure the Thai characters are imported and displayed correctly.
Frequently Asked Questions
Why do specific characters turn into dots or question marks in CSV files?
This happens when the CSV is opened in a program that defaults to ANSI or another localized encoding instead of UTF-8. The program fails to decode the Unicode characters and replaces them with replacement characters like dots or question marks.
Can I fix the dots by just changing the font?
Changing the font only helps if the file was opened with the correct UTF-8 encoding but the current font lacks Thai glyphs. If the encoding was read incorrectly during import, changing the font will not restore the missing characters.
How do I ensure my PDF forms save Thai characters correctly?
When creating or filling out the PDF form, make sure to use standard Unicode fonts for the form fields. This ensures that the data is stored in a standardized format ready for an accurate export.
