Skip to content

Bulk invoices from CSV

One spreadsheet in, one PDF per invoice out.

Drop your CSV or Excel file here

One row per item. Rows with the same number become one document.

New to this? , fill it in with Excel or Google Sheets, then upload it above.

How to use Bulk invoices from CSV

  1. Download or prepare your spreadsheet. Select Download the template for a ready-made CSV, or open your own .csv, .tsv, .txt, or .xlsx file with one row per line item.
  2. Drop your file and review flagged rows. Upload the spreadsheet into the DropZone, check the parsed document table, and resolve any validation notes.
  3. Configure Make, Country, Currency, and Your business. Pick Invoices, Quotes, Receipts, or Credit notes, select your tax jurisdiction, and add your business name, tax ID, and logo.
  4. Preview and export the ZIP archive. Inspect any document with the Preview selector and Full preview link, then select Make PDFs to download one ZIP containing every PDF.

Everything you type stays in this browser on your device. Nothing is uploaded, and your saved details are never sent anywhere.

Supported spreadsheet columns and multi-line invoice grouping

Spreadsheets store flat rows, whereas real invoices often contain several billable lines for the same client. This bulk generator solves that mismatch by recognizing 15 standard columns (plus common header aliases) and grouping every row that shares a number value into one multi-item PDF.

Because CSV dialects vary across spreadsheet programs, the parser follows the quoting and escaping conventions in IETF RFC 4180 Common Format for CSV Files while accepting .csv, .tsv, .txt, and .xlsx files up to 10 MB. If you work with a complex multi-tab workbook, you can convert multi-sheet Excel workbooks to clean CSV files before importing.

CSV column Accepted header aliases How the parser uses it
number invoice number, invoice no, doc number, no Groups matching rows into one PDF document
date / due_date invoice date, issue date, due, valid until Sets issue and payment due dates (YYYY-MM-DD or local)
client_name client, customer, bill to, company Populates the Bill to recipient name
description / details item, service, product, item details Adds line-item title and secondary description
quantity / unit_price qty, hours, price, rate, amount Computes line totals from US or European decimals
tax_percent tax rate, vat %, gst %, sales tax Maps to the matching rate for your selected Country

How does bulk CSV import handle regional tax rates and currencies?

The tax_percent column matches each row’s numeric percentage against the tax codes configured for your selected Country and Province or state, while parseAmount() normalizes both US ($1,234.50) and European (1.234,50) number formats. Unmatched percentages or currency symbols are flagged in the review panel before PDF rendering starts.

Mapping tax_percent to country and province tax codes

When you choose a country under Country, the island loads that jurisdiction’s tax presets (such as 21% VAT in EU countries, 5% GST or 13% HST in Canadian provinces, or state sales tax in the US). Entering 0 maps to the jurisdiction’s non-taxed code, while leaving tax_percent blank uses the country’s default rate.

If you only need to create one custom document with specialized reverse-charge notes or custom tax labels, use the single-document invoice generator instead. Both tools share your saved business profile in IndexedDB so your logo and address carry over automatically.

Parsing US and European decimal formats across 10 MB files

European versions of Excel frequently export 1.234,50 with periods as thousands separators and commas as decimal points, or prepend a UTF-8 Byte Order Mark (EF BB BF) per the Unicode UTF-8 Byte Order Mark (BOM) FAQ. The parseAmount() helper strips currency signs and normalizes both decimal conventions cleanly inside a Web Worker.

Exporting multi-document batches as a ZIP archive

Switching the Make selector lets a single spreadsheet drive Invoices, Quotes, Receipts, and Credit notes without reformatting columns. All documents in a run inherit your branding and compile into a single .zip archive containing one PDF per document.

Shared business branding, logos, and live PDF previews

Expand Your business to enter your company name, address, email, phone, tax ID, payment details, terms, footer, logo, and one of seven accent colors. When multiple documents are parsed, the Preview dropdown and Full preview link render the real pdf-lib output for any selected invoice number so you can spot long-description wrapping before exporting.

Comparing bulk CSV batching against single-document editing

Bulk CSV generation works best for monthly retainers, membership renewals, or e-commerce order exports where dozens of clients share the same terms and layout. For personalized letters or certificates stamped onto an existing PDF background, you can merge spreadsheet rows onto custom PDF letterheads instead.

Unlike single-document editing, bulk runs apply one Terms, Footer, and Payment details block across the whole batch. Keep those fields concise and general enough for every recipient in the spreadsheet.

Troubleshooting Excel encoding, local history, and retention scope

Spreadsheet auto-formatting and local browser storage follow predictable rules that are easy to verify before a monthly billing run. Checking dates, leading zeros, and backup habits keeps your records audit-ready.

Fixing comma decimals, leading zeros, and date formatting

Excel often strips leading zeros from invoice numbers (0042 becomes 42) or flips DD/MM/YYYY dates when saving CSVs. Format invoice number columns as Text and dates as ISO YYYY-MM-DD before exporting, or upload the .xlsx workbook directly.

Tip: Download invoices-template.csv first and test with three multi-line rows to verify your regional tax_percent mapping and logo placement before importing a 200-row ledger.

IndexedDB device history and tax recordkeeping boundaries

Checking Keep a copy of each on this device stores generated documents in the browser’s MDN Web Docs IndexedDB Storage API without transmitting client data over the network. You can later export your saved browser invoices to a sales ledger as CSV or Excel.

Informational scope notice: Tax authorities such as the IRS in its IRS Small Business Recordkeeping Guidelines require businesses to retain supporting sales records and verify applicable tax rates. This bulk generator is an operational formatting tool and does not constitute tax or accounting advice; consult a qualified accountant to confirm local invoice retention and tax rules.

Questions

How do I put multiple line items on one invoice in a CSV?

Place each line item on its own row and repeat the same value in the number column (such as INV-1042) across those rows. The parser groups all rows with a matching document number into one multi-item PDF and preserves the first row's client details.

Can I upload an Excel .xlsx file directly without converting to CSV?

Yes. Drop a standard .xlsx workbook up to 10 MB directly into the tool and it reads the spreadsheet in your browser. If your workbook has multiple tabs and you only want one specific sheet, convert that tab to CSV first.

How does the tax_percent column handle regional VAT or GST rates?

The parser matches the numeric tax_percent value against the tax codes defined for your selected Country and Province or State. For example, entering 13 with Canada and Ontario selected maps to HST 13%, while 0 maps to the no-tax or zero-rated code.

Why do accented characters or currency symbols break in Excel CSV exports?

Older spreadsheet exports sometimes write ANSI or Windows-1252 bytes instead of UTF-8, turning accented names or Euro symbols into garbled characters. Save your sheet as CSV UTF-8 (Comma delimited) in Excel, or drop the native .xlsx file directly.

Are my business logo and generated invoices saved anywhere?

Nothing is uploaded to a server. If you keep Remember my business details on this device or Keep a copy of each on this device checked, your profile and generated documents are saved locally in your browser's IndexedDB so you can reopen them later.

What happens if a row is missing an invoice number or date?

Rows without a document number are assigned sequential numbers automatically starting after your last saved number in that category. Blank date cells default to today's date, and you can inspect every parsed document in the preview table before generating PDFs.

Updated