How to transfer a paper table to Excel using a camera

Last update: 23/01/2026
Author Isaac
  • Excel for mobile allows you to convert paper tables into editable tables using a photo taken with your camera.
  • The function uses OCR and Artificial Intelligence to detect rows, columns, and cell content.
  • It is crucial to prepare the document well and review any questionable cells before inserting the table into the workbook.
  • The system saves a lot of time in the digitization of printed data for analysis and daily work.

Digitize a paper table to Excel using your mobile phone's camera

Mobile phones have become digital Swiss Army knives: we take photos, pay bills, work, organize ourselves… and now we can also convert a paper table into an Excel spreadsheet simply by taking a picture of it . This feature, which leverages the power of the camera and Microsoft's artificial intelligence, saves a huge amount of time compared to manual data entry.

If you frequently work with printed lists, schedules, invoices, or reports and then need to transfer them to Excel, this tool will be incredibly useful. Essentially, Excel uses your phone's camera as a smart scanner that detects rows and columns, recognizes text, and transforms it into an editable table within your spreadsheet, on both Android and iOS.

What is the function of transferring a paper table to Excel using a camera?

Microsoft has added a feature to Excel for mobile called something like " Insert data from image ," which allows you to capture any table you have on paper or on a screen with your camera and convert it into a fully editable Excel spreadsheet. The system relies on Office Lens technology and Microsoft's optical character recognition algorithms.

This feature uses several technological layers: on the one hand, optical character recognition (OCR) to read the text, and on the other hand, image comprehension techniques and machine learning models that identify where cells begin and end, how columns are structured, and what shape the original table has.

The interesting thing is that all of this is done without leaving Excel: there's no need to open another application or use an external scanner . You open a workbook, tap the camera icon, take the picture, and wait a few seconds for the data to be processed. Then, you check for any errors and, when you're satisfied, insert the table into the worksheet.

Furthermore, this feature is available on Android and iOS and supports more than twenty languages , so you can work with documents in different environments. Microsoft has also integrated it into other tools such as Word ( PDF Reflow feature ), Office Lens, and Seeing AI, but it truly shines in Excel because it's specifically designed for tabular data.

Prerequisites: What you need before using the camera with Excel

Before you start photographing any document, it's a good idea to review a few basic points. To begin, you need to have the latest version of Microsoft Excel installed on your mobile device . On Android, the feature initially arrived in a specific build (for example, 16.0.11629.20124 or higher) and has since been rolled out gradually to more devices.

On Android, you can use Excel in two ways: by installing the free Microsoft Excel: Spreadsheets app from Google Play, or through a Microsoft 365 subscription , which unlocks additional features and allows you to use the entire Office suite on Windows , macOS, Android, and iOS. The free app is more limited, but for most people, it's sufficient to take advantage of this image data capture feature.

With Microsoft 365, in addition to the full versions of Excel, Word, PowerPoint, OneNote, Outlook, and Skype, you get 1 TB of OneDrive storage for syncing documents in the cloud . For those who work daily with Office files and need collaboration and access from anywhere, this paid option might be worthwhile; for occasional use, the free application is usually sufficient.

It's important to note that the feature hasn't rolled out simultaneously to all phones. On some models, the option to insert data from an image appears, while on others it takes longer to appear , even with the app updated. For example, it's been available on some Pixel and OnePlus phones, while on certain Samsung and other manufacturers it's taken longer to activate.

  How to force the emptying of the print buffer from the command prompt in Windows

In addition to having the correct version of the app, you'll need to grant certain permissions. The first time you use the tool, Excel will ask for permission to send the image to Microsoft servers for online processing , and also to access your device's camera to take photos or record video. Without these permissions, the feature cannot function.

Ideal table conditions: how to prepare the paper document

For recognition to work properly, it's not enough to just point and shoot. It's essential that the document you're scanning meets certain minimum requirements. First, the data must be typed and perfectly printed ; handwritten tables, especially if the writing is irregular, are much harder to read, and the system can make numerous errors or simply fail to recognize many fields.

