Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Turn any image into an Excel file?

Ever think about turning your face or that picture of your neighbor’s dog into an Excel file? Well, even if you haven’t, you now can! 

Years ago I created this little utility that can turn any image into an Excel file. Click here to download it for yourself.

How do we use it?

Ok, here are the instructions. 

  1. Identify the image you want to turn into an Excel file. 
  2. Save it as a bitmap. My utility will work with 24-bit and 256 color bitmap types. If you want to know how to save it as a bitmap, you can just use mspaint as I’ve done in the video. 
  3. Open my bitmap_to_excel utilty and go to the Instructions tab. Click on the Click this Shape to Load in your file into Excel button…
  4. Select the file you’ve just made. Click Open. (see the image below)
  5. Sit back, relax and enjoy the your new spreadsheet. 

2019 06 25 11 20 44 bitmap to excel 2019

Ok, but, how’d you build this? 

That’s a great question, but it’s been many years. The best I can say is that it’s all about reading in the the bitmap specification using the correct size bits and bytes. If you want to take it apart yourself, please, have at it. 

I’ve included some resources for you to get started! 

Helpful Bitmap Resources

But why’d you build this? 

I can’t really remember, honestly. I feel like I had a good reason for it. But as with most things I build in Excel, it’s because nobody had really done it before. 

Would you ever use this?

After I built this bitmap to Excel program, I thought I’d have tons of uses. But I haven’t really come up with anything except as a fun way to surprise friends. 

But maybe you’re different! Leave a comment here, on YouTube, and in our Facebook group on what you might use it for!

Get the Download File!

Click here to get the download file


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
    But the content of the page explains turning a bitmap into an Excel spreadsheet, that is the other way around. Or did I miss something?

    • I get what you’re saying. I think at the level of what a bitmap is. I see it as storage pattern. And I guess I thought to myself where each cell becomes a pixel representing a certain color in a color range would make a bitmap.

      But on a second… you’re absolutely right. Bitmap is a storage pattern. All images are made up of pixels at their core so my original thought can’t be right.

      Admittedly, I’m probably not going to change the title 🙂 if only because I usually don’t correct stuff that’s been out there for a while. One correction is never enough and I end up knee deep in it.

      Thanks again though. I think you make a valid point.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free Power User Quick Guide

    Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

    With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.