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.

Marina and Mallory created a bright and beautiful wall mural using Google Sheets. Japanese artist Tatsuo Horiuchi uses Microsoft Excel to draw masterpieces.

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.

How to Paint with Google Spreadsheets

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.

Pixel Painting

Emoji Painting

Emoji Art

Watch the video tutorial or open this Google Sheet to explore more artwork made with Google Sheets. You can increase the zoom to view individual pixels.

Create Pixel Art with Google Sheets

It takes three easy steps to make pixel art with Google Sheets.

  1. Install Pixel Art for Google Sheets.
  2. Type sheets.new in the browser to create a new Google Sheet. Go to Add-ons menu, choose Pixel Art and then select Open.
  3. 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.

How Pixel Art Works?

The underlying Google Script will now parse every single pixel of your image and write the corresponding hex color codes in the cells of the spreadsheet.

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.

https://youtu.be/hoHvxbKDO00

Amit Agarwal

Amit Agarwal

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.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

0

Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.