In this tutorial, we will show you exactly how to insert data from a picture into Google Sheets in just a few steps. Simply follow the steps below.
Data can be extracted from images and inserted into Google Sheets using two effective methods: the 'OCR Recognition for Docs, Spreadsheets, PDF' extension and the OCR features of Microsoft Excel 365. We will discuss how to use each method in the following sections.
Here’s how to extract data from an image using an OCR extension on Google Sheets:
Create a new blank spreadsheet by clicking “+.” This can be located at the Google Sheets homepage.
In the top menu bar, find and click on "Extensions." This is located next to "Tools" and will allow you to manage add-ons for Google Sheets.
Click on "Add-ons" under the "Extensions" menu, then select "Get add-ons." In the search bar of the Google Workspace Marketplace.
Type "OCR Recognition for Docs, Spreadsheets, PDF" and press enter to find the add-on.
Locate "OCR Recognition for Docs, Spreadsheets, PDF" in the search results and click on it.
Click on "Install" to start the installation process.
Choose an account you want to use.
Tap on "Continue" to proceed.
Click "Allow" to let the add-on access your Google account.
With the add-on installed, go to the "Extensions" menu.
Hover over "OCR Recognition for Docs, Spreadsheets, PDF."
Upload the image file that contains the data you want to extract into your Google Sheet by clicking “Upload files.”
Click on "Choose Files" to select your files.
Click on the file you want to use, then click "Open."
The add-on will process the image and extract the data, placing it into your Google Sheet. Review the extracted data for accuracy and make any necessary corrections.
Follow the steps below to extract data from a picture using Microsoft Excel 365’s OCR features on Google Sheets.
Once Excel is open, click "New" to create a new workbook. This will open on a new tab. You can also open an existing workbook if needed.
Click on the "Data" tab. Choose to upload an image or use a screenshot. Excel will scan the image and extract the data into a table.
After clicking "Data," select the "Data from Picture" option.
Select the files you want to use, then click "Open."
From the sidebar that will appear, click on "Insert Data" to insert the extracted data to the spreadsheet.
Click and drag to highlight the cells containing the extracted information. Right-click the highlighted cells and choose "Copy," or use Ctrl + C (Windows) or Cmd + C (Mac) to copy the data.
In your browser, open Google Sheets and create a new sheet or open an existing one. Click "+" to open a new one.
Click into the first cell where you want to insert the copied data, then right-click and choose "Paste," or use Ctrl + V (Windows) or Cmd + V (Mac) to paste the data.
We hope that you now have a better understanding of inserting data from an image on Google Sheets. If you enjoyed this article, you might want to check our articles on how to import multiple CSV files into Google Sheets and how to merge multiple sheets into one in Google Sheets.
