Add Table
Open the app: Add a table to a PDF → (products.documentize.app)
In one sentence
Add Table takes the data from an Excel workbook and inserts it into your PDF as a formatted table, as new page(s) placed before the page number you choose.
What makes it unique
It is the only app that brings spreadsheet data into a PDF as a real table. Merger can also add an Excel file, but it simply converts the whole file into pages appended to the pack; Add Table lets you pick the sheet, treat the first row as headers, cap rows and columns, and decide where inside an existing PDF the table goes.
When to use it / when not to
- Use it to put a price list, schedule, budget or data appendix into a report PDF at a precise position.
- Use it to insert a table in front of page 1 as a summary page.
- Do not use it to draw a table on top of an existing page area. Per the code, the table is inserted as separate page(s) before the chosen page, not laid over your content (the site's FAQ talks about "placement overlaps" and a table "on top of the page content" — check on your own file).
- Do not use it to extract a table from a PDF → Extract apps.
- Do not use it for a one-off table with 3 cells — type it in the source document.
Before you start
- A PDF and an Excel .xlsx workbook. Upload both together.
- The site's file picker also accepts
.csv, but the processing step looks only for.xlsxfiles — save CSV as XLSX first (verify on the live app). - Tidy the sheet: one header row, no merged cells, only the columns you want. Cell values are used as text, so a formula cell shows its stored result.
- Up to 10 files can be uploaded at once.
Step by step
- Upload the PDF and the XLSX.
- Page Options: enter the page number before which the table is inserted (default 1).
- Excel Source Options: type a sheet name or leave empty for the first sheet; keep "First row contains headers" on if row 1 is a header; optionally tick "Include sheet names as section headers".
- Data Limits: set maximum rows / columns, or leave 0 for everything.
- Press Add table.
- Download the PDF and check the table pages.
📷 Screenshot placeholder: PDF + XLSX uploaded, options panel open
Options explained
| Option | What it does | Default | Recommended |
|---|---|---|---|
| Insert Page Before | The table pages are inserted before this page number. | 1 | 1 for a front table; page count + 1 is the way to try "at the end" (verify on the live app). |
| Sheet Name | Which worksheet to read. If the name is not found, the first sheet is used. | empty = first sheet | Type it exactly as in Excel. |
| First row contains headers | Row 1 becomes the header row. If off, columns are labelled A, B, C… | On | Keep on for normal tables. |
| Include sheet names as section headers | Adds a line like --- Sheet1 --- above the data. | Off | Useful with several workbooks. |
| Maximum Rows | Keeps only the first N data rows. | 0 = all | Set a cap for very long sheets. |
| Maximum Columns | Keeps only the first N columns. | 0 = all | Stay at 6–8 so text remains readable. |
Table styling (border, grey header, bold headers, font size 10) is built in; the page has no style controls.
What you get
A new PDF named like report_with_table.pdf; your original pages are unchanged and just shifted by the inserted table page(s). With several workbooks, their data is combined into one table, each introduced by its sheet name, with an empty row between files. A summary (rows added per workbook) is kept with the result.
Quality & limits
- Text-based, sharp at any zoom; no AI.
- Only the first sheet (or the sheet you name) of each workbook is read.
- Very wide sheets get cramped — limit the columns.
- Plan limits are environment-configured: see Limits & plans. The command-line version documents its own defaults of 1000 rows and 50 columns; the web page uses 0 (everything) — verify the live behaviour with a big sheet.
- Results are kept about 2 days.
Works well with
- Use before: Merger / Delete Page to settle the page order, because the insert position is a page number.
- Use after: Add TOC (so the table appears in the contents), Compressor.
- Recipes: Spec to plan, Submission pack.
Common mistakes & fixes
- "Error: no XLSX found" → you uploaded a CSV or an older .xls; save as .xlsx.
- "Wrong sheet shown" → the typed sheet name did not match, so the first sheet was used.
- "Headings look like data" → switch on "First row contains headers".
- "Table went in the wrong place" → page numbers count physical pages from 1; re-check after any page changes.
- "Columns cut off" → reduce Maximum Columns or trim the sheet.
Same thing elsewhere
Try it
Make an XLSX with a header row and 8 data rows (item, qty, price). Take a 3-page PDF. Upload both, set Insert Page Before to 2, leave the rest, press Add table. The result should have 4 or more pages: page 1 original, your table, then original pages 2 and 3.