Convert All Google Sheets to PDF at Once
When you need every spreadsheet in a folder as a PDF, open that folder in the online converter's file picker and select the spreadsheets. With merge off, each spreadsheet becomes a separate PDF named after the original file. The online converter converts Google Docs, Sheets and Slides. Other file types you pick are skipped, and the converter tells you how many.
Preparing the folder before export
Make sure the folder contains only the spreadsheets you want. If there are older versions or drafts you do not need, move them to a subfolder first. This keeps the batch clean and prevents unwanted files from slipping into your downloads.
Running the full selection
Open the Docs to PDF online converter, click Select files from Google Drive, and select the spreadsheets in the folder. The converter exports each Google Sheet you picked, and a progress counter shows how many files have been processed.
After the export
The PDFs arrive as one ZIP in your downloads folder, each named after its source spreadsheet. If you want them organized differently, configure Chrome to ask for a save location before each download, or move the files into a named folder immediately after the batch finishes.
Frequently Asked Questions
Will non-spreadsheet files in the folder cause errors?
No. The online converter converts the Google Docs, Sheets and Slides you pick and skips other file types, telling you how many it skipped.
What if some sheets have download restrictions?
Files with download restrictions set by the owner will fail. The online converter reports a count of failed exports at the end of the batch.
Related article
Batch Convert Multiple Google Docs to PDF →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Convert Sheets to PDF online, freeConvert online, no install