Using The Excel App On Your Smartphone Microsoft has a cool feature in the Excel Smartphone app that allows you to convert picture to an Excel table. It is called ' Insert Data From Picture '. It lets you take a picture of the printed table or data and convert data into an editable Excel spreadsheet. To make sure each image is inside its own cell, you can select the images – Shortcut key Control + A selects all images (make sure you click on an image first before you use the shortcut key, otherwise you select all the cells instead). Now use the options inside picture tools to align the images properly.
- Using Online OCR Service. There are tons of free and paid online services that let you use OCR.
- Image to Excel After performing OCR, click the 'To Excel' button in the 'Convert' tab to start the image to excel conversion process. After that, you will get the converted excel file in the output folder. Convert Image to Excel with PDF Converter Pro.
- Convert PDF Image to Excel with PDF Converter Pro. To convert a PDF image to Excel, you can also use PDF Converter Pro. As one of the best PDF image to Excel converters, it is designed for converting PDF to any other format using the OCR function. Click below for the PDF image to excel converter free download.
Photo To Excel Table
Q. In Excel, is it possible to insert an image into a cell (i.e., not floating atop the cell)?
A. Yes, you can insert an image into an Excel cell as follows. Paste an image into Excel, then resize the image and drag and drop it on top of a cell, as pictured below. Next, right-click the image and select Format Picture from the pop-up menu and, in the resulting dialog box, select the Size & Properties tab, and under the Properties section, check the radio button labeled Move and size with cells, then click OK.
Thereafter, the image will remain located in that cell, even if the cell's position changes when other rows or cells are inserted, deleted, or moved. In addition, the image will grow or shrink as the cell's width or height is adjusted. This solution might be used to insert employee photos into an Excel-based organization chart, or to insert images of inventory items onto your worksheet. As an example, presented below is a worksheet of how a canine adoption agency might maintain a list of dogs available for adoption. In this worksheet, Champ's image would remain on the same row as his adjacent information, even if the data are sorted or the rows are moved.
Photoshop 2012 version. You can download this example Excel file at carltoncollins.com/dogs.xlsx.
About the author
J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.
Submit a question
Photo To Excel Table
Q. In Excel, is it possible to insert an image into a cell (i.e., not floating atop the cell)?
A. Yes, you can insert an image into an Excel cell as follows. Paste an image into Excel, then resize the image and drag and drop it on top of a cell, as pictured below. Next, right-click the image and select Format Picture from the pop-up menu and, in the resulting dialog box, select the Size & Properties tab, and under the Properties section, check the radio button labeled Move and size with cells, then click OK.
Thereafter, the image will remain located in that cell, even if the cell's position changes when other rows or cells are inserted, deleted, or moved. In addition, the image will grow or shrink as the cell's width or height is adjusted. This solution might be used to insert employee photos into an Excel-based organization chart, or to insert images of inventory items onto your worksheet. As an example, presented below is a worksheet of how a canine adoption agency might maintain a list of dogs available for adoption. In this worksheet, Champ's image would remain on the same row as his adjacent information, even if the data are sorted or the rows are moved.
Photoshop 2012 version. You can download this example Excel file at carltoncollins.com/dogs.xlsx.
About the author
J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.
Submit a question
Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.
Let's review basic picture links in Excel and then explore alternative solutions to picture link limitations. I've also included a fun Dashboard to help Oz du Soleil reassess his wardrobe!
What is a Picture Link?
- it gives you a live view of a cell(s) from any sheet
- changing the contents of the cell(s) changes the picture link
- picture links are commonly used in dashboards
How to create a Picture Link?
- copy a cell (or range of cells)
- on the Excel ribbon select ‘Home'
- under ‘Paste' select tiny down arrow
- select bottom right icon to paste as a picture link
Excel File
All in one messenger chrome app. Download my Excel file. It has basic and advanced picture link examples.
Picture Link Limitations & Solutions
(get my Excel file for more detailed instructions and examples)
Picture Link to Excel Table
You can't directly paste a Table as a picture link. Alternative solution steps:
- Create name range using formula: =INDIRECT('Table1″&'[#All]')
- Copy & Paste the Table as a picture. Select it.
- In formula bar type '=' followed by your named range. Press enter.
Picture Link to Excel Chart
- Position your chart to fit within cell E15 (increase row height & col width)
- Add this formula in cell I13 ='PictureLinkToChart'&'!$E$15″
- Create named range using formula=INDIRECT(PictureLinkToChart!$I$13)
- Copy & Paste the chart as a picture. Select it.
- In formula bar type '=' followed by the named range. Press enter.
Slicer selects Tables & Charts for Picture Links
So far your picture link refers to the same table or chart. Wouldn't it be nice to select from several tables or charts for your picture link?
Photo To Excel
Instead of hard-coding the formula reference to a single table (or chart) we can use a slicer selection to link to a table or chart in any workbook!
Wardrobe Audit
Oz du Soleil (Excel lover and fashion icon)
Oz wants to audit his wardrobe in Excel. Oz has separate sheets for pants, hats, socks and ties.
The dashboard pulls text, a chart and a table from selected sheet using a slicer. You learn more about linked objects and Oz reassesses his wardrobe!
My Excel file has blue colored sheets for Oz's dashboard, pants, hats, socks and ties. Audit these blue sheets to learn more!
About Me
I've worked as a Data Analyst since 2001. Technical Administrator, databases, some programming (VBA & T-SQL) and of course tons of Microsoft Excel !!!
Photo To Excel Sheet
Check out myRecommended Excel Training and my YouTube channel(only Excel videos!)
