Many office copiers can scan to Excel: their built-in OCR reads the page and saves an .xlsx file to email, a network folder or a USB stick. Whether yours can depends on the model and its optional kits. Check the scan file format list on the panel. If XLSX appears, paper can become a spreadsheet at no extra cost.
Can your office copier scan to Excel?
An office copier can scan to Excel if it has OCR, which is optical character recognition, the step that turns a picture of a page into characters. Many recent multifunction copiers include OCR or offer it as an add-on kit. Without it, the copier can only save images and image PDFs.
The manuals of two large copier makers show how much the answer varies inside one product line:
- Sharp. The scan settings page of the Sharp BP-70M65 manual lists TXT, DOCX, XLSX and PPTX among the initial file formats for the BP-70M series. On some BP-50M models the same formats appear only once an enhanced compression kit and an OCR expansion kit are installed. The page also says these formats cannot be chosen if OCR has been disabled in the settings.
- Konica Minolta. The OCR operation setting page for the bizhub C287 and C227 says that choosing DOCX or XLSX as the file type requires optional Extension Memory and the i-Option LK-110 v2 licence.
So two machines that look alike in the hallway can differ in exactly this feature. The only way to know is to look at your own machine, or ask whoever manages it whether the OCR kit was bought.
Who to ask
In an office, the copier usually belongs to a lease or a service contract. The office manager or the IT person who handles the copier can say whether the OCR option is licensed, and can switch it on if it was bought and left disabled. A home user with a small all-in-one printer is less likely to have this feature on the device itself. Many of those printers do their OCR in the companion app on the computer instead.
Finding the copier scan to Excel setting on the panel and web page
The scan to Excel setting sits in the file format list of the scan screen on the copier's touch panel. Start a scan to email or to a folder, open the file format or file type option, and look for XLSX, sometimes labelled Excel or Microsoft Office. Administrators can also change the default format on the copier's web page.
The steps below are general. Your panel's labels will differ by brand, so match them loosely.
- Walk to the copier and choose the scan function, not copy.
- Pick a destination: your email address, a network folder, or a USB stick if the machine has a port.
- Open the settings for that scan. Look for File Format, File Type or Format.
- Open the list. If you see XLSX, Excel or a Microsoft Office group, choose it.
- If the list shows only PDF, TIFF and JPEG, the OCR option is either not installed or switched off.
- Look for a searchable PDF entry as a fallback. It also uses OCR, and it gives you a PDF with a text layer.
Most networked copiers also have a web page you can reach by typing the copier's IP address into a browser. Sharp's manual, for example, puts the initial file format under the system settings for scanning. On many machines that web page holds the administrator options, so ask before changing defaults that everyone uses.
Copier OCR settings for a paper bank statement
The best copier OCR settings for a statement are black and white or greyscale, 300 dpi, the OCR quality option rather than speed, and the right language. These favour accuracy over file size. The Konica Minolta manual shows the trade-off clearly: its OCR setting offers Prioritize Quality and Prioritize Speed, and speed is the default.
The table lists the settings to look for, with example values for a typical statement. Labels vary by brand.
| Setting | Example value for a statement | Why |
|---|---|---|
| File format | XLSX | Gives you a spreadsheet to open in Excel |
| Resolution | 300 dpi | Small print on statements needs the detail |
| Colour mode | Greyscale or black and white | Coloured shading can confuse OCR |
| OCR priority | Quality | Konica Minolta says quality mode also straightens a tilted original |
| OCR language | English, or the statement's language | Wrong language means wrong characters |
| Original size | Letter or A4, matching the paper | Prevents cropped edges |
| Destination | Your own email or a private folder | See the security section below |
Preparing the paper
Remove staples, flatten folds and feed pages straight. A crooked page jumbles rows, because the OCR can read a slanted line as two lines. Use the glass for a torn or crumpled page, and the document feeder for a clean stack.
If the statement has a dark logo or shading behind alternate rows, try one page in black and white and one in greyscale, then keep whichever reads better. Try this on one page before you scan twelve months.
What a copier Excel file looks like when it opens
A copier Excel file is usually a picture of the page rebuilt from text boxes, not a clean table. Expect merged cells, the bank's address in the first rows, columns that shift between pages, and amounts stored as text. It is a starting point you clean up, not a finished ledger.
Here is a five-point check to run on the first file before you scan the rest:
- Rows. Count the transaction rows against the printed page. A missing row usually sits at the top or bottom of the page.
- Columns. Check that dates, descriptions and amounts landed in separate columns, and in the same columns on every page.
- Numbers. Click an amount. If it is left-aligned or shows a small green triangle, it is text and will not add up.
- Digits. Compare a dozen amounts with the paper. OCR swaps look-alike characters, such as 5 and S, or 0 and O.
- Balance. Add the deposits, subtract the withdrawals, and compare with the closing balance printed on the statement.
Fixing what the check finds
Unmerge cells first, because merged cells block sorting and filtering. Delete the header and address rows. Convert text amounts with Data, Text to Columns, finishing on the General format, or with VALUE in a helper column. If the columns shift from page to page, it is often faster to copy each page's block into the right columns by hand than to fight a formula.
Statement lines that look odd are worth a second look for a different reason. A line such as "OUTGOING WIRE FEE" may be the OCR reading correctly, and a charge you would rather avoid. How to spot and reduce wire transfer fees explains what those lines cost and how to pay less.
Copier scan to Excel versus free OCR tools: which output wins?
Copier scan to Excel usually beats free OCR tools on convenience, because the paper goes in and a spreadsheet comes out with nothing to install. It does not reliably beat them on accuracy. Copier OCR and free OCR engines make the same kinds of digit errors, and both need the balance check.
Compare the routes on the things that matter:
- Speed for a stack. A copier with a document feeder scans a year of statements in minutes. Free tools on a computer need a scanned file first, so the copier still does the scanning.
- Table structure. Neither route understands what a bank statement is. Both give you text arranged roughly where it sat on the page.
- Control. Free tools let you rerun OCR with different settings on the same image. A copier makes you rescan.
A hybrid that often works better
Scan to searchable PDF on the copier, then work with that PDF on your computer. A searchable PDF has a text layer from the copier's OCR, so you can select text in it. In Microsoft 365 Excel for Windows, you can try Get Data, From PDF on it, which reads text PDFs. The steps for that import are in importing a PDF to Excel free with Get Data. Results vary, because an OCR text layer is not always laid out as a neat table. Test one page.
If you use the browser version of Excel, note that it lacks some of the desktop's import tools. What the free Excel for the web lacks for PDF import lists the gaps. And if you want to run OCR yourself with full control, Tesseract OCR for bank statements walks through the free open source engine and its fiddly parts.
Where a converter fits
A converter fits best when you can get the statement as a PDF from online banking instead of paper. CheapBankConvert, which is preparing to open, is built for text-based PDF statements, with early prices from $2.99 per statement and a free 2-page preview. For paper you cannot get again as a download, the copier is often the cheapest first step.
Copier scan security edge case: statements left in a shared folder
The security edge case with a copier is where the scan lands. Many offices set scan to folder to a shared network folder that every employee can open, and the copier may keep a copy in its own storage too. A bank statement in that folder shows your account number and spending to anyone who browses it.
Ways to keep the scan private:
- Scan to your own email, not to a shared folder, then delete the email once the file is saved.
- Use a USB stick if the copier has a port and your office allows it.
- Check the folder after scanning. If the file went to a shared location by default, move it out and delete the original.
- Ask about the copier's storage. Many copiers keep jobs on an internal drive. The person who manages the machine can say how long they stay there and whether they are wiped.
- Do not leave pages on the glass. The paper original, left on the copier, is there for the next person to read.
If the copier belongs to your employer, the same thinking applies as with any work equipment. Check your employer's policy before scanning personal papers on it, because the file passes through systems your company controls. For a personal statement you scan often, a home scanner or your phone may be the more private choice, even if the copier's OCR is better.