1. Upload your spreadsheet
Start with an XLSX, XLS or CSV file. Put the billing data on the first sheet, with column headers in the first row. Use one row per invoice, or repeat the invoice number for related line items.
Excel invoice generator for printable PDFs.
Keep working with the customer details, sales and amounts you already have in Excel. LinkoPDF connects those columns to a reusable invoice design so you can create printable PDFs without copying each record into a separate invoice or writing a macro.
Product demo
How to create PDF invoices from Excel
Your spreadsheet supplies the invoice data; the template controls the PDF layout. Keep preparing billing data in Excel without building macros.
2. Connect the invoice fields
Add your business details to the included template, or import a one-page PDF invoice template. Map customer names, invoice numbers, dates and totals to the places they belong.
3. Generate and check the PDFs
Review your spreadsheet and template layout, then export a small batch. Check the generated values before downloading separate PDFs in a ZIP or a combined PDF for printing.
Open the invoice spreadsheet upload to use your file or try five sample invoices. Free: one batch of up to 10 documents per day. See plans and limits.
For a worked example, follow the step-by-step guide to creating invoices from Excel. The bulk invoice workflow explains the batch steps and download options.
Print your invoices in one batch
When the billing list is ready, the next step should be turning it into invoices. Keep your logo, business details and payment instructions in one template, then use your spreadsheet to fill the customer information and amounts. The same layout carries through the batch, whether you are billing a few clients or preparing the next monthly run.
Choose separate PDFs in a ZIP when you need individual files, or a combined PDF to print the batch from one document. Open a small generated batch first and check a long customer name, a detailed description and an invoice with several items. This gives you a chance to adjust the layout before using paper on the full run.
For the next billing cycle, reuse the saved template with the same column names. Check the new dates, invoice numbers and totals in Excel, and keep a record there of what you have generated and printed. A prepared layout and a clear billing list make the process easier to repeat as your customer list grows.
Spreadsheet checklist before you import
The Excel invoice sample contains five records with Customer Name, Invoice #, Date, Address, Description, Total and Notes columns. Use it as a starting point, or prepare your own spreadsheet with the checklist below.
Keep one clear header row
Use readable column names like invoice_no, customer_name, due_date, subtotal, tax, and total_due instead of blank or duplicated headers.
Use a stable invoice identifier
If one invoice spans multiple rows, repeat the same invoice number or order ID on every related row and select that column for grouping in the editor.
Normalize empty values where possible
Blank cells are okay, but inconsistent labels, merged cells, or mixed formats tend to create avoidable mapping problems later.
Separate summary fields from line items
Know which columns belong in the invoice header and which ones should repeat in the item table so your mapping stays organized.
Columns that are most useful in invoice spreadsheets
Invoice header columns
invoice_no, issue_date, due_date, and payment_terms give the invoice its identity and timeline.
Customer columns
customer_name, billing_address, contact_email, and account references make the invoice ready to send.
Financial columns
subtotal, tax_amount, discount, and total_due make it easy to map the amounts that matter most.
These are suggested column names; map your existing headers to the corresponding template fields. For example rows and guidance on grouping line items, see the invoice spreadsheet format examples.
Excel invoice generator: common questions
Can I print multiple invoices from Excel without VBA?
Yes. Upload your Excel data, connect the columns to an invoice template and generate the PDFs in LinkoPDF. Choose a combined PDF to print the batch from your PDF viewer. You do not need to write VBA or set up a Word mail merge.
Can I try my spreadsheet before setting up the whole batch?
Yes. Prepare a small file with a few representative invoices and check the generated PDFs against Excel. The free plan allows one batch of up to 10 documents per day, so include the records you want to test in that run.
Can I import an Excel workbook without converting it to CSV?
Yes. LinkoPDF accepts XLSX and XLS workbooks directly, as well as CSV files. Keep a clear header row so you can connect each column to an invoice field.
Can I use my own Excel invoice template?
Use Excel for the invoice data and import a one-page PDF for the invoice design. If your layout is in Excel, save a blank copy of that layout as a PDF, import it into LinkoPDF, and place the data fields over it. Uploading a workbook supplies data; it does not import the workbook's visual layout. Learn how to link Excel columns to an invoice template.
Does LinkoPDF calculate the invoice totals?
Calculate and check totals, discounts and taxes in your spreadsheet before importing. LinkoPDF fills the invoice template with your prepared values. Review a generated invoice against the source data before using the full batch.
Is this a downloadable Excel invoice template?
LinkoPDF is an online invoice creator that uses your Excel data to fill a PDF invoice layout. The downloadable Excel sample contains billing rows. It is not a formatted invoice workbook: the invoice design is edited in LinkoPDF.
Can one invoice include several Excel rows?
Yes. Give related rows the same invoice number, select it as the grouping column and connect the line-item columns to a table in your template. See the itemized invoice generator for details.
Can I reuse the invoice generator for next month's Excel file?
Yes. Save the template and upload the next approved spreadsheet with the same column names. Update invoice numbers, dates and amounts before generating the new batch. Each run starts manually. Follow the Excel invoice automation workflow for the repeat-billing checklist.
Common spreadsheet issues that slow invoice generation
Merged cells
Merged rows often hide repeated values. For grouped invoices, every row should carry the invoice identifier explicitly.
Mixed number formats
Totals and prices are easier to map when the spreadsheet uses a consistent format for amounts, taxes, and currencies.
Important data in notes only
If invoice information only exists inside comments or inconsistent note columns, move it into dedicated fields before importing.