When to use it
- Ledgers, financial records or schedules that need to become exhibits or go into a bundle
- A wide sheet that prints with text too small to read when Excel fits it to one page
- A workbook with hidden rows, columns or sheets, where you need to know what is hidden
- A workbook with many sheets when you only want some of them
Before you start
- Desktop Microsoft Excel on this computer (Microsoft 365, Office 2021 or Office 2024). Sudex uses it in the background both to read each workbook’s sheets and to make the PDFs.
- The workbooks: .xlsx, .xlsm, .xlsb or .xls, or CSV files.
- Workbooks that need a password to open: save an unprotected copy in Excel first.
Step by step
Open Sheets
Click Sheets under MAKE & FIX PDFS in the side bar, or press Ctrl+8.
Click Add spreadsheets
Choose workbooks or CSV files, or drop them or a folder anywhere on the window. Sudex reads each one with Excel and lists every sheet, hidden and empty ones included; hidden sheets start unticked.
Look over the sheets
Click a workbook to open its sheets, and a sheet to see its first page, the size its text will print at, its smallest text and its pages, with a sentence on what was done. The strip at the top counts sheets that fit as they are, adjusted, and too small to read; All, Adjusted and Problems filter the list.
Set the rules for every sheet
With APPLY THESE SETTINGS TO on All sheets, work through Smallest text size, The page, If it still won’t fit, What goes in, Top and bottom of every page and What gets saved. Point at a choice to see it on the page before you click it.
Set a sheet by hand if you need to
Click Only the sheet I’m looking at to set that one sheet’s orientation, paper, margins and pages side by side, or switch off Include this sheet in the job. It stops following the rules until you click Put it back under the rules.
Open Worth checking first
The drawer at the foot lists sheets too small to read, sheets that run to 60 pages or more, hidden rows, columns and sheets, workbooks that link to other files, and any workbook that can’t be opened.
Click Convert
The button says how many, for example Convert 3 spreadsheets. Stop after this one finishes the file being worked on and then stops.
Read the results
Every workbook is accounted for: converted, couldn’t be, not reached, or left out by you. Read anything under NEEDS YOUR EYE, then click Open the folder, Send to… to put the PDFs into Bundle, Pages or Stamp, or Back.
Settings worth knowing
What you get
- One PDF per workbook, named after it (for example “Trust ledger.pdf”), or one per sheet named “Workbook - Sheet.pdf”, or both, in the folder you chose (Converted, beside the first workbook, unless you change it). A name already taken gets a number.
- A results screen listing every workbook with the files saved and their page counts, any sheet that came out smaller than your smallest size, and anything else worth knowing.
What Sudex checks for you
- Every sheet of every workbook is listed, hidden and empty ones too, so nothing in a workbook disappears without a word.
- Each sheet is measured against your smallest text size before converting, and flagged Too small to read if the rules can’t get it there.
- Hidden rows, columns and sheets, links to other files, and very long sheets are pointed out in Worth checking first.
- Excel works on a temporary copy of each workbook, with macros disabled before it is opened, and links to other files are not refreshed.
- Each original is read again afterwards to confirm it did not change.
- Every workbook gets an outcome, and the results headline says “Nothing was skipped quietly.”
Tips
- Point at any option and the page preview shows its effect, with a Preview badge; move away and it goes back. Nothing changes until you click.
- The smallest text size is the setting that matters most. In the app’s words: “For 11 pt text, 70% is about 8 pt, the size of a footnote.”
- Mail, Pages, Bundle and Stamp use the rules saved here with Make these my defaults for the spreadsheets they convert, not whatever is on this screen, so save good defaults.
- Links to other files are not refreshed, so the PDF shows the values as last saved, which is usually what you want for evidence.
- Chart sheets and macro sheets are not converted; if you need them, convert them from Excel directly.
- A CSV file goes in as one sheet with every value exactly as written: “000123” keeps its zeros and long numbers are not turned into 1.23E+15.
If something goes wrong
A workbook won’t open
Read the line under it in the list. “… is locked with a password, so it cannot be opened without one” means: open it in Excel with the password, save a copy without one, and convert that. “Excel could not open '…': it looks damaged, or it is not really a workbook” means: open it in Excel to see whether Excel can repair it, and convert the repaired copy.
Nothing lists, or every workbook fails
If the reason is “Microsoft Excel is not installed, or its COM automation is not registered on this machine”, Sheets can’t work on this computer yet. In Settings, Microsoft Office on this computer shows whether Excel was found.
A sheet is marked Too small to read
Even with everything the rules allow, it can’t reach your smallest size. Try switching on Use a bigger sheet, allowing more pages under Most pages side by side, lowering the smallest size, or setting that sheet by hand. With Convert and flag it is converted anyway and flagged; with Leave it out it is left out and listed.
It says Excel opened the file in Protected View
The message is “Excel opened '…' in Protected View and would not export it.” Open it in Excel once, choose Enable Editing, save, and convert again.
Rows or sheets I can see in Excel are missing
They may be hidden in the workbook. Switch on Show hidden rows or Show hidden columns, or tick a hidden sheet in the list to include it. The workbook itself stays as it is.