PDF to Excel Table Misaligned? Step-by-Step Fix Guide

When PDF-to-Excel output has shifted columns or split rows, first identify what went wrong. Some problems can be repaired in Excel; others require better recognition or another conversion attempt. No method guarantees correct structure for every PDF.

Why the table may not transfer cleanly

PDF describes a page rather than an Excel workbook. Even when a PDF has tags or logical structure, it need not contain reusable spreadsheet cells, formulas and data types. The converter may have to infer columns and rows from layout. Scans add a recognition problem, and malformed source text can also affect the result.

🔍 Identify Your Misalignment Type (Before Fixing)

Different problems need different fixes.

Type 1 — Shifted Columns

⏺ Data moves into wrong columns
⏺ Numbers appear under wrong headers

Type 2 — Broken Rows

⏺ One row splits into multiple lines

Type 3 — Merged Cell Loss

⏺ Headers or grouped cells disappear

Type 4 — Multi-Column Confusion

⏺ Data from different sections mixes together

🚀 Step-by-Step Fix Guide (Practical Workflow)

Choose the appropriate recovery method

Work on a copy and keep the source beside it. If the PDF contains selectable text, try the free local Excel workflow. If it contains scanned tables, use paid cloud OCR in the LeoPDF store editions. Files for that cloud conversion are deleted when processing completes. LeoPDFree does not include OCR.

Do not assume every broken table is only a formatting problem. Check whether characters are already wrong before moving cells; rearranging columns will not repair a misrecognized amount.

🛠️ Step 2 — Use Excel “Text to Columns”

Best for column shifts:

1️⃣. Select the problematic column
2️⃣. Go to Data → Text to Columns
3️⃣. Choose “Delimited”
4️⃣. Adjust separators

Use Text to Columns when values are joined in one column and a reliable separator or fixed-width boundary exists. Preview the split and select an empty destination so adjacent data is not overwritten. It will not automatically repair broken rows, missing entries or OCR errors. Consult Microsoft’s Text to Columns instructions.

Clean values without damaging identifiers

Use a copy when removing extra spaces or converting text to numbers. Excel’s =TRIM(A1) can help with ordinary extra spaces, but it does not remove every kind of whitespace. =VALUE(A1) converts numeric text; check separators and dates before applying it to an entire column. Do not convert identifiers or account numbers if that would remove leading zeros.

Review tables split across pages

Check repeated headers, continuation rows and totals before combining sections. Where available in your Excel installation, Power Query’s PDF connector can import detected tables for inspection and transformation. Capabilities depend on the host. Review Microsoft’s PDF connector documentation and compare its detected tables against the source.

Converting PDF to HTML is not a guaranteed repair: an export may preserve positioned text rather than real table cells. Check whether a particular output contains useful table structure before trying another import. A claim that AI automatically fixes every irregular layout is not a substitute for checking the result.

Validate before using the spreadsheet

• Compare row counts and the first and last entries on every source page.
• Check headers, merged groups, negative signs, decimal separators and units.
• Reconcile totals with the source while checking individual values.
• Look for omitted lines or duplicated continuation rows.
• Keep the PDF and a record of manual corrections.

For financial data, use the bank-statement conversion checklist. A matching grand total alone does not prove each row is correct.