Converting PDF to Excel: 4 real methods (from manual to free and online)

You want to edit or sum a table inside a PDF in Excel, but copying it makes a mess. The reason: a PDF has no concept of a "table" — it only keeps pieces of text with coordinates on the page. Every conversion method is really a guess at rows and columns from those coordinates. Here are four methods compared.

First, find out what kind of PDF you have

A simple test: try selecting text in the PDF with the mouse. If it selects, it's a text PDF and conversion is possible. If the whole page selects like an image, it's a scanned PDF and you need OCR first (method 4).

Method 1: manual copy and paste

Enough for a small, simple table. Copy the text, paste into Excel, and if everything lands in one column use Data → Text to Columns. The problem: in Persian PDFs, column order and text direction often scramble, and multi-page tables take forever.

Method 2: Excel's built-in importer

In newer Excel versions (Microsoft 365 and recent releases) use Data → Get Data → From File → From PDF. Excel lists the tables it detected and you pick one. It works well for text PDFs with tidy tables. Limitations: depends on your Excel version, and right-to-left text doesn't always come out clean — review the result.

Method 3: online tools that don't upload

Most PDF conversion sites upload your file to their servers. If the file is a report card, an invoice or an inventory list, that's a privacy risk. The JadvalSaz tool I built does all processing in the browser and never sends the file anywhere: it builds rows from Y coordinates and columns from the right edges of texts (suited to Persian), and produces one Excel sheet per page. Limits: 20 MB and 50 pages max; scanned PDFs are not supported.

Method 4: scanned PDFs and OCR

If the PDF is an image, text must be read from the picture first (OCR). Persian OCR tools vary in quality and the output always needs review — misread digits and similar-looking letters are common. If you can, get the original file (for example the accounting software's export) instead of scanning.

What to check after converting

• Row and column counts match the PDF.
• Numbers arrived as numbers, not text (if they're left-aligned and won't sum, they're text).
• Persian and English digits aren't mixed.
• Merged cells and broken rows are reviewed.
• The grand total matches the PDF.

Which method should I pick?

Situation	Suggestion
Small table	Manual copy
Text PDF, modern Excel	Excel's importer
Sensitive or Persian file	Upload-free tool
Scanned PDF	OCR, then review

Common questions

Why is the table scrambled after conversion? Because the PDF has no table structure; the tool guesses from coordinates. Messy layouts produce wrong guesses.

Is an online converter safe? It depends where the file goes. Prefer tools that process locally in the browser, especially for sensitive documents.