Bulk Convert Google Sheets to PDF With Headers and Footers
Headers and footers in spreadsheet PDFs are useful for identifying the document, showing the export date, or including page numbers across multi-page sheets. Google Sheets lets you configure headers and footers in the print settings. Once set, the bulk export picks them up automatically for every conversion.
Configuring headers and footers in Google Sheets
Go to File > Print in the spreadsheet. Click 'Headers & footers' in the print settings panel. You can add the spreadsheet title, current date, page numbers, or custom text to the header and footer sections. These are left, center, and right zones that you fill in separately.
Using dynamic fields
The page number, total pages, current date, and file name are available as dynamic fields. Insert '&[Page]' for the current page number, '&[Pages]' for the total count, and '&[Date]' for today's date. These update automatically at export time, so you do not need to update them before each batch.
Consistent headers across a batch
Each spreadsheet has its own header and footer settings. If you want consistent headers across all spreadsheets in a batch, configure the same settings in each file. For recurring exports, use a template spreadsheet with headers already configured.
Frequently Asked Questions
Can I add the spreadsheet name to the footer automatically?
Yes. In the header/footer settings, use '&[Title]' to insert the spreadsheet title. It updates automatically based on the file name.
Do headers and footers show on every tab's pages?
Yes. Headers and footers apply to all pages in the exported PDF, including pages from multiple tabs.
Related article
Convert Google Docs to PDF With Headers & Footers →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension