Convert printed tables into editable Excel files on your iPhone. Table OCR recognizes rows, columns, and numbers from financial statements, invoices, and inventory lists, then exports a clean XLSX you can open in Excel, Numbers, or Google Sheets. XLSX export is a Premium feature.
Retyping a printed table into a spreadsheet is one of the most tedious office chores. A two-page financial statement can take half an hour to transcribe, and a single misread digit can corrupt every formula that depends on it. Scan to Excel turns this manual job into a quick capture and review.
Point your iPhone camera at a printed table, capture the page, and ScanLens analyzes the image to find the grid structure. It detects rows, separates columns, and reads the text or number inside each cell. The result is a structured spreadsheet you can review, correct, and export as a standard XLSX file.
The exported file opens in Microsoft Excel, Apple Numbers, Google Sheets, LibreOffice, and any other application that supports the Excel format. You can apply formulas, sort data, and build charts in seconds instead of starting from a blank grid.
XLSX export is part of the ScanLens Premium tier. The free tier lets you scan documents and export to PDF, JPG, PNG, and TXT, so you can capture and preview a table before deciding whether the spreadsheet workflow is worth subscribing for.
Open ScanLens and take a photo of your printed table, or import an existing image or PDF page. Hold the camera steady and parallel to the page so the grid is not skewed. Good lighting and a flat surface make a noticeable difference.
ScanLens automatically detects the page edges, crops to the document, and corrects perspective so the table looks like a flat scan. This pre-processing step is what makes the next stage reliable, because grid detection works much better on a deskewed image.
The app analyzes the deskewed image to find horizontal and vertical lines, repeating gaps, and aligned text baselines. From these signals it builds a grid that approximates the structure of your table—how many rows, how many columns, and where each cell starts and ends.
OCR runs on every detected cell to extract its content. Numbers are recognized as numbers where possible, so totals and currency values land in the right format. Text labels keep their original characters in supported languages.
Before exporting, you see the recognized table in a structured preview. Fix anything OCR got wrong, then tap export and choose XLSX. The file is saved to your document library and can be shared to Files, email, or any other app on your iPhone.
Table OCR is much more sensitive to image quality than plain text recognition. A few simple habits make the difference between a usable spreadsheet and a frustrating cleanup job.
Avoid shadows from your hand or phone, and skip mixed lighting where part of the page is in sun and part in shade. Diffuse daylight or a desk lamp positioned to the side works well. Even lighting helps the app find grid lines and read small digits.
Curled receipts, folded statements, and bound book pages create perspective distortion that confuses grid detection. Flatten the page against a hard surface, or hold the corners down. For thick reports, lay the page open and press the spine flat.
Capture the entire table in one shot with a small margin around it. Cropping a column off the edge means that data is gone, and stitching multiple captures into one spreadsheet is harder than getting it right the first time.
Try to hold your iPhone parallel to the page, not tilted. Even with auto-deskew, an extreme angle stretches the grid and can make column boundaries ambiguous. A bird's-eye view from directly above gives the cleanest result.
OCR can confuse 0 with O, 1 with l, 5 with S, and 8 with B in some fonts. For any table where numbers matter—and that is most of them—scan, review every cell that drives a formula, and only then export. This habit takes a minute and prevents silent errors.
Quarterly reports, balance sheets, income statements, and cash flow statements arrive as PDFs or printed pages. Scan them once, get the numbers into Excel, and start your own analysis—ratios, trends, year-over-year comparisons—without retyping a single figure.
Vendor invoices often arrive on paper or as image PDFs. Scan the line items table to capture descriptions, quantities, unit prices, and totals into a spreadsheet. From there, reconcile against purchase orders or feed the data into your accounting workflow.
Stock counts, parts catalogs, and warehouse audits are still done on paper in many businesses. Capture the printed list, export to XLSX, and turn a clipboard tally into a sortable, filterable spreadsheet ready for inventory software.
Long restaurant tabs, grocery receipts for expense reports, and supply runs with dozens of items become an Excel-friendly list. Sum the totals, categorize items, or split a shared bill without typing each line by hand.
Sometimes the only copy of a spreadsheet is a printout—an old report whose original file is lost, a handout from a meeting, or a page faxed from a partner. Scan to Excel reconstructs an editable version so the data is usable again instead of stuck on paper.
Table OCR is genuinely useful for clean printed tables, and we want to be straightforward about where it struggles. Knowing the limitations up front saves you time and sets realistic expectations.
Printed tables with clear horizontal and vertical lines, consistent fonts, plain backgrounds, and good contrast. Financial reports, invoices, price lists, and bank statements typically fall into this category. Standard column layouts without merged cells convert reliably when the scan quality is good.
Handwritten tables are hard. Handwriting recognition is a different problem from printed-text OCR, and grid detection often fails when row lines are drawn by hand. If your source is a handwritten ledger, expect to do meaningful manual cleanup, or treat the scan as a reference image rather than a clean export.
Tables with merged headers spanning multiple columns, nested sub-tables, or irregular cell sizes confuse grid detection. The app does its best, but you may need to fix the structure in the preview or in Excel after export.
Faxed pages, photocopies of photocopies, faded thermal receipts, and low-resolution screenshots all reduce accuracy. If the original is hard for a human to read at a glance, OCR will make mistakes too. Try to start from the cleanest source available.
Magazine-style tables with background images, colored bars behind cells, or unusual fonts are designed for visual impact rather than data capture. They often need manual structuring after scanning.
For everything in the "works well" category, scan to Excel saves real time. For the harder cases, treat OCR as a head start rather than a finished result, and plan to spend a few minutes reviewing and correcting before you trust the numbers.
ScanLens uses on-device computer vision to detect grid lines and column boundaries in your scanned image, then runs OCR on each cell to extract its text or numeric content. The recognized rows and columns are assembled into a structured spreadsheet that exports as an XLSX file you can open in Excel, Numbers, or Google Sheets. All processing happens on your iPhone, so the source image and the resulting data never leave the device.
Clean, printed tables with clear borders, consistent column widths, and good lighting produce the best results. Financial statements, printed invoices, inventory lists, price sheets, and bank statements typically convert accurately. Handwritten tables, low-contrast scans, and tables with merged or nested cells are more challenging and may need manual cleanup after recognition.
Yes. After table OCR completes, you can review the recognized rows and columns, fix any cells where OCR misread a digit or letter, and adjust the structure before exporting. This human-in-the-loop step is important for tables with critical numbers like financial reports, where a single misread character can throw off downstream formulas.
ScanLens preserves the row and column structure of your table along with the text and numbers in each cell. Visual formatting like font colors, cell shading, borders, and merged cells is not transferred. The exported XLSX contains the data in a clean grid that you can format yourself in Excel or Numbers using your own styles.
XLSX export is a Premium feature. The free tier of ScanLens supports exporting scans as PDF, JPG, PNG, and TXT, but Excel spreadsheet export with table OCR requires a Premium subscription. Scanning and table preview are available to all users so you can test the recognition on your own documents before deciding to subscribe.
Download ScanLens and try table scanning on your own documents. Capture and preview are free, and Premium unlocks XLSX export with table OCR.