Start with a billing table, not a printable invoice
If you already have a sheet containing customers and amounts, you do not need to copy each row into a separate invoice tab. LinkoPDF takes the exported data and places it into a reusable PDF layout. This works well for consultants, small service businesses, and teams that review billing together in Google Sheets.
Use one header row and one record per invoice to begin. These are example column names; you will connect your own columns in the editor.
| Invoice # | Customer Name | Description | Total |
|---|---|---|---|
| INV-1001 | Avery Johnson | Consulting services | $1,250.00 |
| INV-1002 | Maya Chen | Design package | $860.00 |
Add the billing address, issue date, due date, and payment details you want to display. Keep calculations in your spreadsheet and check the final amounts before downloading a copy.
Export from Sheets, then create the PDFs
- Prepare a clean export tab. Include only the approved invoices. Copy the intended records into that tab rather than relying on hidden rows to exclude data.
- Download the data. In Google Sheets, open File → Download and choose CSV for the current sheet, or Microsoft Excel (.xlsx). A CSV is a simple choice when you want one specific tab.
- Upload it to LinkoPDF. Open the editor, choose Upload spreadsheet, and confirm that the headers and records look right.
- Connect the invoice layout. Customize the starter design or import a one-page PDF. Link customer, invoice number, dates, description, and amount fields to the corresponding columns.
- Generate and inspect. The editor previews the layout; the linked values are filled during generation. Check a small output batch, then download individual PDFs in a ZIP or a combined PDF.
Google documents the available download formats in its guide to working with Sheets and Excel.
Printing a sheet or generating separate invoices?
| Your starting point | Useful next step |
|---|---|
| One invoice already laid out in a sheet | Print or export that invoice as PDF from Sheets. |
| A table of clients and invoice amounts | Map the exported rows to a LinkoPDF template. |
| Several service rows per invoice | Group by invoice number and connect a line-item table. |
| A workflow that must send invoices on a schedule | Use a billing system with scheduling and delivery; this file workflow is manual. |
For several items on one invoice, keep the same invoice number on those rows. Follow the itemized invoice workflow before exporting the full batch.
Make the next billing cycle easier
Keep the same column names in future exports so your saved template can be reused. Save a dated copy of the approved spreadsheet alongside the generated files. Changes to the live Google Sheet will not update an already downloaded CSV or PDF; export and upload a fresh copy when the data changes.
LinkoPDF uses the file you upload. It does not connect directly to your Google account, synchronize edits, or email the invoices. For an end-of-month routine, use the monthly invoice checklist.
Frequently asked questions
Does LinkoPDF connect directly to Google Sheets?
No. Download your sheet as CSV or Excel, then upload that file to LinkoPDF. Refresh the export whenever the source data changes.
Can several spreadsheet rows become one invoice?
Yes. Use the same invoice number for the related rows, select it as the identifier, and connect the line-item fields to a table in your template.
Can I try it with a small batch?
Yes. The free allowance is one batch of up to 10 documents per day, resetting at 00:00 UTC. Check the pricing page for paid options.
