Document Editing Problems

How to Merge Text Data into a Converted Word Form

Rana Garcia Oct 22, 2026 869 views

Question details

The user wants to import or merge data from a plain text (TXT) file into a Word document form that was originally converted from a PDF.

How to Merge Text Data into a Converted Word Form

Product: Microsoft Word
Device & OS: not provided
Scenario: Filling out a converted Word form in bulk using data stored in an external TXT file.
Observed behavior: Adobe Acrobat does not support merging data into converted Word files natively, requiring the user to find alternative methods for auto-filling the Word document using text data.

Before you start

Ensure your TXT file is properly formatted as delimited text (using commas or tabs) and that the first row contains clear column headers so the word processor can accurately identify your data fields.

Solution 1Recommended

Use Mail Merge in Microsoft Word to Import TXT Data

Since PDF editors like Adobe Acrobat cannot merge data into exported Word files, you should use Microsoft Word's native Mail Merge feature to link your TXT data source to the document's form fields.

The Mail Merge feature allows you to connect a document to a database or text file. When merging a TXT file, Word relies on delimiters (like commas or tabs) to separate the data into recognizable columns.

Open the Word Form

Launch Microsoft Word and open the document form that you previously converted from a PDF.

Start Mail Merge

Go to the 'Mailings' tab on the top ribbon. Click on 'Start Mail Merge' and select 'Normal Word Document' or 'Letters' depending on your formatting needs.

Select the TXT Data Source

Click 'Select Recipients' and choose 'Use an Existing List'. Browse your computer to locate and select your prepared TXT file.

Configure Text Delimiters

If the File Conversion dialog appears, ensure the text encoding is correct and select the appropriate delimiter (comma, tab, or other) that matches your TXT file's formatting, then click 'OK'.

Insert Merge Fields

Place your text cursor in a form field or blank space where data belongs. Click 'Insert Merge Field' on the ribbon and select the corresponding column header from your TXT file. Repeat this for all form fields.

Finish and Merge

Click 'Preview Results' to verify the data looks correct. Finally, click 'Finish & Merge' and select 'Edit Individual Documents' to generate your filled forms.

Use Mail Merge in Microsoft Word to Import TXT Data

Using Excel as an Alternative: If you struggle with TXT delimiters, consider copying your text data into Microsoft Excel and saving it as an .xlsx file. Excel spreadsheets are often easier to link as a Mail Merge data source.

Merge Data Easily with WPS Writer

Use WPS Office to Seamlessly Merge TXT and Excel Data into Word Forms

WPS Office Writer includes a powerful, intuitive Mail Merge wizard that fully supports linking TXT, CSV, and Excel data to your Word documents. It provides a simple, highly compatible environment for managing form letters and bulk data entry.

1. Open the Form in WPS Writer: Launch WPS Office and open your converted Word document.
2. Access Mail Merge: Navigate to the 'Mailings' tab on the top ribbon and click the 'Mail Merge' button to reveal the merge toolset.
3. Open Data Source: Click 'Open Data Source', browse for your TXT or Excel file containing the form data, and open it.
4. Insert Merge Fields: Click exactly where you want data to appear in your document, click 'Insert Merge Field', and choose the appropriate data category.
5. Merge to New Document: Once all fields are inserted, click 'Merge to Different New Document' to output your fully populated form files.

Fully compatible with Microsoft Word (.docx) formats and converted PDF formsEasily import bulk data from TXT, CSV, and Excel filesIntuitive Mail Merge wizard for quick and accurate setupFree, lightweight, and fast word processing alternative

microsoft office alternative - wps office

Frequently Asked Questions

Can Adobe Acrobat directly merge TXT data into a Word file?

No, Adobe Acrobat is designed to manage and edit PDF files. Once you convert a PDF form to a Word document, you must use a word processor like Microsoft Word or WPS Writer to handle the data merge process.

How should I format my TXT file for a mail merge?

Your TXT file should be formatted as delimited text. The first row must contain column headers (e.g., Name, Address, Date), and each subsequent row should contain the corresponding data separated by commas or tabs.

Can I use an Excel file instead of a TXT file for merging data into a Word form?

Yes. In fact, importing data from an Excel spreadsheet (.xlsx) or CSV file is highly recommended and often easier to manage than a plain TXT file when using the Mail Merge feature in Word or WPS Writer.

Why are my inserted merge fields showing raw code instead of data?

You might have field codes toggled on. In Microsoft Word or WPS Writer, you can press Alt + F9 to toggle your view between the underlying field codes (e.g., { MERGEFIELD Name }) and the actual merged data.

Document & File Issues