Fix Missing Tab-Delimited TXT Option When Importing Form Data in Acrobat
Question details
The user is unable to locate the tab-delimited text format option when trying to import Excel spreadsheet data into a fillable PDF form.

- Product
- Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Importing tabular data exported from Microsoft Excel into a fillable PDF form in Adobe Acrobat.
- Observed behavior
- The 'Tab-Delimited Text' option is completely missing or greyed out in the import file format dropdown menu.
Verify whether your PDF form is a standard AcroForm or an XFA/LiveCycle form, as XFA forms use a different data structure and typically restrict flat text imports.
Use Alternative Supported Data Formats (XFDF, FDF, XML)
If tab-delimited text is not supported by your specific PDF form structure, converting your Excel data into widely accepted formats like XML or FDF will bypass the limitation.
The available import formats depend heavily on the internal form architecture and the Acrobat version you are using.
Standard AcroForms usually support tab-delimited text, FDF, XFDF, and XML. In contrast, XFA forms (created via Adobe LiveCycle) have stricter data requirements and often only accept XML.
Open your PDF in Acrobat, go to 'File' > 'Properties' (or press Ctrl+D), and check the 'Description' tab to see if it lists XFA or LiveCycle.
If you are working with an XFA form, open your data in Excel, go to the Developer tab, map your XML schema, and click 'Export' to save the data as an XML file.
In Acrobat, select 'Prepare Form' from the Tools pane, click 'More' (or the options icon) in the right-hand panel, choose 'Import Data', and select your generated XML or FDF file.

Ensure Proper Excel to TXT Export
If your form is a standard AcroForm but the import still fails, the issue might stem from incorrectly formatted tab-delimited text.
Automate Data Import with JavaScript
Use an Acrobat JavaScript snippet to force the data import dialog or batch process forms when GUI options are restricted.
Easily Manage, Edit, and Fill PDF Forms with WPS Office
Dealing with complex form compatibility issues can be frustrating. WPS Office features a powerful built-in PDF editor that works seamlessly alongside spreadsheets and documents, making it incredibly easy to fill standard PDF forms, manage data, and convert files in just a few clicks.
- 1. Open Your PDF Form: Launch WPS Office and open your fillable PDF form directly within the WPS PDF tool.
- 2. Fill the Form Fields: Navigate to the 'Form' tab to actively highlight and directly type into all standard AcroForm text fields.
- 3. Export and Manage Data: Use the versatile 'PDF to Excel' or 'Excel to PDF' conversion tools under the 'Tools' tab to manage your tabular data without dealing with complex XML or TXT imports.

Frequently Asked Questions
What is the difference between AcroForm and XFA forms?
AcroForms are standard, widely supported PDF forms natively built into Acrobat. XFA (XML Forms Architecture) forms were created using Adobe LiveCycle; they use complex XML data structures, have stricter compatibility rules, and usually do not support flat text (TXT) data imports.
How do I correctly save Excel data as a tab-delimited text file?
Open your dataset in Microsoft Excel or WPS Spreadsheets. Go to File > Save As, select your desired folder, and choose 'Text (Tab delimited) (*.txt)' from the 'Save as type' dropdown menu. Make sure the first row contains your exact PDF field names.
Can I import a CSV file directly into a PDF form?
Acrobat's native data import tool does not directly support CSV files for single-form import. You must convert the CSV file into a Tab-Delimited TXT, XML, or FDF format first, or use a batch processing script in Acrobat Pro.
Why does Acrobat say my form fields do not match during import?
This error happens when the column headers in your imported text or XML file do not perfectly match the internal field names of your PDF form. You must verify that capitalization, spacing, and spelling are identical.




