PDF Conversion Issues

How to Create Individual 1095-C PDFs from Excel or Access Data

Maira MehtabMaira Mehtab Nov 2, 2026 870 views

Question details

The user needs a method to populate IRS Form 1095-C PDFs for multiple employees using data stored in Excel or Access without manually importing each record.

How to Create Individual 1095-C PDFs from Excel or Access Data
Product
PDF Editors and Word Processors
Device & OS
not provided
Scenario
Generating employee tax forms in bulk by pulling records from a spreadsheet or database into individual PDF files, then merging them for distribution.
Observed behavior
Automating the creation of one completed PDF per employee from a data source and combining the final files into a single master PDF document.
Before you start

Ensure your Excel or Access database is properly formatted with clear column headers that correspond exactly to the required fields on Form 1095-C before initiating the merge process.

Solution 1Recommended

Use Word Mail Merge and Combine the PDF Files

Use the mail merge feature in your word processor to generate the filled 1095-C forms from your Excel data, export them to PDF, and then merge them.

Since standard PDF readers cannot easily pull data directly from Excel or Access databases in bulk without advanced scripting, a two-pass process is the most efficient method. First, you create the individual forms via Mail Merge, and second, you merge those outputs into one PDF.

1
Prepare the 1095-C template

Open your word processor (like Word or WPS Writer) and set up your 1095-C form template as a standard document.

2
Connect your data source

Navigate to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List' to import your Excel (.xlsx) or Access (.accdb) database.

3
Insert merge fields

Click 'Insert Merge Field' and map your spreadsheet columns (e.g., Employee Name, SSN) to the corresponding blank spaces on the 1095-C template.

4
Export individual PDFs

Click 'Finish & Merge' to generate the individual documents. Once generated, go to 'File' > 'Export' (or Save As) and choose the PDF format to save the individual forms.

5
Combine the PDFs

Open Adobe Acrobat or WPS PDF, select 'Combine Files' or 'Merge PDF', add all the individual employee 1095-C PDF files you just created, and save them as a single master PDF.

Use Word Mail Merge and Combine the PDF Files
Suitable for Employee Copies: This workflow is perfect for generating printed or digital copies for employees when direct electronic filing through dedicated IRS software is not strictly required.
All-in-One Document Workflow

Automate 1095-C Form Generation with WPS Office

WPS Office seamlessly integrates powerful Mail Merge capabilities with advanced PDF editing. You can easily link your Excel data to a Writer document, export to PDF, and merge the final documents all within one lightweight software suite.

  1. 1. Link Data in WPS Writer: Open your 1095-C template in WPS Writer, go to the 'References' tab, click 'Mail Merge', and select 'Open Data Source' to load your Excel database.
  2. 2. Insert Fields and Merge: Use 'Insert Merge Field' to place data into the form. Click 'Merge to New Document' to generate the completed forms for all employees.
  3. 3. Export to PDF: Click 'Menu' in the top-left corner, select 'Export to PDF', and save the newly populated documents as individual PDF files.
  4. 4. Merge Final PDFs: Open WPS PDF, click on 'Merge PDF' from the toolkit, select all the individual employee forms, and click 'Merge' to create your single master file.
Perform robust Mail Merge operations linking WPS Spreadsheet data to WPS Writer templates.Directly export merged documents to high-quality PDF files without needing third-party plugins.Easily combine hundreds of individual employee PDFs into one file using the built-in WPS PDF Merge tool.Fully compatible with Microsoft Word (.docx), Excel (.xlsx), and standard PDF formats.
microsoft office alternative - wps office

Frequently Asked Questions

Can I automatically populate the official IRS PDF directly from Excel?

Standard PDF applications do not natively support importing Excel data directly into PDF form fields in bulk. The most reliable workaround is to use the Mail Merge feature in a word processor to link the Excel data, generate the documents, and then export the result to PDF.

How do I combine hundreds of individual employee PDFs into one document?

You can use a dedicated PDF merger tool. In Adobe Acrobat, use the 'Combine Files' tool. In WPS Office, open WPS PDF, select 'Merge PDF', add your folder containing the individual 1095-C files, arrange them if necessary, and output them as a single file.

Does the Mail Merge method support Microsoft Access databases?

Yes. When setting up your Mail Merge in word processors like Microsoft Word or WPS Writer, you can select 'Use an Existing List' and navigate to your Microsoft Access (.accdb or .mdb) file to use it as the data source.