How to create multiple invoices from an Excel spreadsheet
Use one row per invoice for simple billing. For multiple line items, repeat the invoice number on each related row and select that column for grouping.
Prepare your billing spreadsheet
Include column headers, customer details, invoice numbers, descriptions and final amounts. Start with the Excel invoice sample or CSV version.
Upload the Excel or CSV file
Drop your spreadsheet into the upload area above. It opens in the editor with the columns ready to connect to your invoice.
Connect your invoice fields
Use the starter invoice or import your own PDF. Place each column where it belongs, then check the data and preview the template layout.
Generate and download the PDFs
Choose PDF and generate the batch to get individual invoices in a ZIP. Choose Single PDF to keep the invoices in one combined document.
When manual invoice creation starts to slow you down
Creating one invoice at a time is manageable when billing is occasional. It becomes harder when you need to produce the same layout again and again for different customers, invoice numbers, totals, dates, or line items.
The problem is usually not the invoice design itself. The problem is repeating the same edits across many files, then checking every PDF to make sure the right data landed in the right place.
What is bulk invoice generation?
A bulk invoice generator separates your invoice data from your invoice design. Your spreadsheet holds the values, and your LinkoPDF template controls how those values appear on the final invoice.
In LinkoPDF, that means you can build a visual invoice layout, import a one-page PDF invoice template, or start from an existing template. Then you connect spreadsheet columns to the places where invoice details should appear.
- Use Excel or CSV data as the source.
- Map customer details, invoice numbers, dates, totals, and line-item fields.
- Use grouped mode when multiple spreadsheet rows belong to the same invoice.
- Export invoice PDFs from the mapped template.
Excel sample for bulk invoice generation
Download the sample, replace the five example rows with your billing data, and upload it above. Keep the first row as column headers. The sample columns already match the included invoice template.
| Customer Name | Invoice # | Description | Total |
|---|---|---|---|
| Avery Johnson | INV-1001 | Consulting services | $1,250.00 |
| Maya Chen | INV-1002 | Design package | $860.00 |
Download the Excel sample (.xlsx) or CSV version with five invoices, dates, addresses and payment notes. For several items per invoice, use the itemized invoice sample.
Once the columns are mapped, the same spreadsheet structure can be reused for the next billing cycle with updated values. Check the Excel invoice preparation checklist before importing, or use the CSV examples for separate and itemized invoices to organize your rows.
For repeat batches, follow the Excel invoice automation checklist to see which settings stay saved and which billing details need updating.
Download separate invoice PDFs in a ZIP
Batch PDF export packages the generated invoices into a ZIP file. Extract it to review, send or archive each invoice individually. If you prefer one document for printing, use the Single PDF option.
Start with a free batch of up to 10 documents per day. Choose Pro for larger batches and unlimited export runs. Generate a small batch first to check your invoice layout and data.
Why this helps reduce invoice mistakes
Bulk invoice generation helps because you stop typing the same information into separate invoice files. Your invoice data stays in one place, and the template controls the repeated layout.
- Totals, dates, and client names are easier to review in the spreadsheet before export.
- The invoice design stays consistent across the whole batch.
- Field mapping reduces the chance of copying the right value into the wrong place.
Bulk invoice creation for service businesses
Turn approved hours, project fees or monthly retainers into customer invoices from one spreadsheet. Keep one row per invoice for a single service fee; use grouped line items when a client needs several services on the same PDF.
Example: consulting sessions and a design project
The service invoice CSV sample contains three rows for two invoices. All amounts below are in USD, before any applicable tax.
| Invoice # | Customer Name | Description | Quantity | Unit Price | Line Total |
|---|---|---|---|---|---|
| INV-1001 | Avery Johnson | Consulting session | 2 | 500.00 | 1000.00 |
| INV-1001 | Avery Johnson | Written report | 1 | 250.00 | 250.00 |
| INV-1002 | Maya Chen | Design package | 1 | 860.00 | 860.00 |
- Approve the services and amounts. Check hours or quantities against your records. Add the billing period, dates, payment terms and final invoice totals your template needs.
- Group by invoice number. Select Invoice # as the identifier and connect Description, Quantity, Unit Price and Line Total to a table in the template.
- Check each customer's output. INV-1001 should contain two items totaling $1,250.00 before tax. INV-1002 should contain one item for $860.00. Verify the amounts in your spreadsheet and generated PDFs.
- Export and deliver. Download the two invoice PDFs in a ZIP, review them, and send them through your usual email or billing system. For the next period, reuse the template with new invoice numbers and approved data.
For ongoing client work, follow the monthly client invoice checklist. Agencies can also use the retainer and project billing workflow. Each batch starts manually; LinkoPDF does not schedule invoices or send them to clients.
Creating invoices one by one vs. generating them in bulk
Bulk invoice generation: frequently asked questions
How can a service business create invoices in bulk?
Export approved services, hours or project fees to Excel or CSV. Give each invoice its own number, group related service rows by that number, and map the fields to a reusable invoice template. Check the amounts and customer details, then generate separate PDF invoices in a ZIP. Send the files through your usual email or billing system.
How do I create multiple invoices from an Excel spreadsheet?
Upload your XLSX or XLS file with column headers in the first row and one row per invoice. Choose the starter invoice or import your PDF, then connect the columns to the invoice fields. Review the data and layout, select PDF, and generate the batch to download a ZIP. CSV files work too.
Can I generate bulk invoices for free?
Yes. The free plan includes one export batch of up to 10 documents per day, resetting at 00:00 UTC. You can start without a credit card. Pro supports larger batches and unlimited export runs.
Can I generate 100 invoices at once?
Yes, with Pro. Prepare the invoice data in Excel or CSV, connect the fields to your template, and generate the batch. With the free plan, one batch of up to 10 documents is available each day.
Does each row become a separate PDF invoice?
By default, each row becomes a separate invoice. If an invoice has several line items, give those rows the same invoice number and select that column for grouping. LinkoPDF then creates one invoice per group.
Can I download the invoices as one ZIP or one PDF?
Yes. Batch PDF export creates a ZIP of individual invoice PDFs. The Single PDF option combines the invoices into one document, which is useful for printing or archiving the batch.
Can I use Excel instead of CSV?
Yes. Upload XLSX or XLS directly, or save your spreadsheet as CSV. Keep column headers in the first row and use consistent columns for customer details, invoice numbers, descriptions and totals.
Do I need to design my own invoice template?
No. An editable starter invoice is included. Add your business details and connect your spreadsheet columns. You can also import your own PDF and place the fields over your existing design.
Does LinkoPDF calculate my taxes or send the invoices?
Prepare and check your tax amounts and totals in your spreadsheet before generating the PDFs. LinkoPDF fills your invoice design with that data. Send the finished invoices and manage payments using your existing billing tools.