Print Multiple Google Sheets at Once

Printing a Google Sheet directly from a browser uses the browser's print renderer, which may not handle column widths or page breaks the same way the Sheets print preview does. Converting to PDF through Google's export API uses the same rendering pipeline as Sheets' built-in print function. The result is consistent with what you see in Sheets and predictable across printers.

Open Google Drive, navigate to the folder containing your spreadsheets, and hold Ctrl (Windows) or Cmd (Mac) to select multiple Sheets files. Or press Ctrl+A to select everything in the folder. Click the Docs to PDF extension icon. Each Sheet is exported as a PDF. By default, all sheets (tabs) within a file are included in the PDF export.

Before batch-converting, set print ranges and page break settings in each Google Sheet. In Sheets, go to File > Print to access print settings: choose which sheets to include, set print area, select paper size and orientation, and decide whether to show gridlines. Once saved, these settings carry over to the PDF export.

Finance teams printing monthly reports across multiple projects. Teachers printing quiz score sheets or grade trackers. Operations staff printing inventory or scheduling spreadsheets. Anyone managing recurring data across multiple Sheets files saves real time by batch-converting instead of printing each file separately.

Wide spreadsheets often need landscape orientation to fit on a page. Set the orientation in File > Page setup in Google Sheets before running the batch conversion. The PDF will use landscape orientation and the printout will match. This is especially important for batch printing, where you want all files to use the correct orientation without checking each one individually after the fact.