Google Sheets Pixel Art

Google Sheets pixel art: copy and paste

The quickest route on a laptop or Chromebook takes under a minute:

1. Add a picture above, or click Templates, and set Grid width and Colors.
2. Click Copy for Google Sheets.
3. Open a new blank spreadsheet (typing sheets.new in the address bar does it in one step).
4. Click cell A1 and press Ctrl+V, or ⌘+V on a Mac.
5. Make the columns square (below), and the picture appears.

Behind the button, the tool puts your picture on the clipboard as a table in which every cell has its own background color. Google Sheets turns each table cell into a sheet cell and keeps the fill, so the colors arrive without any rules or formulas. Google Sheets pixel art copy and paste works best in Chrome or Edge on a computer. On phones and tablets the Sheets app tends to drop the colors, which is why this page offers the Excel file first on small screens.

Import the file instead

Prefer a file, or need the Color Key sheet as well? Click Download Excel file, then bring it into Google Sheets in one of two ways:

• From inside Google Sheets: open a blank spreadsheet, choose File, Import, then the Upload tab, and drop in the file. Pick Replace spreadsheet or Insert new sheet(s) and click Import data.
• From Google Drive: click New, File upload, and choose the file. Double-click it to open it with Google Sheets. It opens in Office mode; choose File, Save as Google Sheets to get a normal Google spreadsheet you can share.

Importing brings both sheets, Pixel Art and Color Key, with every color. A mystery file must be imported this way, because its questions, formulas and color rules cannot travel through the clipboard.

Make the columns square in Google Sheets

A new sheet has rows 21 pixels tall and columns 100 pixels wide, so a pasted picture looks stretched sideways. One setting fixes it:

1. Press Ctrl+A, or click the gray box above row 1 and left of column A, to select the whole sheet.
2. Right-click any column letter and choose Resize columns.
3. Choose Enter new column width in pixels, type 21 and click OK.

Now every cell is a 21 by 21 pixel square. If someone has changed the row heights, do the same with a row number and Resize rows. To admire the result, zoom out from the View menu and hide the gridlines under View, Show.

Share pixel art with Google Classroom

Any file you open in Google Sheets can go out to a whole class in a few clicks, and each student works on a private copy:

1. Open the pasted or imported picture in Google Sheets and give it a clear name.
2. In Google Classroom, open your class and click Classwork, Create, Assignment.
3. Click the Google Drive button, choose the spreadsheet and click Insert.
4. Change the setting next to the file from Students can view to Make a copy for each student, then click Assign.

Classroom names each copy after the student, and you can open any copy from the assignment page to check progress. With a mystery picture you can tell at a glance who is nearly done: the more of the picture shows, the more answers are right.

Math pixel art activity in Google Sheets

Mystery mode turns a picture into self-checking practice. Pick Mystery in the tool, choose Math facts with an operation (addition, subtraction, multiplication, division or mixed) and a level, or switch to My questions and type your own, such as spelling words, vocabulary or capital cities. Split into more parts raises the count to as many as 20 questions. Download the file, import it into Google Sheets as above and assign it.

Students type each answer in a yellow cell. A right answer paints its share of the picture straight away; a wrong one turns its cell light red, so they know to try again without waiting for you. Capital letters and stray spaces are ignored. The check runs on formulas and color rules that Google Sheets supports natively, so it keeps working in every student copy.

One honest caveat for older students: the answer key is a hidden sheet, and View, Hidden sheets shows it to anyone who looks. Keep mystery pictures for practice and warm-ups rather than grades.

Works on Chromebooks

Everything happens in the browser, so a school Chromebook needs no app or extension. The picture is processed on the Chromebook itself and never leaves it, which keeps student photos private. If a managed Chromebook blocks the clipboard, use Download Excel file and the import steps instead; they give the same result.

Teaching with Excel or Microsoft Teams instead? See the Excel pixel art generator for desktop and Excel for the web steps.