Excel to PDF Mapper helps you turn rows from an Excel or CSV file into finished PDF documents. Instead of typing the same information again and again, you upload a template, choose the columns you need, place them on the PDF, and generate a separate PDF for each row. It is useful for certificates, invoices, receipts, letters, ID forms, labels, reports, and any document where the layout stays the same but the details change.
What Excel to PDF Mapper does
The tool connects your spreadsheet data to a PDF template. For example, one row in Excel may contain a name, address, date, amount, reference number, and email address. You can place each value exactly where it should appear on the PDF. When you generate the files, the first row becomes the first PDF, the second row becomes the second PDF, and so on.
- Use Excel or CSV data as the source for your PDF fields.
- Place values visually by clicking on the PDF preview.
- Format text with font, size, colour, and style options.
- Format dates in a clear way, such as dd/mm/yyyy or with time included.
- Create file names automatically from column values, fixed text, and numbers.
- Save your mapping settings so you can reuse the same layout later.
Before you start
You need two things: a template document and a data file. The template is the PDF you want to fill. The data file is your Excel or CSV file with one record per row. Keep the spreadsheet simple: use clear column names, avoid empty rows in the middle, and check that dates and numbers look correct before uploading.
Tip: If your spreadsheet has values like 97, keep them as whole numbers in Excel when possible. This helps the final PDF show 97 instead of 97.0.
How to convert Excel data to PDF step by step
- Open the Excel to PDF Mapper tool. Go to the mapper page and start with your blank PDF template.
- Upload your PDF template. This is the document layout that will receive the Excel values.
- Upload your Excel or CSV file. The tool reads the columns and shows them so you can choose what to place on the PDF.
- Select a column. Choose the column you want, such as Name, Date, Amount, Address, or Reference.
- Click on the PDF preview. The selected column is placed where you click. You can move it and resize it until it fits.
- Set the text style. Choose the font, size, colour, and style. These settings can continue to the next field until you change them.
- Format dates if needed. If a column looks like a date, choose the display format you want, such as dd/mm/yyyy, mm/dd/yyyy, yyyy-mm-dd, or a date with time.
- Add fixed text if needed. You can add labels or words that are the same on every PDF, such as Invoice No, Certificate ID, or Approved by.
- Preview the first record. Check that the first row looks right on the PDF before generating everything.
- Choose the file name style. Use one or two column values, fixed text, and an optional increasing number. If nothing is selected, the tool can use an automatic number.
- Generate and download. The tool creates the finished PDF files for your selected rows.
Convert Excel rows to PDF files
Upload your template, map your columns, preview the result, and generate PDFs for each row.
Open Excel to PDF Mapper →Common examples
Excel to PDF mapping is useful when you already have data in a spreadsheet and need professional PDF documents from it. Instead of copying and pasting into each file, you build the layout once and let the tool repeat the work.
- Certificates: Put the person's name, course name, date, and certificate number onto a certificate template.
- Invoices: Add customer name, address, invoice number, date, amount, and payment details.
- Receipts: Fill receipt number, amount, customer name, date, and description.
- Letters: Create one PDF letter per row using names, addresses, and custom details.
- Forms: Fill repeated form fields from a spreadsheet without retyping each record.
- Labels and cards: Place names, IDs, dates, and other short values in fixed positions.
How date formatting works
Dates in spreadsheets can be confusing because Excel stores them as values internally. That is why a date can sometimes appear differently after export if the tool does not format it correctly. In Excel to PDF Mapper, when a value is detected as a date, you can choose how it should appear on the final PDF.
You may choose a simple date format like dd/mm/yyyy, a US style format like mm/dd/yyyy, or a format that includes time. Use the preview to confirm the date looks exactly the way you want before generating all PDFs.
Good practice: Check at least one row with a normal date and one row with an unusual date, such as the first or last day of a month. This helps catch formatting mistakes early.
Creating clear PDF file names
Good file names make the downloaded PDFs easier to find later. The mapper can build file names from optional parts: one Excel column, a second Excel column, fixed text that you type, and an increasing number. For example, you can create names like Invoice-John-Smith-001 or Certificate-Emma-2026-014.
If you do not choose any column or fixed text, the tool can still create unique names using automatic numbering. This is helpful when the file name does not need to include personal details.
Tips for best results
- Use one row for one PDF. Do not put two people, invoices, or records in the same spreadsheet row.
- Keep column headers clear. Names like Full Name, Invoice Date, Amount, and Reference are easier to understand while mapping.
- Make boxes slightly wider than the sample text. Some rows may contain longer names or addresses.
- Preview before generating. Always check the first PDF layout before creating a large batch.
- Save the mapping settings. If you use the same template again, upload the saved settings next time instead of placing every field again.
- Test with a few rows first. Generate a small sample before running a large file.
How your files are handled
Your uploaded files are used only to create your converted PDF documents. The goal is to process the file, let you download the result, and remove temporary files after the task is complete. You do not need to create an account to use the tool.
Even with temporary file handling, you should still be careful with sensitive documents. Only upload the information needed for the PDFs, remove unused columns from the spreadsheet when possible, and double-check the final PDF before sharing it with anyone.
Frequently asked questions
In short
Excel to PDF Mapper is made for repeated PDF work. Upload a PDF template, upload Excel or CSV data, place the columns where they belong, choose the style and date format, preview the first record, and generate finished PDFs with unique file names. It saves time, reduces typing mistakes, and keeps your documents consistent.