If your customer details, sales and totals are already in Excel, you can use that data to prepare invoices for printing. Save a completed invoice worksheet as a PDF, or connect a billing list to a reusable template to generate the whole batch without filling each invoice by hand.
These steps use Excel for Windows. Keep an editable workbook copy so you can update the invoice later.
Menu labels vary by Excel version. See Microsoft's instructions for saving Office files as PDF and setting a worksheet print area.
Saving a billing table as a PDF prints the table. To turn each customer's data into a separate invoice, use the batch workflow below. If you want to keep an Excel invoice design, save a blank copy of the layout as a one-page PDF and connect it to your billing spreadsheet.
Excel is often the place where billing work actually starts: order exports, time summaries, retainer lists, tax columns, and customer details. The slow part is turning those rows into invoice PDFs that look consistent and are ready to send. A reliable workflow separates the spreadsheet data from the invoice design, then connects them once.
Use one header row with stable field names. Practical invoice columns include invoice_no, customer_name, billing_address, issue_date, due_date, item_description, quantity, unit_price, tax_amount, and total_due.
If every row is one invoice, use one-row mode. If several rows share the same invoice number because they are line items, use grouped mode and group by invoice_no or order_id.
Use LinkoPDF's editable starter invoice, create a layout, or import a one-page PDF when you already have an approved design. Uploading an Excel workbook supplies the data; it does not import the workbook's visual layout.
Connect customer fields, invoice dates, totals and line items to the template. Check that each field uses the intended column and that the layout leaves room for longer names and descriptions. Generate a small batch next to verify the filled values.
Generate a small batch and open the PDFs to check the values and layout. Choose PDF for separate invoices in a ZIP, or Single PDF for a combined document. The bulk invoice download guide explains the output options.
Save the template and import the next approved spreadsheet with the same column names. Your logo, payment instructions and field positions stay in the layout, so the next run starts with a design you have already checked. Update invoice numbers, billing dates and amounts before generating each batch; you start each run manually.
Start with a small file that includes a typical invoice and the records most likely to stretch the layout: a long billing address, a detailed service description and an invoice with several items. Compare the generated PDFs with Excel, checking the customer, invoice number, quantities and total due. Keep calculations and rounding in the spreadsheet so the PDF receives the amounts you have approved.
For itemized invoices, give all rows for the same invoice the same identifier, and keep different invoices under different numbers. For example, three service rows for INV-104 belong together, while the next invoice uses INV-105. Check that a repeated number represents another line item, rather than a duplicated record or a different customer.
Keep a simple record in Excel of the invoices you have generated and printed, using the invoice number and a date or status column. Prepare the next upload from the invoices still waiting to be processed. If a print job stops halfway through, check where it stopped before sending the remaining pages, so you do not print the whole batch twice.
Set up stable invoice numbers in Excel · Troubleshoot missing or mismatched invoice data
Once you have checked the sample, generate the prepared batch and choose Single PDF for a combined document. Open it in your PDF viewer to print the invoices together. Choose separate PDFs in a ZIP when you need individual files to store or share. Both options use the invoice layout you prepared in LinkoPDF.
Check the paper size, orientation and scaling in the print preview before sending the job. If text is clipped in the PDF itself, adjust the template spacing or field size and generate it again. If the PDF looks right but the paper copy is cropped, review the printer margins and scaling. Print a representative invoice first, including one with several items if your batch has them.
Download the Excel sample (.xlsx)
Prefer a text export? Download the same invoice data as CSV.
The sample opens in Excel and contains five invoices. Each row includes Customer Name, Invoice #, Date, Address, Description, Total, and Notes. Start with one row per invoice to understand the mapping before adding grouped line items.
| Column | Example | Where it goes |
|---|---|---|
| Customer Name | Avery Johnson | Bill to |
| Invoice # | INV-1001 | Invoice identifier |
| Date | Sep 3, 2026 | Issue date |
| Description | Consulting services | Invoice description |
| Total | $1,250.00 | Total due |
For a focused example of connecting spreadsheet columns to specific document positions, see how to link Excel to an invoice template.
The sample contains prepared totals. Decide your quantities, prices, discounts, taxes, and rounding before export; a field placed on a PDF should display the value you intended. Preserve leading zeroes in invoice numbers by treating identifiers as text.
Use grouped invoice data when several spreadsheet rows belong to the same invoice. Repeat a stable invoice identifier for those rows, select it as the grouping column, and preview the group before export. Do not mix different customers under the same identifier.
For delimiters, number formats, and grouped examples, see the CSV invoice format guide.
Turn clean CSV billing exports into reusable invoice PDFs with mapped fields and batch output.
Build or import the invoice layout, then connect spreadsheet columns to the exact places they belong.
Use grouped rows when one invoice needs multiple products, services, quantities, prices, or descriptions.
No. You can use LinkoPDF to connect spreadsheet columns to invoice fields and generate the PDFs without writing code. Start with a small set of billing records and an editable template, then check the generated files before preparing a larger batch.
Yes. In Excel for Windows, finish the invoice layout, check the print area, and choose PDF under Save As or Save a Copy. Open the saved PDF to check the page breaks and totals. Keep the workbook as your editable copy.
No. Saving as PDF exports the selected worksheet content. To create one invoice per billing record, connect the spreadsheet columns to an invoice template and generate separate PDFs. Group related rows by invoice number when an invoice has several line items.
Use a reusable invoice template and map Excel columns into it, then export the batch instead of creating every invoice manually.
Use grouped invoice mode and group by invoice number or order ID so the rows become an itemized invoice.
Formulas can help prepare the data, but a template mapping workflow is easier to reuse when the goal is polished PDF output.
Open LinkoPDF, import an Excel or CSV file, and build the reusable template that matches your billing process.