Worlds Colliding: Convert a Digital Photo into an Excel Spreadsheet

Spreadsheets and graphs on a desk

In an unlikely mash-up, Matt Parker of Think Maths offers a free tool that converts a digital photo of your choice into an Excel spreadsheet. According to the website, "digital photographs are actually just spreadsheets. When you take a photo, your camera measures the amount of red, green, and blue light hitting each pixel, ranks them on a scale of 0 to 255, and then records those values as a spreadsheet." Parker's website is able to extract said values from a digital photo, record the numeric values in worksheet cells, and then use Excel's Conditional Formatting feature to recreate the photograph.

 If you have Excel 2007 or later, you can try the technique yourself:

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.


Please login or register to join the discussion.

By L Keith Jordan
Jun 26th 2015 01:11

Quite interesting. This explains how digitally touching-up a photo really works. Just another specialized backend database with a specialized GUI viewer on the front end.

Thanks for sharing the tip.

Thanks (0)
By David Ringstrom
to evenanerd
Jun 26th 2015 01:11

Thanks for your feedback! It was a fun article to write.

Thanks (0)
Dec 19th 2015 07:11

Hey David,

I just found this article and it prompted me to play around with this idea a little bit. I'm sure an actual computer programmer could do this much more gracefully, but I put together a Matlab script/Excel macro that can convert any image file directly into an Excel image (with true color values in each cell, not the three-cell composites). Let me know if you're interested - it's a fun little distraction!

Thanks (0)