Google Sheets → PDF

Turn Google Sheets rows into client-ready invoices.

Keep your billing list in Google Sheets. Export the approved rows, connect them to one invoice design, and generate a separate PDF for each invoice.

Start free: one batch of up to 10 documents per day. Resets at 00:00 UTC. View plans.

01 Prepare your data02 Connect your layout03 Generate your PDFs

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.

Illustrative billing rows · amounts in USD
Invoice #Customer NameDescriptionTotal
INV-1001Avery JohnsonConsulting services$1,250.00
INV-1002Maya ChenDesign 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

  1. 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.
  2. 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.
  3. Upload it to LinkoPDF. Open the editor, choose Upload spreadsheet, and confirm that the headers and records look right.
  4. 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.
  5. 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?

Match the workflow to the file you need
Your starting pointUseful next step
One invoice already laid out in a sheetPrint or export that invoice as PDF from Sheets.
A table of clients and invoice amountsMap the exported rows to a LinkoPDF template.
Several service rows per invoiceGroup by invoice number and connect a line-item table.
A workflow that must send invoices on a scheduleUse 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.