How to Make Pixel Paintings with Google Spreadsheets
You have been using Google Sheets for budgeting and business but there’s another interesting use of spreadsheets - you can use them to create impressive pixel paintings in minutes.
The idea is simple. Each cell in the spreadsheet corresponds to a pixel in the painting. You find the color of the pixel and set that as the background color of the corresponding cell in the sheet. Now resize the cells in small perfect squares and your spreadsheet will resemble the original artwork.
If you would like to create your own spreadsheet art but don’t have the time to carefully paint every cell manually, here’s a simple workaround for you. You can take any photograph, vector art, GIF, or any other image and use Google Sheets to convert that bitmap image into spreadsheet art.
Here’s some artwork created with Google Spreadsheets.
It takes three easy steps to make pixel art with Google Sheets.
- Install Pixel Art for Google Sheets.
sheets.newin the browser to create a new Google Sheet. Go to Add-ons menu, choose Pixel Art and then select Open.
- Upload any image from your desktop, hit the Draw button and watch as your sheet magically transforms into beautiful art.
Check this Google Sheet for more examples.
It will then set the background color of every cell as the color of the corresponding pixel in the uploaded image. If you have chosen the ‘emoji’ option, the cell will be filled with the closest emoji that matches the color of the pixel.
In the last step, the Google Script will resize the cells and turn them into perfect squares. That’s it. Your spreadsheet art is now ready.Download Pixel Art
If you choose to transform your picture into emojis pixels, the script takes the average color of the pixel, finds the closest emoji and adds it to the corresponding cell in the sheet. The emoji module is based on the work of Monica Dinculescu.
Google Developer Expert, Google Cloud Champion
Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.