What are workbook sheets?
A workbook is a spreadsheet file, and the sheets are the separate tabs inside it, each with its own grid of cells. One workbook can hold a summary on the first sheet, raw data on the second and a chart on the third. Sheets matter when you move between spreadsheets and PDF, because a PDF has pages and no tabs, so something has to decide how the sheets turn into pages and back.
From sheets to pages
When a workbook is saved as a PDF, each sheet is laid out onto one or more pages. A wide sheet may be split across several pages, and the page size, the margins and the print area chosen in the spreadsheet decide where the cuts fall. Formulas appear as their results rather than as formulas. For a clean PDF, check the print preview before converting, and set the columns to fit the page width.
From pages back to sheets
The opposite direction is not a copy of the original workbook. A PDF holds only what was drawn on the page, so tables can be recognised and written into cells, but formulas, hidden sheets and cell formats are gone. A tool that reads tables works page by page, and a table that continues over two pages arrives as two parts that you may need to join by hand.
Using AuraDoc for it
Excel to PDF turns a workbook into a PDF with the sheets laid out as pages, and PDF to Excel writes the tables it finds into a spreadsheet with one sheet per page. PDF quality report lists the pages and how much text a PDF holds, which tells you whether the tables are real text or only a picture. Each result is a new file, so your original stays intact.
Tools that use this
Guides that put it into practice
- Export a spreadsheet to PDF cleanlyStep by step: set the print area in Excel, convert the workbook, number the pages and shrink the file before you send it.
- Move PDF tables to ExcelStep by step: tell a text PDF from a scan, run OCR when needed, pull out the tables as spreadsheet data and check the numbers before you use them in a report.
Common questions
- Will every sheet of my workbook appear in the PDF?
- Visible sheets are laid out as pages. Check the print preview first, because hidden sheets and areas outside the print area may be left out.
- Why does my table arrive in two sheets after PDF to Excel?
- The tool reads one page at a time, so a table that runs across two pages becomes two sheets. Copy the second part under the first.
- Do formulas survive a trip through PDF?
- No. A PDF stores the visible result, not the formula behind it, so rebuild any calculation after converting back.