NewSign up free to get 3 credits to try our new Merge Sheets feature

New: Merge Multiple Tables Into One Excel Sheet, Straight From Photos and PDFs

You have six photos of statement pages. Or a three-page scanned PDF where every page carries the same table. Or a stack of monthly reports that all arrived as images. Getting each one into Excel is one job. Combining them into a single sheet is a second job, and it is the one people dread.

We just added a way to do both in one go: merge tables from multiple images or PDF pages into one Excel sheet, by matching column headers or by column position.

The Usual Way, and Why It Feels Like a Lot

Once your data is in Excel, the standard tool for combining tables is Power Query. It is genuinely powerful, and if you work with data every day it is worth learning. But for a one-time merge, the setup can feel out of proportion: loading each table as a query, appending them, fixing column names that do not quite match, and then refreshing the result. If you have never used it, the first attempt tends to involve a lot of searching.

The other common route is copy and paste, which works until you have more than a few tables, or the columns are in a different order in each one.

And if your data started as photos or scans, you have to convert everything to Excel first, before either approach can even begin.

Step 1: Upload Your Files

To merge, you need at least two tables. Upload two images of tables, or one PDF with two pages, to Imgtosheet, then use the merge feature. You can upload more than two if you have them. Each image becomes its own sheet, and each page of a PDF becomes its own sheet too, so a two-page PDF and two separate photos are treated the same way.

Merging is a sign-in feature. Sign-in is free (a link sent to your email, no password), and each merge costs 1 credit. New accounts get 3 bonus credits to try it, enough for three merges.

Step 2: Choose How to Merge

You get two options, depending on what your tables look like.

Match by column headers. Use this when your tables have header rows. Columns are lined up by name, so "Date" from one table sits under "Date" from another even if the columns are in a different order. Matching ignores capitalization and extra spaces, but it is otherwise exact: "Date" and "Transaction Date" are treated as different columns and will appear side by side rather than being combined. A column that has no match in the other tables is kept as its own column, so nothing is silently dropped.

Stack by column position. Use this when your tables have no headers, for example continuation pages of a long statement where the header only appears on page one. The first column of each table is stacked under the first column of the previous one, the second under the second, and so on. This assumes your columns already line up in the same order, since there are no headers to check against.

Step 3: Check the Preview Before You Download

As with every conversion, you get an editable preview before anything is downloaded. Look at the merged result, fix any cell the OCR misread, and confirm the columns landed where you expected.

Step 4: Download the Excel File

Download the merged sheet as an XLSX file, ready to sort, filter, or total.

When This Works Well, and When to Double-Check

Header matching works best when your tables come from the same source: monthly statements from one bank, the same report exported each week, or multi-page documents with one repeated header. The cleaner your original photos and scans, the cleaner the merge.

A few things worth checking:

  • Header spelling. Because matching is exact, a column called "Amt" in one table and "Amount" in another will not combine. Fix the header in the preview, or use position matching instead.
  • Position matching assumes alignment. If one table has an extra column in the middle, everything after it will be shifted. Glance at the preview before downloading.
  • OCR is not perfect. A misread header can cause a column to fail to match, so it is worth confirming the header row looks right.

One more thing to be clear about: this merges tables that come from photos and PDFs. If your tables are already Excel files, Power Query is still a good tool for that.

Try It

If you have a stack of statements, invoices, or reports sitting in photos or PDFs, this is the case it is built for. Sign in and use your 3 bonus credits (1 credit per merge) on a real batch. If it saves you an afternoon, it has done its job, and if something does not merge the way you expect, we would like to hear about it.