Fix Tab-Delimited Excel File Not Populating PDF Form Fields
Question details
The user is attempting to populate an Acrobat PDF form using a tab-delimited text file exported from Excel, but the form fields remain empty after import.

- Product
- Adobe Acrobat and Microsoft Excel
- Device & OS
- macOS High Sierra
- Scenario
- Importing exported spreadsheet data into a PDF document to auto-fill form fields.
- Observed behavior
- The PDF form fields do not populate upon importing the tab-delimited file, despite the source data and form fields appearing to match.
Ensure you have editing permissions for the PDF form, and keep a backup copy of your original Excel spreadsheet before making any structural or formatting changes.
Perfectly Match Column Headers to Form Fields
Verify that the column headers in your tab-delimited file exactly match the field names defined in the PDF form, as Acrobat requires a strict 1:1 match.
Acrobat's import function is highly sensitive to text formatting. If there is even a minor discrepancy between the spreadsheet's column header and the PDF's field name, the data will not populate.
Open the PDF document in Acrobat, enter 'Prepare Form' mode, and double-click the fields to view their exact 'Name' properties.
Open your original Excel file and review the first row of data. Ensure the text exactly mirrors the PDF field names, including capitalization, spaces, and punctuation.
Save the corrected Excel file as a Tab-Delimited Text file, then attempt to import the data into the Acrobat PDF form again.

Clean Up Data Formatting and Delimiters
Remove unsupported characters, extraneous tabs, or quotation marks that might break the data import process.
Verify Field Properties and Run a Sample Test
Confirm the PDF fields are not restricted and create a minimal test file to isolate the problem.
Try WPS Office for Seamless Document Management
If you're tired of troubleshooting integration issues between different software platforms, WPS Office provides an all-in-one suite. Easily create, edit, and manage spreadsheets and PDFs in a single lightweight application without complex cross-platform formatting glitches.
- 1. Download and Install: Get the free version of WPS Office from the official website and install it on your Mac or PC.
- 2. Open Spreadsheets and PDFs: Use WPS Spreadsheet to manage your data and WPS PDF to view and interact with forms within the same application ecosystem.
- 3. Enjoy Seamless Compatibility: Work with standard document and PDF formats without losing formatting or dealing with complex cross-software workflows.

Frequently Asked Questions
Can I use a CSV file instead of a tab-delimited file to populate a PDF form?
Acrobat's standard form data import functionality typically requires tab-delimited text files (.txt) rather than comma-separated values (.csv). You must explicitly choose the Tab-Delimited export option in Excel.
Why does Acrobat say my tab-delimited file format is unrecognized?
This usually happens if the file was saved with incorrect text encoding or if it contains hidden formatting characters. Saving it strictly as a plain Tab-Delimited text file without a UTF-8 BOM can resolve this.
How do I find the exact field names in my PDF form?
Open your PDF in Acrobat, go to 'Prepare Form' mode, and double-click individual fields. The 'Name' property found in the General tab is the exact string you must use as your column header in Excel.
Does this form import issue only affect macOS High Sierra?
No, while this specific scenario was reported on macOS High Sierra, formatting mismatches and invisible characters in exported Excel files can cause PDF form import failures on any operating system, including Windows and newer macOS versions.