It's also important that the document structure is actually a table, with its rows and columns aligned . If the content is jumbled, with text out of place or combining various unusual formatting, Excel will have more difficulty interpreting where each cell begins and ends and what belongs to which column.

Ideally, the paper should be flat on a stable surface, free of strong shadows or surrounding objects that might interfere with the capture. The cleaner and clearer the image, and the better the photography modes , the fewer corrections you'll need to make later on questionable cells . Although the AI ​​does a fairly good job, it still relies on the input (the photo) being of sufficient quality.

Finally, the font doesn't have to be huge, but it should be legible in a photo taken from a normal distance. If the text is too small or blurry, the OCR might confuse numbers and letters or skip characters . Sometimes, simply moving the camera a little closer or improving the lighting can make all the difference.

Step by step: how to digitize a paper table with Excel

Once you have the app set up and the document ready, the practical process is quite simple, although it's best to follow the steps carefully to achieve a clean result. It all starts by opening Excel on your mobile device and creating a new workbook or opening an existing one where you want to insert the converted table.

At the bottom of the Excel mobile interface, you'll see a very recognizable icon: a table with a small camera in front of it. That's the button for importing tables from an image directly into the worksheet . It's usually visible among the default options; if you don't see it, check the Insert tab or see if your version of the app already supports this feature.

The first time you tap that icon, a notification will appear explaining that the image will be sent to Microsoft servers for processing by their recognition systems. You will need to accept this online processing and also authorize access to your device's camera . These are standard permission dialogs on Android and iOS, similar to those requested by other apps that use the camera.

Once you've granted all the permissions, you'll enter camera mode within Excel. The app automatically detects the edges of the paper or table on the screen and marks the area to be captured in the preview . You can slightly move your phone until the table is centered and properly framed; the app attempts to adjust the cropping, but you have some leeway to help it.

It's advisable to pause for a moment to ensure the image is sharp: if the focus is blurry, some numbers or letters are more likely to be misinterpreted. Once you're satisfied, press the button to take the photo , and Excel will move to the screen where you can adjust the capture before converting it.

Image editing: cropping, straightening, and adjusting

After taking the photo, Excel displays a preview of the image with some basic tools in the upper right corner. From there, you can crop the edges of the photo to focus only on the table or rotate it if it's taken crookedly or at an angle. This is very useful when you take the photo in a hurry and the sheet is slightly tilted.

  How to change image compression quality in Word

The system is quite similar to what Office Lens offers: you can drag the corners of the cropped area to adjust them to the very edge of the table, eliminating background areas that don't contribute anything. The more precise this cropping, the easier it is for the algorithm to understand where the cells are and avoid confusion with external elements.

If you took the photo at an angle or the sheet is rotated, simply use the rotate option until it's in a comfortable reading position. It doesn't need to be perfectly aligned, but straight enough so the row and column lines are clearly visible . Excel will then take care of straightening things internally.

Once you're satisfied with the cropping and orientation, tap the OK button at the bottom of the screen. Excel will then begin processing the image, displaying a message such as " Converting image to data ." This process typically takes only a few seconds, though it may vary depending on your internet connection and the complexity of your spreadsheet.

When finished, you'll go directly to the data preview screen , which is where you'll actually see the result of the conversion and can decide what to correct before inserting the table into your Excel workbook.

Data review: correct questionable cells before inserting

In the preview, Excel displays the table it has reconstructed from the image. The overall structure is usually preserved quite well: the columns and rows generally appear in their correct positions , and most of the cells are recognized correctly, provided the photo is clear and the text is well printed.

Cells that the system is unsure about are marked with a red background or a visual indicator. These are the cells where Excel isn't sure it has correctly interpreted the content, and you should pay closer attention. You can tap any of these cells directly to edit its content in a text field that appears at the top of the screen.

