Excel: Importing data from an image

Recently, I’ve been getting mail that contains data that I need to get off of the paper and into Excel. Typing the data into Excel is one option. But I figured there must be better ways.

In this video I show 2 ways to get data by taking a picture, then converting the text from the data into something that Excel can use. You’ll see:
– Save the image in Microsoft Word as a PDF
– Import the image into OneNote, then use Extract Text from Image.

NOTE: All methods involve some kind of clean-up. The trick is to figure out which method results in the least mess.

0:00 Intro
1:55 A comment about the Excel phone app
2:20 Import work schedule
4:37 Import workshop data
7:16 Import from a magazine page
8:35 Why not import PDF using Power Query?
9:10 Outro

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2