Template Issues

How to Mail Merge Excel Data into a PDF Form

Emma Brown Oct 20, 2026 868 views

Question details

The user needs to transfer specific data (such as product names, stock information, and product codes) from an Excel spreadsheet into a branded PDF label template or PDF form.

How to Mail Merge Excel Data into a PDF Form

Product: Excel, Microsoft Word, Adobe Acrobat
Device & OS: not provided
Scenario: Creating customized PDF labels or forms in bulk by populating a template with data from a spreadsheet.
Observed behavior: Neither Excel nor standard Adobe Acrobat provides a direct built-in feature to merge spreadsheet data into PDF forms, requiring alternative methods to complete the task.

Before you start

Ensure your Excel data is properly organized with clear column headers (e.g., Product Name, Stock, Product Code) in the first row and no blank rows before starting the merge process.

Solution 1Recommended

Use Microsoft Word's Mail Merge Feature

Leverage Word's built-in mail merge capabilities to import Excel data, format your labels, and export the finalized document as a PDF.

While you cannot merge directly from Excel to PDF, Microsoft Word bridges the gap. You can set up your label template in Word, connect it to your Excel data, and print the results as a PDF.

Start the Mail Merge

Open Microsoft Word, go to the 'Mailings' tab, click 'Start Mail Merge', and select 'Labels' to configure your label layout.

Select the Data Source

Click 'Select Recipients', choose 'Use an Existing List', and browse your computer to locate and open your Excel spreadsheet.

Insert Merge Fields

Place your cursor in the first label and click 'Insert Merge Field'. Select the required fields (like product names and codes) from your Excel sheet to add them to the label.

Update All Labels

Once the first label is formatted correctly, click 'Update Labels' in the Mailings tab to apply the layout and fields to the rest of the page.

Merge and Export to PDF

Click 'Finish & Merge', select 'Print Documents', and choose 'Microsoft Print to PDF' (or a similar PDF printer) to save your generated labels as a PDF file.

Flexible Customization: Mail merge isn't just for names and addresses. You can use any data field from your Excel file and even incorporate IF statements for advanced customization.

Solution 2

Use Third-Party PDF Merging Tools

If you need to merge data directly into an existing interactive PDF form, use specialized PDF data integration tools or plugins.

Mail Merge Easily with WPS Office

WPS Office provides a seamless built-in Mail Merge feature in WPS Writer that flawlessly integrates with WPS Spreadsheet data, allowing you to generate labels and export them directly to PDF format instantly.

1. Prepare Your Template: Open WPS Writer and create or open your label template document.
2. Access Mail Merge: Navigate to the 'References' tab on the ribbon and click on 'Mail Merge' to activate the merging toolbar.
3. Connect the Spreadsheet: Click 'Open Data Source' and select the WPS Spreadsheet or Excel file containing your product and stock information.
4. Insert Data Fields: Click 'Insert Merge Field' to place your specific spreadsheet data into the appropriate spots on your label template.
5. Export as PDF: Click 'Merge to Printer', select a PDF virtual printer from your printer list, and save your fully populated labels as a single PDF document.

Easily merge spreadsheet data into text documents and labels.Highly compatible with Microsoft Office formats including DOCX and XLSX.Built-in PDF export feature to instantly save merged labels as high-quality PDFs.Lightweight, user-friendly interface that simplifies the merging process.

microsoft office alternative - wps office

Frequently Asked Questions

Can I mail merge directly from Excel to a PDF without using Word?

Excel lacks a built-in feature to merge data directly into a PDF document. You must either use Microsoft Word's Mail Merge function and save the result as a PDF, or rely on a specialized third-party PDF merging tool.

Does Adobe Acrobat have a native mail merge feature for Excel?

Standard versions of Adobe Acrobat do not have a native mail merge feature for Excel files. However, you can add this capability by purchasing and installing third-party plugins like AutoMailMerge.

Why aren't my Excel columns showing up during the mail merge?

This usually happens if your Excel file isn't formatted correctly as a database. Ensure your first row contains clear, unique column headers and that there are no empty rows or columns before your actual data begins.

Can I use IF statements in a mail merge for labels?

Yes, when using Microsoft Word's Mail Merge, you can use Rules like 'If...Then...Else' to customize the label output based on specific conditions found in your Excel data (e.g., printing 'Out of Stock' if the stock value is zero).

Document & File Issues