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.

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.

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