Bulk Convert Google Sheets to PDF in Landscape Orientation
Wide spreadsheets with many columns almost always need landscape orientation to fit on a PDF page. If you bulk convert without setting this, columns get cut off or squeezed into an unreadable layout. Set landscape orientation in each spreadsheet's print settings before running the batch and every PDF comes out with the correct layout.
Setting landscape in Google Sheets
Open the spreadsheet and go to File > Print. In the print settings panel, find 'Page orientation' and select 'Landscape'. Close the dialog. This setting is saved with the file. When the Docs to PDF extension exports it, the PDF uses landscape orientation.
Fitting wide data on the page
Landscape orientation helps but very wide spreadsheets may still overflow. Use the 'Fit to width' or 'Fit to page' scaling options in the print settings to shrink the content to fit. Test with a single export first to confirm the layout before running the full batch.
Mixing portrait and landscape in a batch
Each spreadsheet in a batch uses its own print settings. You can have some spreadsheets set to portrait and others to landscape in the same batch. The extension reads the settings per file, so the orientation is respected for each one individually.
Frequently Asked Questions
What if I forget to set landscape before running the bulk export?
You can rerun the export after updating the print settings. The extension does not cache previous export settings.
Does landscape orientation affect how charts look in the PDF?
Charts resize to fit the page in the orientation you set. Landscape gives charts more horizontal space, which often improves readability for bar charts and timeline views.
Related article
Convert Google Docs to PDF in Landscape →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension