# Scan to Excel: From Paper Page to Spreadsheet

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-16
- Category: Scanned and image statements
- Canonical: https://fastbankconvert.com/blog/scan-to-excel

> Scan to Excel from paper: which device to use, the scanner settings that help conversion, and how to handle multi-page documents and poor originals.
To scan to Excel, scan the paper flat and straight at 300 DPI in greyscale, save it as one PDF, then run that file through an OCR converter that writes a spreadsheet. The scan sets the ceiling for the result: a clean scan converts well, and a poor one costs you hours of fixing.

## Flatbed, phone app or copier for scan to Excel?

A flatbed scanner gives the best input, a phone scanning app is good enough for a few clean pages, and an office copier is the practical choice for a thick stack. The device matters less than keeping the page flat, square and evenly lit.

### How each device compares

- **Flatbed scanner.** The page lies flat on glass under constant light, so there is no shadow, tilt or curl. It is slow for a big stack unless it has a sheet feeder, but it is the most reliable for a creased or bound page.
- **Phone scanner app.** It is always with you and needs no setup. It suffers from the things a camera suffers from: shadows, angle and uneven light. Good apps correct perspective and crop automatically, which helps. [Photographing a table well](/blog/image-to-excel#screenshots-vs-phone-photos-for-image-to-excel) covers the shooting side.
- **Office copier or multifunction printer.** A sheet feeder takes a stack in one pass and can email you a multi-page PDF. Quality varies by machine, and default settings are often tuned for small files, not for OCR.

### A simple way to choose

Use a copier with a feeder for more than about ten loose sheets. Use a flatbed for anything fragile, stapled or faded. Use a phone only when nothing else is nearby, and then use the app's document mode, not the plain camera. If the paper is a bank statement, the bank may have a digital copy, so [scanning a bank statement to Excel](/blog/scan-bank-statement-to-excel) asks that question first.

## Scanner settings that help Excel conversion

Use 300 DPI, greyscale and PDF output for most printed pages. DPI means dots per inch, the number of pixels the scanner records for each inch of paper. Too few pixels blur small digits, and too many only make large files. Greyscale keeps faint print that pure black-and-white drops.

### Why these defaults

- **300 DPI** is a common target for OCR on normal print. Below it, small digits lose their shape. Above it, files grow without much gain for ordinary type. Try 400 or 600 only for very small print, and expect big files.
- **Greyscale** keeps the soft edges of letters. Pure black-and-white mode (sometimes called text or 1-bit) throws away any ink that is lighter than its cut-off, and faint digits disappear for good. Colour is only worth it when coloured shading or stamps carry meaning you need to read.
- **PDF output** keeps all pages in one file in order. A folder of JPGs works too, but sorting becomes your job.
- **Auto-crop** removes the dark scanner edge. Switch on auto-deskew if the device offers it.
- **No heavy compression.** Choose medium or high quality. Aggressive JPG compression inside the PDF smudges digits.

### Settings by device

These are suggested starting values, not rules. Check your own device's menu names.

| Setting | Flatbed | Phone scanner app | Office copier |
| --- | --- | --- | --- |
| Resolution | 300 DPI | Highest quality or "high" | 300 DPI |
| Colour mode | Greyscale | Greyscale or "document" filter | Greyscale |
| Output | PDF | PDF | PDF |
| Auto-crop | On | On | On if offered |
| Multi-page mode | Add pages to one file | Add page, keep going | Feeder to one PDF |
| Page orientation | Match the paper | Hold camera parallel | Load upright |
| Flash | Not applicable | Off | Not applicable |

### Check before the whole stack

Scan one page with your settings and open it at full size. Can you read the smallest figure without squinting? If not, raise the setting. Then convert that one page to see how it comes out. Ten seconds on a test page saves redoing forty. For what the OCR does with the result, [what OCR reads on a scanned PDF page](/blog/ocr-pdf-to-excel#what-ocr-reads-on-a-scanned-pdf-page) explains the steps.

### Mistakes that ruin a good scan

- **Scanning two pages at once.** Two pages on the glass give one image with two layouts, and the table step cannot tell where one ends.
- **Leaving the lid open or the page crooked.** Light leaks in and the page skews. Close the lid and align the page with the corner mark.
- **Using the default copier setting.** Many machines default to small files and low resolution. Check before you scan the whole stack.
- **Scanning in colour at high resolution by habit.** It makes slow, huge files that gain nothing for black print.
- **Throwing the paper away early.** Keep it until the sheet has passed its checks. A misread you cannot compare with the paper is a misread you cannot fix.

## Multi-page paper documents in one scan file

Make one PDF with the pages in order. One file is easier to name, store and convert than a pile of images, and the page order is fixed inside it. Separate images make sense only when a tool requires them, or when a single bad page needs replacing.

### Keeping one file reliable

- Use the device's multi-page mode, which is sometimes called "add page" or "scan more".
- Number the pages on the paper in pencil if they are not numbered, so you can tell if two got swapped.
- Scan the front of every sheet. Skip blank backs, or delete them after, because a blank page in the middle of a statement is harmless for OCR but adds a useless sheet to the result.
- Open the finished PDF and flip through before you convert. Check the count against the paper.

### When one file is too big

Long scans become large files. A scan of several dozen pages at high resolution can be big enough that an upload fails or times out. Split by chapter, by month or by every twenty pages, convert each part, and join the sheets. [Converting large PDFs to Excel without timeouts](/blog/convert-large-pdf-to-excel) covers splitting and joining.

If you must replace one bad page, you can re-scan only that page and swap it into the PDF using any PDF tool, which is easier than re-scanning the lot.

## Do faxes and carbon copies scan into Excel?

Sometimes, with lower accuracy. Faxes and carbon copies are poor originals: low resolution, faded or smudged ink and uneven contrast. OCR can still read many of them, but expect more misreads, and plan to check every figure instead of a sample.

### How to give a poor original the best chance

- **Fax.** A fax already has a low pixel count, so scanning it at a higher DPI adds file size, not detail. Scan at 300 DPI, greyscale, and accept the limit. Ask the sender for a fresh digital copy if it is possible.
- **Carbon copy.** The ink is often purple or blue and light. Greyscale keeps it. Try a slightly darker contrast setting, if the device offers one.
- **Photocopy of a photocopy.** Each generation thickens strokes and fills in loops. Go back to the earliest copy.
- **Thermal paper.** Printed receipts fade. Scan them soon, or photograph them in good light before they fade further.

### What to expect

Whatever the original, the digits are where trouble shows. Commas turn into periods, 1s turn into 7s and 5s turn into Ss. [The common OCR digit errors on bank statements](/blog/bank-statement-ocr-digit-errors) lists them with ways to catch each. The same checks work on any printed table: a total that must match, a balance that must roll forward, and a row count that must match the paper.

Do not treat a poor original as hopeless before you test it. Run one page, look at the sheet next to the paper and decide. If more than a handful of cells per page need hand correction, retyping the page may be faster than repairing the conversion.

## Naming scan files so pages stay in order

Name files so that alphabetical order equals page order. Put the document, the date and a zero-padded page number in the name, and a stack of images will sort itself. The zero-padding matters because sorted names place "page-10" before "page-2" without it.

### A naming pattern that works

An example pattern is `client-account-2026-03-p01.jpg`, with p02, p03 and so on. The parts are:

1. A short name for the source, such as the client or account.
2. The period the document covers, written year first so it sorts in time order.
3. A page number with a leading zero, two digits for up to 99 pages and three for more.

| Poor name | Better name | Why |
| --- | --- | --- |
| scan.pdf | acme-checking-2026-03.pdf | Says what it is |
| IMG_4412.jpg | acme-checking-2026-03-p01.jpg | Phone default hides the order |
| statement 2.jpg | acme-checking-2026-03-p02.jpg | Zero-padded, so p10 follows p09 |
| march final FINAL.pdf | acme-checking-2026-03.pdf | One version, no guessing |

### After conversion

Keep the scan PDF and the finished spreadsheet next to each other with the same base name, so you can always return to the paper image. When a figure looks wrong a month later, the scan is your evidence of what was printed.

FastBankConvert takes bank statement PDFs, and its FAQ says scanned paper statements take longer than digital ones. It is getting ready to open, so [the get started page](/get-started) will notify you when trial conversions start.