How to Import TXT or CSV Data into an Acrobat PDF Form
Question details
The user wants to import TXT or CSV data into an Acrobat PDF form but finds these formats unavailable in the form-data import dialog.
- Product
- Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Attempting to populate a PDF form directly with external text or spreadsheet data.
- Observed behavior
- TXT and CSV file options are missing in the Acrobat form-data import dialog, leading the user to suspect a trial version restriction.
Verify whether your PDF form was created in standard Acrobat or Adobe LiveCycle Designer, as this determines the supported data import formats (FDF/XFDF vs. XML).
Convert Source Data to a Supported Format
Convert your TXT or CSV data into FDF, XFDF, or XML to use the standard Acrobat user interface for importing form data.
Acrobat's standard user interface natively supports importing data from FDF (Forms Data Format) or XFDF files, not TXT or CSV. If you are working with a LiveCycle Designer form, it is an XML form and will only accept XML data.
The absence of TXT and CSV options is a standard feature limitation, not a restriction of the trial version, which functions identically to the full software.
Check your form's properties to see if it is a standard Acrobat PDF or a LiveCycle Designer XML form.
Use a spreadsheet program or a dedicated conversion script/utility to save your CSV or TXT data as an FDF, XFDF, or XML file based on your form's requirements.
In Acrobat, go to the Prepare Form tool, click 'More', select 'Clear Form' if needed, and then choose 'Import Data'. Select the newly converted FDF, XFDF, or XML file to populate the form fields.
Use JavaScript to Import Text Data Directly
Utilize Acrobat's JavaScript API with the Doc.importTextData method to bypass the UI limitations and import TXT or CSV data.
Handle PDF Forms and CSV Data with WPS Office
WPS Office provides a complete suite including WPS PDF and WPS Spreadsheet, allowing you to easily view CSV data and interact with PDF forms within the same application.
- 1. Open CSV in WPS Spreadsheet: Launch WPS Office and open your TXT or CSV file in WPS Spreadsheet to easily read and organize your data.
- 2. Open the PDF Form in WPS PDF: Switch to the PDF tab in WPS Office and open your target PDF form document.
- 3. Fill the Form: Copy the required data from your open spreadsheet and use the 'Fill & Sign' or interactive form tools in WPS PDF to complete the document, then save your changes.
Frequently Asked Questions
Why is my Acrobat trial not showing TXT or CSV import options?
The trial version has full functionality. The limitation is inherent to the Acrobat user interface, which only accepts FDF or XFDF files for standard forms, and XML for LiveCycle forms. It does not support direct TXT or CSV imports through the standard dialog.
What is an FDF or XFDF file?
FDF (Forms Data Format) and XFDF (XML Forms Data Format) are standard file formats used specifically to export and import data from PDF forms efficiently without including the entire PDF document.
How do I know if my PDF is a LiveCycle XML form?
If you try to import data and only see XML as an available file type option in the form-data import dialog, the PDF was likely created in Adobe LiveCycle Designer and functions essentially as an XML form.
