Snipping Tool text actions turn a screenshot into copyable text on Windows 11. Snip the statement rows, select Text actions, then Copy all text and paste into Excel. Recognition runs on your own PC. Quick redact can black out email addresses and phone numbers in the image, but you must hide account numbers yourself.
What are Snipping Tool text actions in Windows 11?
Text actions is a button in the Windows 11 Snipping Tool that runs OCR on a snip you have just taken. OCR, or optical character recognition, reads the letters in an image and turns them into text you can select. Microsoft's Snipping Tool guide says all text recognition is performed locally on your device.
Local recognition matters for a statement. The image and the text never leave your computer during the capture, unlike a free online OCR site, where you upload the file. Before you paste the result into any other tool, check how that tool treats your data. Whether AI converters train on your files shows which clauses in the terms to read.
What you get from the button
Microsoft's guide lists three choices once Text actions is on: select and copy specific text, Copy all text, or Quick redact, which hides email addresses and phone numbers in the snip. The Windows 10 instructions on the same page do not mention text actions, so this is a Windows 11 feature.
Snipping Tool capture steps for one statement page
Capturing one statement page takes six steps: open the page, zoom in, snip the rows, turn on Text actions, copy, and paste. Checking each amount takes as long as the capture itself. A long statement means repeating the steps page by page.
- Open the statement in any viewer and zoom so the transaction text is large and crisp.
- Open Snipping Tool, choose rectangle mode and start a new snip. If you use Windows logo key + Shift + S instead, click the notification afterwards to open the snip in Snipping Tool.
- Drag around the transaction rows only. Leave out the logo, the address block and the page footer.
- In the Snipping Tool window, select Text actions.
- Select Copy all text, or highlight just the rows you need and copy them.
- Click cell A1 of a blank Excel sheet and press Ctrl+V.
Sharp images read better
Small or blurry text causes misreads. Zoom the viewer to 150 percent or more before you snip. A phone photo of a paper statement works, but flatten the page and shoot straight on, in good light.
Pasting Snipping Tool text into Excel rows
Text copied from a snip pastes into Excel as one row per printed line, all in column A. The date, description and amounts sit together in each cell, separated by spaces. Split them into columns, then check each amount against the image before you total anything.
Two ways to split:
- Flash Fill. Type the date from A1 into B1 by hand and press Ctrl+E. Excel fills the rest of the column by pattern. Repeat for description, amount and balance.
- Text to Columns. Data, Text to Columns, Delimited, Space. This splits every word into its own column, so you then rejoin the description words. It lines up only when every description has the same number of words; otherwise the amounts land in different columns, and Flash Fill is the safer choice.
Checks before you trust the paste
Compare the row count in Excel with the rows in the snip. Look for O in place of 0 and S in place of 5 in the amounts. Then add up the amounts with their signs, starting from the opening balance, and compare with the closing balance on the statement. A mismatch points to a misread digit or a lost minus sign.
Does Snipping Tool Quick redact hide account numbers?
No. Snipping Tool Quick redact covers email addresses and phone numbers in the snip, and Microsoft's guide names no other kind of data. Account numbers, card numbers, your name, your address and the merchant lines stay visible. Hide those yourself with the pen or highlighter before you share the image.
Here is what Quick redact covers on a typical statement snip, based on Microsoft's description:
| Detail on the statement | Hidden by Quick redact? | What to do |
|---|---|---|
| Email address | Yes | Check the result |
| Phone number, such as the bank's helpline | Yes | Check the result |
| Account or card number | No | Draw over it with the pen tool |
| Your name and street address | No | Crop it out or draw over it |
| Transaction descriptions | No | Crop to the rows the recipient needs |
| Balances and amounts | No | Leave them if they are the point of sharing |
Redact the image, not just the text
Quick redact changes the image you share. It does not change text you already copied. If you are sending the pasted rows instead, delete the sensitive cells in Excel. A shape drawn over a cell does not remove the value under it.
When Snipping Tool capture stops being worth the time
Snipping Tool capture stops being worth the time once a statement passes a few pages, or when you need the same statement every month. Each snip is a separate capture, paste, split and check. That suits one page or a handful of charges, and it gets slow over a twelve-month stack.
Better options by case:
- A pile of paper statements. An office copier can often scan straight to a file. Copier scan to Excel covers getting the most from the machine you already have.
- Many scanned pages. Tesseract OCR for bank statements is free and handles whole files, at the price of a fiddly setup.
- Text PDFs from online banking. Open source converters such as Tabula read the text layer directly, with no OCR misreads.
For a text PDF you would rather not split by hand at all, CheapBankConvert is getting ready to open. Early prices start at $2.99 for a statement up to 10 pages, and the first 2 pages preview free.