The exact answer to adding data from a paper to Excel, based on the reference, is to use the Get Data From Picture feature in Excel.
The most straightforward method to copy or import data from print, paper, images, or video into Excel is by utilizing the built-in feature designed for this purpose.
According to the reference, you can simply press the new Get Data From Picture button on the Data ribbon. This powerful tool allows Excel to recognize text and numbers within an image of your paper document and convert them into editable data.
Using the Get Data From Picture Feature
Here’s a breakdown of the process:
- Prepare your paper document: Ensure the paper is clear and the text is legible. A good scan or high-quality photograph will yield better results.
- Open Microsoft Excel: Launch the Excel application.
- Navigate to the Data Ribbon: Click on the Data tab located in the top menu bar.
- Find the Get Data From Picture Button: Look for the Get Data From Picture button within the Data ribbon.
- Note: As stated in the reference, If you don't have this button in your copy of Excel, you will need to upgrade to the latest version of Microsoft 365.
- Select your Image: Click the button and select the image file (scan or photo) of your paper document from your computer.
- Excel Analyzes the Image: Excel will process the image, attempting to identify tables and data.
- Review and Edit Data: A pane will open showing the recognized data alongside the image. You can review the data for accuracy and make any necessary corrections before inserting it into your spreadsheet.
- Insert Data: Once you are satisfied with the preview, click the "Insert Data" button to place the extracted information into your active worksheet.
This method significantly reduces the time and effort required compared to manual data entry. While the feature is quite accurate, always review the imported data to catch any potential errors in recognition, especially with complex layouts or handwritten notes.
