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.
Turn Excel rows into finished invoice PDFs.
If your invoice data already lives in Excel, you should not have to copy each customer, date, line item, and total into a PDF by hand. CSVLink lets you place spreadsheet columns onto your invoice template and export the full set.
Spreadsheet checklist before you import
Use a stable invoice identifier
If one invoice spans multiple rows, make sure every related row repeats the same invoice number or order ID so CSVLink can group them correctly.
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.
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.