Skip to main content
GridFiller
Sign inGet started

How to convert a screenshot table to Excel

Published

Single-screen tables are easy. The interesting case is the table that runs past the bottom of the window, or arrives as five separate captures from five different people. Here is how to get all of it into one Excel sheet.

Capture the table in overlapping sections

Scroll so that the last two or three rows of one capture reappear at the top of the next. The overlap makes it obvious afterwards whether anything was skipped, and duplicated rows are much easier to delete than missing rows are to notice.

Keep the column widths the same across captures — resizing the window mid-way changes the layout and makes alignment harder.

Choosing the right merge strategy

  • Append rows — the default choice for one table split across captures. The header is read once and rows stack in upload order.
  • Align by headers — for tables from different systems whose columns share names but not order.
  • Keep separate — for unrelated tables; each source becomes its own named worksheet in the exported .xlsx.

The full workflow

  1. 1. Upload all captures at once

    Up to 20 files per job, in the order they should stack.

  2. 2. Select append rows

    The strategy is saved with the job, so you can see later how a conversion was produced.

  3. 3. Preview the merged result

    A lightweight preview shows how the sources came together before you commit to the export.

  4. 4. Remove overlap duplicates

    Delete the repeated rows introduced by your overlapping captures.

  5. 5. Export .xlsx

    One sheet, one continuous table.

Checks that catch the expensive mistakes

  • Compare the final row count against the source's own record count if it shows one.
  • Sort by an ID or date column and look for gaps in the sequence.
  • Sum a numeric column and compare with the total shown in the original table.
  • Confirm no header row survived in the middle of the data.
  • Spot-check the first and last row of each capture, where clipping happens.

If the merge came out wrong

Re-run the extraction on the same files with a different strategy. The uploaded files stay attached to the conversion, so you do not need to collect them again, and you can compare the two results before deciding which to export.

Try it on your own file

Upload a screenshot, image, or PDF and GridFiller returns an editable table you can export to CSV or XLSX.

Open GridFiller

Related reading