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.
- Identify the image you want to turn into an Excel file.
- 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.
- 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…
- Select the file you’ve just made. Click Open. (see the image below)
- Sit back, relax and enjoy the your new spreadsheet.
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
- Bitmap Header Types – https://docs.microsoft.com/en-us/windows/desktop/gdi/bitmap-header-types
- Wikipedia Bitmap File Format (I remember using this extensively) – https://en.wikipedia.org/wiki/BMP_file_format
- Creating a Bitmap image in VB 6.0 – https://rerickso.w3.uvm.edu/projects/vb_bmp/BMP.html
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!