How to Make Pixel Paintings with Google Spreadsheets

Published in: Google Sheets

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 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.

📮  Subscribe to our Email Newsletter for Google tips and tutorials!
Published in: Google Sheets

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
Amit Agarwal

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. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch

Google Add-ons

Do more with your Gmail and GSuite account

We build bespoke solutions that use the capabilities and the features of Google Workspace for automating business processes and driving work productivity.

  1. Mail Merge with Attachments
    Send personalized email to your Google Contact with a Google Sheet and Gmail
  2. Save Emails and Attachments
    Download email messages and file attachments from Gmail to your Google Drive
  3. Google Forms Email Notifications
    Send email notifications to multiple people when a new Google Form is submitted
  4. Document Studio
    Create beautiful pixel perfect documents merging data from Google Sheets and Google Forms
  5. Creator Studio for Google Slides
    Turn your Google Slides presentations into animated GIFs and videos for uploading to YouTube