I found a reason to love Excel again!

Feb 04, 2022

I'm creating a course for the University of Chicago and needed data from an image in PowerPoint.  Not a big table, but I wasn't up for the tedious typing.

This was the rare time being lazy made me more efficient.

After some research, I discovered Excel's feature to import a data table image. 

WOWEE!

FYI, I'm on a Mac (as of June 2021, the feature wasn't available on Windows).

Start on the Data ribbon.  I prefer saving the image for easy editing.  A few seconds to process and a review pane opens on the right.

The highlighted boxes are where it thinks the conversion might not be accurate.  Click the Review button and it moves through each item on the original image so it's easier to compare.  It's work, but beats retyping.

In this example, the main problems were seeing "," as "." and missing "-". 

I expect better image resolution will have fewer issues.  More testing ahead.

 

From what I've seen, this has potential as an excellent solution for small data conversions and hope you can put it to use!  See the help page for more detail.

Have you come across any other tools like this?  Comment and let me know.

Best,
Lee
Rewriting How People See Data™

Frustrated By Low Dashboard Adoption?

Learn how to transform passive charts into action-oriented visuals.

Click And Get The Free eBoook