After converting a PDF to Excel, why do numbers come through as text so that SUM doesn't work?

The most common cause is a mismatch in decimal and thousands separators. If the table in the PDF was produced with English formatting, numbers appear as 1,234.56; if your Excel is set to a regional setting that expects the comma as the decimal separator, it can't recognise that value as a number and treats it as text. Currency symbols, percent signs, or invisible space characters next to the number cause the same problem. To fix it, select the cells and run Excel's Text to Columns wizard on the Data tab, then specify the correct separators under the Advanced option.

Table rows arrive crammed into a single cell in Excel. What should I do?

This indicates that in the source PDF the table isn't a real table structure but merely aligned lines of text. Because the converter couldn't derive the cell boundaries, it puts the entire row into a single cell. To fix it in Excel, select the crammed column and use Text to Columns on the Data tab; when you choose space or tab as the delimiter, the data usually distributes into the correct columns. For a table with regular column widths, the Fixed Width option gives more accurate results.

How do I export a long table that spans multiple pages?

Long tables generally arrive after conversion as a separate block for each PDF page, with page headers, repeated column headings, and page numbers mixed in between. To turn these into one continuous table, you first need to delete the repeated header rows and footer information. Because these rows usually follow a clear pattern, they can be selected and deleted in bulk using Excel's filter feature. If the data has ended up on separate sheets, you can merge it by copying one beneath the other, as long as the column structures match.

Can I export a scanned table to Excel?

There's no data you can export directly, because in a scanned PDF the page is essentially an image containing no machine-readable digits or text. OCR, meaning optical character recognition, has to be applied first. But you need to be especially careful here: OCR is prone to character confusion with numerical data, and similar pairs such as zero and capital O, one and lowercase l, or six and eight can be misrecognised. Where financial or critical data is involved, OCR output should not be used without comparing it against the original line by line.

How to Export a Table from PDF to Excel: A Step-by-Step Guide

You don't have to retype the table

You have a financial report, a bank statement, a price list, or a statistical publication, and you need to do calculations with the table inside it. But the file is a PDF, and although the table looks perfectly fine on screen, you can't perform any operation on it. Typing the numbers into Excel one by one takes hours with a table of hundreds of rows, and every manual entry carries a risk of error.

This guide covers the steps for exporting tables from a PDF into Excel, the corrections that are needed almost every time afterwards, and what to do to make the result trustworthy.

Step 0: Determine what kind of table you have

Before you begin, the one thing you need to do is check whether the table in the PDF actually contains text. Open the PDF and try to select one of the numbers in the table by dragging your cursor over it.

If the number can be selected individually, the file is text-based and you can convert it directly. If dragging selects the whole page like an image, the file is scanned; in that case it needs to go through OCR first, and you'll need to check the result far more carefully.

Step 1: Upload the file and convert it

Open the PDF to Excel conversion tool, drag and drop your file, and start the conversion. Processing runs on the server side; the duration varies with the page count and table density. A multi-page financial statement can take noticeably longer than a simple list.

When conversion finishes you'll have an XLSX file. You can download it and open it in Excel, LibreOffice Calc, or Google Sheets.

Step 2: Do an initial check

When you open the file, don't start correcting things straight away; check three things first, as they'll show you what to do in the following steps.

First, verify the row count. Knowing how many data rows were in the original PDF table, compare that with the row count in Excel. Missing rows mean the converter mistook some rows for content outside the table.

Next, look at column alignment. Is every value in the right column, or have values shifted by one column in some rows? Shifting is usually seen in rows that have empty cells.

Finally, check the number format. Select a numeric column, does a sum appear in Excel's status bar at the bottom? If it doesn't, the values have come through as text, and you can't perform any calculation until you fix that.

Step 3: Fix the number formats

This is the most common and most critical problem in table exports, because when it goes unnoticed it silently produces wrong results.

If numbers came through as text, first understand why. The most common cause is a decimal separator mismatch: if the source document uses a period and your Excel expects a comma, the values aren't recognised. The second common cause is a currency symbol or percent sign left next to the number. The third is invisible special space characters; these look like a space in the cell but are characters that break the number as far as Excel is concerned.

To fix it, select the target column and run the Text to Columns wizard on the Data tab, then use the Advanced button on the final step to specify the decimal and thousands separators used in the source document. This single operation converts the entire column to the correct number format. If invisible characters remain, Excel's TRIM and CLEAN functions will remove them.

Step 4: Make the structural corrections

Once the numbers are sorted, tidy up the table's structure.

Unmerge merged cells. The converter may interpret headings that appear wide in the PDF as merged cells. Merged cells break sorting and filtering, so they need to be unmerged before you work with the data.

Delete repeated headers. In multi-page tables, the column headings at the top of each page get mixed into the data. The quickest way to clean these up is to apply a filter to the relevant column, select the heading text, and bulk-delete the resulting rows.

Remove empty rows and columns. Visual gaps in the PDF can turn into empty rows in Excel. These need clearing because they can split your data in two when you sort.

Organise the columns with a single header row. For Excel's filter, sort, and PivotTable features to work properly, the table needs a single-row header and uninterrupted data rows beneath it.

Step 5: Verify accuracy

This step must not be skipped, especially with numerical data. Even if the export looks technically successful, a single misread digit ruins your entire analysis.

The most practical verification method is comparing totals. If there's a total row in the original PDF, sum the same column in Excel and compare the two values. If they match, the export is most likely complete. If they don't, the difference gives you a clue about what kind of error occurred; for example, if the difference is exactly equal to one row's value, that row has dropped out.

If there's no total row, selecting five or ten rows at random and comparing them with the original is also a reasonable check. With scanned documents, however, this check isn't optional but mandatory, because OCR is prone to confusing digits.

Things that make conversion easier

What most affects the result isn't the tool's settings but the structure of the source table. Tables with clear borders, properly aligned cells, and a single line of text in each cell export almost flawlessly. By contrast, borderless tables aligned only with whitespace, tables with multiple lines of text stacked inside a cell, and tables with nested header structures are the hardest cases.

An honest note here: with complex table structures, no automatic conversion produces an identical result. The reason is that the PDF format usually doesn't store table structure at all; the file only records which text gets drawn where. The converter has to guess cell boundaries by looking at coordinates and lines. That's why planning for a degree of post-conversion correction as a normal part of the process is far more productive than continually trying different tools.

When does manual entry make more sense?

If the table is shorter than twenty or thirty rows and its structure is complex, entering it manually often finishes faster and gives a cleaner result than converting and tidying up. Likewise, if you only need a few values, selecting and copying them from the PDF is enough. Conversion delivers real gains with tables of hundreds of rows and with work that recurs regularly.

In summary

Exporting a table from PDF to Excel is a five-step process: identify the file type, convert, do an initial check, fix number formats and structural problems, then verify accuracy. The most critical point is number formats, because when unnoticed they silently produce incorrect calculations. Regularly structured tables export almost completely, complex structures require manual tidying, and scanned tables must be verified row by row.