One invoice has multiple services
Every service, deliverable, or charge gets its own row, but they all share the same invoice number.
Turn spreadsheet line items into complete itemized invoices.
When one invoice spans multiple spreadsheet rows, CSVLink can group those rows by invoice number or order ID so each customer receives one invoice with the correct item table.
Itemized invoicesGrouped rowsLine itemsExcel invoice data
When grouped invoice mode is the right choice
Products repeat under one order
Wholesale, parts, ecommerce, and distribution exports often create multiple rows for one customer invoice.
Totals need a clear breakdown
Customers need to see quantities, descriptions, rates, taxes, and line totals rather than one blended amount.
How CSVLink handles line items
Choose the grouping field.Select invoice number, order ID, or another stable field that identifies which rows belong together.
Map item columns into the table.Connect item description, quantity, unit price, tax, and line total columns to the repeated item area.
Preview before export.Check a grouped invoice before running the full batch so spacing and row behavior are correct.
Example itemized invoice CSV shape
| invoice_no | customer_name | item_description | quantity | unit_price | line_total |
|---|---|---|---|---|---|
| INV-2026-018 | Blue River Studio | Logo design package | 1 | 450.00 | 450.00 |
| INV-2026-018 | Blue River Studio | Brand guideline PDF | 1 | 180.00 | 180.00 |
| INV-2026-019 | Northwind Supply | Replacement filter | 3 | 42.00 | 126.00 |
Related invoice automation resources
CSV to invoice generator
Turn clean CSV billing exports into reusable invoice PDFs with mapped fields and batch output.
Invoice template builder
Build or import the invoice layout, then connect spreadsheet columns to the exact places they belong.
Itemized invoice generator
Use grouped rows when one invoice needs multiple products, services, quantities, prices, or descriptions.
Questions this page answers
Can one invoice include multiple line items from the spreadsheet?
Yes. Grouped mode is designed for that exact structure.
What column should I group by?
Use the field that is identical for every row in the same invoice, usually invoice_no, order_id, or billing_reference.
Can I preview grouped invoices before exporting?
Yes. Previewing is important so you can confirm line item spacing and invoice grouping before producing the full batch.
Use grouped rows for real itemized billing
Keep the detailed rows your accounting export already produces, then turn them into readable invoice tables automatically.