How to change an image in Google sheet data with OCR in Google Drive

Copying data from an image in the Google sheet file can be manually taking time and can increase the chances of typos. Fortunately, you can remove the information in your spreadsheet in some simple stages using the optical character recognition (OCR) tool in Google Drive. This way.

Points to note before starting

Before you start converting the text into data in your image Google sheetHere are some indications that will help to ensure that the process works expected:

• Make sure your image is clear: The better the quality of the picture, the better conversion. If your image is a screenshot, it should not be too much problem. However, if you capture the picture with your phone or camera, make sure it is well lit and not unclear from the shade. In addition, try your best to keep a stable hand to avoid the explosion.
• Use images with high-resolution text: The data in the picture should be at least 10px high.
• Make sure the image is the correct format: This process works with JPEG, PNG, TIFF and GIF files. If your image is not one of these image file formats, be sure to convert it first.
• Do not use extremely large images: Google recommends that the file size is 2MB or small.
• Standard fonts work best: If the text or numerical data in the image is in an unusual font, the conversion could not work and at the same time you expected.
• Formatting cannot be preserved: After completion of the conversion, be prepared to make manual changes in data formatting.
• You need a Google account: To take advantage of this OCR conversion equipment, you must be Signed in your Google account,

Step 1: Upload the image to Google Drive

Suppose you have downloaded this image – a screenshot of a PDF with various names and addresses in the PNG format – and you want to remove and edit data in Google Sheets.

Because the file is a PNG image, you simply cannot choose the text and copy, because there is no “actual text” data in the file – only image data. If you copy the data from a website, you can also face the same landscape – if it was uploaded as an image, there will be no real text to simply copy and paste in Google sheet.

Instead, upload the image to Google Drive. Before you do this, make sure the image is the right way.

Connected

How to rotate images on Windows 11

Rotate photos using the underlying app like file explorer, photo and paint.

Then, Sign in Google DriveAnd click and draw the file relevant Google Drive Folder.

Alternatively, click “New” in the top-left corner, select “Upload the file upload”, and explore the image and upload the image you want to convert.

Step 2: Open the image in Google Docs

Now that your image is uploaded to Google Drive, it is time to kick the conversion process in action. To do this, right-click the file, hover on “Open with,” and choose “Google Docs”. Yes, you eventually want the data to be in the Google sheet, but it is an essential step to take it first.

At this point, Google Docs opens in a new tab, which has the original image on top of the document and the data drawn down.

Also, if you go back to the image Google Drive folder, you will see that the Google Docs file you created are saved with the same name at the same place.

Connected

I paid for Google’s drive storage. Here’s that i don’t regret it

The facility is priced at $ 2 in a month.

Step 3: Review data and make the necessary changes

While OCR is generally accurate, it depends on how data is placed in the original image, it is not always correct. Therefore, take some time to review the data in the Google Docs file you created.

In this example, the column header in the image is put on random positions in the list of data extracted, so I will remove them for now and when I edit data in Google Sheets, I will re -add them later.

In addition, towards the end of the list, the addresses of Spongebob, Superman and Sweeni Tod have been mixed, so I need to reorganize this information so that the data is easy to work in the next stage.

Step 4: Copy and paste the data in Google sheet

Now that the data is ordered correctly or organized, it is ready to move it to the Google sheet. To do this, select the data, right-click anywhere in the selected area, and click “Copy”.

If you want to include data in a new spreadsheet, right-click on the white location in the relevant Google Drive folder, and click “Google Sheet”.

On the other hand, if you already have a Google sheet file set up, find it and open it.

Next, right-click on the cell where you want the first part of the copied data be pasted, hover on the “paste special,”, and click “value only”. Paste the data as values ​​only removes all formatting, including any line-spacing properties adopted automatically by Google Docs, so that you can work with a clean set of data.

Step 5: Data Tette

The final stage in image-to-deta conversion is to format the data in the Google sheet, so that it appears and behaves in the same way how you want it.

In my case, the list is set in a column, but I want the names, addresses and areas to be in three separate columns.

There are various ways to change the dataset accordingly, but in my case, I am going to use the transposose function, which transforms horizontal data into vertical data (and vice versa).

Connected

Convert a row in a column (or backward) in Google sheet

Do not switch your data manually!

If you want to do the same in Cell B2, then type:

=transpose(A1:A3)

And press Enter.

Now, because a new name appears in every third line, select cells B1 to B3, and double-click the Phil Handle to duplicate the transport formula in the related cells in column B.

Next, select all the new transported cells, press Ctrl+C to copy them, and only to paste the values ​​Ctrl+Shift+V press. This original distinguishes the data from the one-dimensional list, which means that you can remove it, it is safe in this knowledge that you will not be able to lose any of your transported data.

Now, after right-clicking the column on the header and selecting the “delete column”, you need to remove the blank rows. To do this, select all the columns with data, and in the data tab, hover on “data cleanup”, and click “Remove Duplicate”.

This will release a blank line, which you can manually remove by right-clicking any cell in that line, and click “Delete Ro”.

Finally, to resume the column header, right-click on any cell in row 1, click “Put 1 row above,”, and type the header as necessary.

Now you can convert data into a format-format Google Sheets Table by selecting all cells (including column headers), click on selection, and click “Convert to Table”.

Then, click on the down arrow in each column header and hover on the “Edit the column type”, to make sure that each field is assigned the right data type, and your converted data is ready for use in your Google Sheet spreadsheet!

Connected

Google Sheets vs. Microsoft Excel: Who should you use?

Yes, they are both spreadsheet platforms, but they are really very different.