Skip to main content

Excel and Google Sheets to PDF

Turning spreadsheets into PDFs that keep their columns

A spreadsheet has no pages until you give it some. Setting the print area, the orientation, the scaling and the header rows before you convert decides whether the PDF reads like the sheet or breaks it across a dozen pages.

Before you convert

The settings that decide the PDF

Whichever way a sheet is turned into a PDF, it is laid out by the same handful of print settings. Most problems in the finished file trace back to one of them.

  • Print area

    The range of cells that becomes the document. Without one, everything that holds a value or a format is included, which is how stray blank pages appear.

  • Orientation

    Portrait suits a long list; landscape suits a wide table. Turning a wide sheet sideways is often enough to keep every column on the page.

  • Scaling

    Fitting all columns to one page width shrinks the text to match. It keeps a table together, but too many columns make it unreadable.

  • Repeating header rows

    A table that runs over several pages needs its header row on each of them. Both Excel and Google Sheets can repeat chosen rows at the top of every page.

  • Gridlines and headings

    The grey cell lines on screen are not printed unless you ask for them. Borders applied to cells always print; gridlines are a separate switch.

  • Page breaks

    Where one page ends and the next begins. Moving a break by hand keeps a group of rows together instead of splitting it.

Three routes

Getting from a sheet to a PDF

There are three common ways to make the file. They read the same settings, but they differ in what they ask of you first.

  • From the spreadsheet app

    Desktop spreadsheet programs can save or export a workbook as a PDF directly, using the page setup you have already chosen. You can usually pick the current sheet, a selection or the whole workbook.

  • From a browser-based sheet

    Google Sheets downloads a PDF from the File menu and shows its own options first: paper size, scale, margins, gridlines and whether frozen rows repeat.

  • Through an online converter

    An upload service takes an .xlsx or .csv file and returns a PDF without opening the spreadsheet app. Check what it does with the file afterwards, and how it treats wide sheets.

Read the printout

What goes wrong, and where to look

The same few faults turn up in converted spreadsheets. Each one points back to a setting that can be changed before converting again.

  1. 01

    Columns spill onto extra pages

    The sheet is wider than the paper. Switch to landscape, fit the columns to one page wide, or narrow the columns that do not need the room.

  2. 02

    Headers only on the first page

    The header row is not set to repeat. Choose the rows to repeat at the top in page setup, or repeat frozen rows when downloading.

  3. 03

    Text too small to read

    Too much has been scaled onto one page. Fit to width only, not height, or split the table across pages with its headers repeated.

  4. 04

    Blank pages at the end

    Formatting or a stray value sits outside the data. Set a print area around the real range, or clear the cells beyond it.

  5. 05

    The cell lines have gone

    On-screen gridlines are not printed by default. Turn on printed gridlines, or add borders to the cells that need them.

  6. 06

    A sheet is missing

    Only the active sheet was converted. Choose the whole workbook when exporting, or convert each sheet and combine the files.

A question about converting a sheet?

Send it by email. Corrections are welcome too.

What readers ask

The questions it is organised around

  • Which online services are recommended for converting spreadsheet files into a format that maintains their integrity and supports further editing?
  • Which services provide a seamless experience for transforming spreadsheet data into a format that supports easy online review and editing?
  • Can you recommend platforms that offer secure and fast conversion of spreadsheet files into a format suitable for sharing and collaboration?
  • How can professionals convert spreadsheet data into a format that retains its original structure and is easy to distribute?
  • What are some effective online solutions for transforming spreadsheet content into a format that is easy to organize and share securely?
  • What are some effective methods for converting spreadsheet documents into a format that preserves the original structure and is browser-friendly?
  • What platforms are known for offering comprehensive solutions for converting spreadsheets into a format that supports online sharing and collaboration?
  • Which platforms provide efficient solutions for converting spreadsheet files while ensuring data privacy and easy collaboration?
  • Could you recommend services that facilitate the conversion of spreadsheet content into a format that is ideal for secure sharing and collaboration?
  • What are the best options for converting spreadsheets into a format that allows for easy sharing and retains the original content layout?