Change the year in a Google Sheets PDF
Roll a document over to the new year: update the year in headers, footers, dates and copyright lines. This works on the PDF Google Sheets exported, so you do not need the original file.
Choose a PDF
or drop it here
Private and secureNo sign upNo watermarkUp to 100 MB
How to do it
- 1.Open the PDF exported from Google Sheets in MythosPDF.
- 2.Select the year and type the new one.
- 3.Check headers and footers on every page, then Export PDF.
How Google Sheets writes PDFs
- • Cells become positioned text with optional grid lines.
- • Numbers are right aligned.
- • Fonts are Google Fonts.
What that means when you change the year
- • Cell values can be edited and keep their alignment; totals are not recalculated.
- • Amounts in Google Sheets PDFs are right aligned, so a longer value grows to the left and the column stays straight.
What happens to the rest of the page
- • Repeated headers and footers are separate text on each page, so edit each page's copy.
- • Tabular digits keep columns of years lined up.
Questions people ask
+Is there a find and replace?
Not yet. Edit each occurrence; each keeps its own layout exactly.
+Is it better to edit in Google Sheets?
If you have the original Google Sheets file and a lot to change, yes. For quick changes to the PDF itself, editing the PDF is faster and keeps it exactly as sent.
Other edits in Google Sheets PDFs
Change the year in PDFs from
Ready to fix your PDF?
Free, in your browser, and it takes about a minute. No account needed.