Recover editable figures from a paper financial table
At a glance
Microsoft documents using Excel's image recognition to turn photographed table data into editable cells. This workflow is listed under Money & Bills, Paperwork, Spreadsheets.
- Agents / tools
- Excel, Data from Picture, Phone camera
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Use Excel for Microsoft 365 and photograph the printed table straight on, in focus. Crop to the data you want to import and transfer the image to the computer. Microsoft's examples include old paper tax-return tables. 2) In Excel for Windows, select Data > From Picture > Picture From File and choose the photograph. A clipboard screenshot can instead use Picture From Clipboard. 3) Let Excel analyze the image, then review its proposed cell values and correct recognition errors. 4) Select Insert Data to place the reviewed table in the worksheet; keep that editable table for your records.
Worth knowing
On Windows, the feature requires Windows 11 or Windows 10 version 1903 or later with Edge WebView2 Runtime. Microsoft's supported character-set list does not include Chinese or Japanese.