<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Convert a grid inside a picture into Microsoft Excel

Published on
4,804 Points
1,804 Views
Last Modified:
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Many people have asked me if it is possible to export a grid picture into Excel.
 
There are multiple software titles that can help you do this task but I want to show you a free way to do so that is part of your Microsoft Office Suite already installed on your computer.

What you need to remember is that it may not work well if your grid picture has special characters or if the jpeg image quality is poor, but it is worth a try and did work for me multiple times.

Let’s say that you have below picture of a grid that you can use to do your own test.
Grid-picture-sample.jpg 
Now, you want to convert that above sample grid into Excel. To do so, I’m using Microsoft OneNote from Microsoft Office suite.

Step one will be to crop and copy one column at the time from the above picture into OneNote. We will start with the first column as below:
First_Column_from_grid.jpgThen, we open Microsoft OneNote and we paste the picture in a new page like below picture:
Paste_Picture_into_OneNote.jpgStep two will be to right click on the picture you just pasted inside OneNote and select from menu: “Copy Text from Picture”

copy_text_from_picture.jpgStep three, you open a new Excel file and sheet and select a cell where you want to put the values and then click paste. You should see below result:

Paste_in_Excel.jpg
Then, you can do the same thing again with all the other columns from your pictures.
 
At the end, you should have your grid into excel instead of a picture just like below result:

result.jpg
Remember that this is an alternate convertor and may not give the optimal result depending of the grid quality but is still worth a try and can give very good results sometimes. You may end up fixing some details but at least the biggest portion of the grid would be converted into Excel.

I need to also specify that it works great with jpeg format. If you have a picture on the web, and you decide to convert that picture into Excel, you can use Snipping Tool from Windows from your computer to capture each column of the grid.
Snipping_Tool.jpgUse Snipping Tool to capture screenshot
https://support.microsoft.com/en-us/help/13776/windows-use-snipping-tool-to-capture-screenshots
 
Hope this simple trick will help you.
0
Comment
Author:Wilder1626
0 Comments

Featured Post

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Join & Write a Comment

Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month