TableXL / Practical guide

Copy table from PDF to Excel without shifting columns

Use clipboard paste for a small text table, diagnose broken columns and know when to switch to extraction.

Try a small clipboard sample

To copy a table from a PDF to Excel, select a few rows in the PDF viewer, copy them and paste them into an empty worksheet. Start with a copy of the document and a blank workbook so you can undo without overwriting existing work. Include the header, one ordinary row and one row with a long description in your test. Clipboard copying can be enough for a short selectable-text table and needs no paid converter. If the selection captures only an image, you need recognition or another source before ordinary text paste will help.

Inspect what actually reached the clipboard

Look at the formula bar as well as the visible cells. All the text may have arrived in one column, each visual line may have become a separate row, or numbers may have separated at spaces. A monospaced-looking preview can disguise these differences. Paste a copy into a plain-text editor if you need to see tabs and line breaks more clearly. Do not start sorting the sheet until you know which cells belong to the same source record. Sorting a broken paste can make later repairs difficult to trace.

Split columns using real separators

Excel's Text to Columns can separate a single pasted column using tabs or another consistent delimiter. Preview the split and mark identifier columns as Text before finishing. Spaces are risky separators when descriptions themselves contain spaces; fixed-width splitting can work when positions remain consistent across all rows. Avoid applying one guessed split to pages with different column widths. For dates and number formats, retain the original text until the source convention is established. A leading zero lost during paste cannot be recovered by merely widening the column afterward.

Repair wrapped rows from the source

Compare long descriptions with the PDF. A continuation line may need to join a description on the preceding row, but it must not become an extra customer or product. Move the text only after checking the source and keep associated amounts in their original logical record. Do not merge worksheet cells as a substitute for reconstructing the table: merged cells can obstruct sorting and filtering. If many rows need this repair, test a table extractor on one page before switching, because TableXL and some other extractors do not join wrapped rows automatically.

Know when another free method is clearer

For a longer selectable-text table, Tabula lets you select the table region and export CSV locally for free. Where available, Excel's PDF connector can detect a table without clipboard copying. Inspect the extracted rows before loading either result; both routes still need boundary checks. Count records, compare the first and last entries, and recompute any printed subtotal. Check every code, negative number and decimal convention that matters to your task. Use a dedicated preview tool only if its correction workflow makes these checks easier on your actual document.

Choose between a delimiter and fixed positions

Paste three varied rows into a scratch sheet and compare their raw text. If columns are separated by tabs, use a tab split and inspect the resulting width for each row. If separation depends on character positions, try fixed-width boundaries only after checking the longest description and the widest number. A description containing spaces is not a reason to split at every space. When one row requires different boundaries from the others, stop applying the same operation to the whole selection. Keep the untouched paste so you can undo a wrong split without returning to an already edited table.

Check rectangular selections against reading order

A PDF viewer may copy a page in a reading order that differs from its visual columns. If a two-column page pastes all left-hand values followed by all right-hand values, rearranging cells by eye is risky. Try selecting only the table region or one logical column on a working copy, then compare the first, middle and final records. For a tiny table, deliberate re-entry may be easier to verify. After reconstruction, check that the number of descriptions matches the number of amounts and inspect any blank cells in between; equal counts alone do not prove correct pairing.

Where TableXL fits

TableXL can help inspect extracted columns, edit cells and headers, merge a column with the next, or split at the first literal separator. Those tools do not join wrapped data rows or automatically type numbers and dates. A conversion accepts one PDF up to 15 MiB, 100 pages, 3,000 rows and 40 columns; encrypted files are unsupported. The fixed trial covers the first two data pages within the first six pages, with corrections and downloads. Continuing that file keeps your saved results and corrections; the original expiry stays the same. Additional successful pages need page credits.

Check two pages with data free See page packs

Written by Zijian Xiao. Examples are synthetic. Review all extracted results against your original PDF.