If you don't want to go through them one by one manually, you can use the Review button that Excel offers on this same screen. When you tap it, the app automatically takes you through all the questionable cells, one by one , highlighting the area corresponding to the cell you're reviewing in the original image, so you can quickly check if the value matches or not.

In each selected cell, you typically have two basic options: ignore or edit. If you believe the data is correct as read by the system, you can click Ignore to remove the warning and leave the cell as is . If you see an error (a changed number, a misread character, an extra space, etc.), you can use Edit, enter the correct value, and then mark it as done.

Not only can you edit the cells highlighted in red: you can also modify any unselected cell. Simply tap on it, edit the text in the field that appears above, and tap the Done button in the upper corner to confirm. All of this is done before inserting the final result into the final spreadsheet.

Insert the table into the Excel workbook and work with it.

Once you've finished reviewing the cells you're interested in (all the red ones or just some), the next step is to click the Insert button in the upper right corner of the preview. Excel will then insert the converted table into the workbook you originally had open , filling the corresponding cells in the active sheet.

  Complete Shadow Copy Tutorial in Windows

If you try to insert the table without checking the potentially incorrect cells, Excel usually displays an extra warning asking if you'd prefer to review the cells first or continue and insert the table anyway . This small confirmation saves you from accidentally entering incorrect data, but if you're in a hurry, you can accept and insert the table as is.

Once inside the workbook, the table becomes a native Excel table: you can apply formatting, create charts, use filters, formulas , pivot tables, and any other standard tool. The data is no longer an image, but real cells with editable and calculable values , just as if you had typed them one by one by hand.

This workflow is especially useful when you have very long lists or repetitive structures (for example, accounting records, inventories, timesheets, or sales reports). Instead of spending time manually entering rows, you let the system capture most of the data, and you only need to refine the few cells that have been flagged as questionable.

The final result will depend on the quality of the original and the cleanliness of the photo, but in general the experience is quite satisfactory and the volume of corrections is usually very reasonable for the time that the process saves.

Practical uses and tips to get the most out of them

The ability to transfer a paper spreadsheet to Excel using a camera opens up many possibilities in everyday life. For example, you can use it to quickly digitize schedules, printed invoices, attendance lists, menus, inventories, or shift schedules, and then calculate the mean, mode, and median of the data without having to recreate the document from scratch on your computer.

It's also perfectly possible to point the camera at a screen instead of a sheet of paper: if someone shows you a table in a presentation, on a monitor, or even on another tablet, you can capture it directly from the screen and convert it to data . Obviously, the less glare and the sharper the screen, the better the recognition will work.

In business environments, this tool is very convenient for those who work with documents that are still routinely printed: delivery notes, production summaries, standard forms, etc. Instead of waiting for someone to manually scan them, the user can photograph the paper and have the data ready for analysis or reports in a matter of minutes.

Although the function does most of the work for you, it's a good idea to adopt a few habits: try to maintain even lighting, avoid harsh shadows on the page, and center the table within the frame without any extraneous elements around it. This way, the algorithm will have less visual noise that could confuse cell detection.

It's also a good idea to review the first conversion in more detail when you have recurring documents (for example, always using the same printed report template). Once you've verified that Excel correctly recognizes that specific structure, subsequent conversions of similar documents will require very few corrections , because the system is optimized for tables with consistent designs.

Using your phone's camera to import data into Excel changes the way you work with paper documents: it transforms a tedious and repetitive task into a quick process where you only need to tweak minor errors. Combined with cloud synchronization and advanced Office features, this tool turns any smartphone into a powerful ally for those who work daily with spreadsheets and large volumes of data.

How to merge and separate cells in Excel
Related articles:
What is an Excel PivotChart and how to get the most out of it
Isaac

Isaac

Passionate writer about the world of bytes and technology in general. I love sharing my knowledge through writing, and that's what I'll do on this blog, show you all the most interesting things about gadgets, software, hardware, tech trends, and more. My goal is to help you navigate the digital world in a simple and entertaining way.