A teacher running a 30-minute classroom unit, a kid messing around on a Chromebook the school locked down, or a game-jam dev who only has a browser tab open all hit the same surprising answer to how to make pixel art in Google Sheets: yes, it works, and the recipe is four ingredients. Resize the cells into perfect squares, build a numbered palette, set conditional formatting so each number paints a fill color, then paint the canvas by typing digits. The default Google Sheets row height is 21 pixels (verified against the live Google Sheets resize dialog on June 4, 2026), which is also the canonical column width the official Pixel Art by Alice Keeler add-on inserts, so the cell math lines up cleanly with no fuss. This post walks the full five-step workflow, then shows the browser-native escape hatch for the moments a spreadsheet stops being the fastest tool.
What “how to make pixel art in Google Sheets” actually means in 2026
Pixel art is a constrained image format with three properties that separate it from pixel-shaped illustration. First, every pixel is intentional — the canvas is small (typically 16×16 to 96×96 per sprite) so each placement is a deliberate choice (Wikipedia’s overview of pixel art spells out the genre’s low-resolution roots cleanly). Second, the color palette is locked to a small set so the whole piece reads as one coherent style. Third, the output is a flat raster image with hard edges, no anti-aliasing, and ideally a transparent background.
A spreadsheet is not built around any of those three constraints, but it can be coaxed into all three with a single trick: conditional formatting. Conditional formatting maps the value of a cell to a fill color. Tag each color with a number, write one rule per color, then the act of typing a digit into a cell becomes the act of painting a pixel. The grid becomes the canvas, the keyboard becomes the brush, and the rules become the palette. That is the whole conceptual basis for how to make pixel art in Google Sheets, and the rest of this post is just the mechanics.
The honest framing matters because the spreadsheet is excellent at the teaching surface (a kid sees how a pixel grid works in 60 seconds) and weak at the shipping surface (no PNG export with transparency, no animation timeline, no sprite-sheet packing). The five steps below cover the teaching surface end-to-end, and the second half of the post covers the browser-native pipeline that ships actual game assets when the spreadsheet runs out of room.
How to make pixel art in Google Sheets in five steps
The recipe below is the canonical five-step workflow. Every step is reproducible inside any Google Sheets browser tab in 2026 with zero install and zero payment.
Step 1: Resize cells into a perfect square grid
Cells in a fresh spreadsheet are rectangles, not squares, so the first step is fixing the geometry. Click the empty corner cell at the intersection above row 1 and left of column A — that single click selects every cell in the entire sheet (all 18,278 columns and 10 million rows). Right-click any column header letter (A, B, C, …) and pick Resize columns. In the dialog, switch to Enter a new column width in pixels and type 21, then click OK. Every column in the sheet snaps to 21 pixels wide. Repeat the move on a row header: right-click, Resize rows, Specify row height in pixels, type 21, OK. Both axes now match the default Google Sheets row height (verified on the live resize dialog on June 4, 2026), and every cell in the sheet is a perfect 21 by 21 pixel square.
The corner-cell trick is the fast path because the resize applies to the whole sheet in one operation, so any new tab or any duplicated copy of the workbook inherits the same square grid. If a larger preview canvas is wanted, swap 21 for 25 or 30 on both axes — the rule is simply that both numbers match. For classroom or jam-room work, 21 pixels is the sweet spot because it matches the official Pixel Art by Alice Keeler add-on, so any template a student grabs from the marketplace drops in cleanly. Above 64×64 the spreadsheet starts to slow down (each colored cell costs a conditional-formatting evaluation), so the practical sprite ceiling inside a sheet is roughly 64 pixels per side.
Step 2: Build a numbered palette
Pick a small color set and tag each color with a single digit. The fastest path is to copy a recognised pixel-art palette so the result looks like a real sprite, not a 1990s clip-art experiment. The four palettes a beginner should know are PICO-8 (16 colors, the modern indie jam-game default), Game Boy (4 greens, NES-era nostalgia), SWEETIE-16 (16 soft pastels), and Endesga 32 (the broad modern indie RPG default). All four are built-in palette presets in the Sorceress True Pixel tool (verified in the PALETTE_PRESETS array at the top of src/app/pixel-art/page.tsx on June 4, 2026, alongside CGA, NES 54, Grayscale 8, and 1-Bit). For a beginner Google Sheets project, eight colors is plenty: pick 1 through 8 and assign each digit a hex code on the side of the sheet so the key is visible while painting.
A simple eight-color starter set borrowed from PICO-8 is digit 1 black (#000000), 2 dark blue (#1d2b53), 3 dark green (#008751), 4 dark red (#7e2553), 5 light gray (#c2c3c7), 6 white (#fff1e8), 7 yellow (#ffec27), and 8 orange (#ffa300). Paint a small swatch in cells K1 through K8, then write the digit next to each swatch so the legend reads at a glance. The indexed color approach the spreadsheet is borrowing from is exactly how early consoles stored pixel art: one byte per pixel, lookup table in ROM, fill the canvas by writing indices.
Step 3: Add one conditional formatting rule per color
Open Format → Conditional formatting. The sidebar shows a single “Add another rule” button at the bottom. For the painting range, select a generous block (something like A1 to AZ50 covers a comfortable 50×50 canvas). For the first rule, set Format cells if to Text is exactly, type 1 in the box, then click the fill-color icon under Formatting style, pick a custom color, paste the black hex #000000, and click Done. The rule is now live: any cell in the range that contains exactly the digit 1 fills with black.
Repeat for digits 2 through 8, one rule per palette color, pasting the matching hex from the legend each time. Eight rules cover an eight-color palette. The order of rules matters when two rules could overlap, but for unique digit-per-color rules they fire cleanly in any order. Save the workbook. The conditional-formatting block is now an interactive paint-by-number canvas: every digit press fills the cell with the matched color, every Backspace empties the cell back to the spreadsheet’s default fill. This is the exact mechanic the official Pixel Art by Alice Keeler add-on automates — the add-on inserts a sheet with conditional formatting already configured for numbers 0 through 100, where 4 fills green and 9 fills black for the Minecraft creeper demo (verified against the Google Workspace Marketplace listing on June 4, 2026, where the add-on is listed as free with 102K+ installs and was last updated March 14, 2024).
Step 4: Paint by typing the numbers
Click any cell inside the rule range. Type the digit for the color desired, press Tab to move right or Enter to move down. The cell fills with the matched color instantly. To paint a horizontal run of one color, type the digit, hold Shift, hit Right Arrow to extend the selection, then press Ctrl+D (Windows) or Cmd+D (macOS) to fill down the digit into the whole range — the conditional-formatting rule paints every newly filled cell. To erase, select the cells and press Delete. To recolor, select and retype the new digit.
The discipline this teaches is exactly the discipline professional pixel artists build inside dedicated editors: pick a swatch, stamp a pixel, repeat. There is no smudge tool, no anti-aliased blend, no accidental color drift. The keyboard is the brush, the palette is locked to the eight digits, and every visible pixel was a deliberate keystroke. For a classroom paint-by-number activity, the teacher hands out a digit pattern in a Google Doc and students transcribe the digits cell-by-cell; the picture appears under their fingers as they type. For a solo project, the artist works freehand inside the rule range and references the legend swatches in column K.
Step 5: Export the canvas (the hacky part)
Google Sheets does not export a flat PNG of a colored cell range natively. File → Download writes PDF, XLSX, ODS, CSV, TSV, or HTML — none of which a game engine accepts as a sprite atlas. Two paths get the art onto disk in 2026. First, the universal screenshot: Windows Win + Shift + S, macOS Cmd + Shift + 4, then crop tightly to the canvas edges. Drop the screenshot into Sorceress True Pixel, snap it to a true pixel grid, lock the palette, and export a clean transparent PNG. Second path: copy the colored cells into a Google Drawings file inserted into the same Sheet, then download the drawing as a PNG. The first path is faster because True Pixel handles the cropping precision, the palette quantization, and the alpha-channel cleanup in a single browser pass.
The export step is the honest cliff — the spreadsheet is the canvas, and the asset has to leave the spreadsheet through a downstream tool before any game engine’s 2D Sprite importer can load it. The downstream pass takes about ten seconds.