How to Create Individual 1095-C PDFs from Excel or Access Data
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.

- 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.
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.
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.
Open your word processor (like Word or WPS Writer) and set up your 1095-C form template as a standard document.
Navigate to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List' to import your Excel (.xlsx) or Access (.accdb) database.
Click 'Insert Merge Field' and map your spreadsheet columns (e.g., Employee Name, SSN) to the corresponding blank spaces on the 1095-C template.
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.
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.

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. 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. 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. 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. 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.

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.




