Spreadsheet pixel art: Create sprites in Google Sheets

Why make pixel art in a spreadsheet?

It sounds ridiculous, but spreadsheet pixel art is a real thing. People have been creating sprites, portraits, and even full scenes in Google Sheets and Excel for years.

Why would anyone do this?

• Zero software needed - Everyone has access to Google Sheets
• Perfect grid - Spreadsheets are literally grids of cells
• Great for learning - Forces you to think pixel by pixel
• Fun challenge - There's something satisfying about misusing tools
• Shareable - Send anyone a link, no downloads required

Is it the best way to make game sprites? Absolutely not. But it's a fun starting point, and you might learn something about pixel art along the way.

Setting up your spreadsheet

Open Google Sheets and create a new blank spreadsheet.

Step 1: Make cells square

By default, cells are rectangles. We need squares for proper pixels.

1. Select all cells (Ctrl+A or Cmd+A)
2. Right-click any column header → "Resize columns" → Set to 20 pixels
3. Right-click any row header → "Resize rows" → Set to 20 pixels

Now you have a perfect grid of square cells.

Step 2: Set up your canvas

For a 16×16 sprite:

1. Select cells A1 through P16 (16 columns × 16 rows)
2. Add a border: Format → Borders → All borders
3. Use a light gray border color so it doesn't overpower your art

Step 3: Prepare your colors

Create a color palette reference off to the side (columns R-S):

• Pick 4-6 colors for your sprite
• Fill cells with each color
• Label them (skin, armor, shadow, etc.)

This makes it easy to use the eyedropper tool later.

The cell coloring technique

The actual "drawing" is just filling cells with background colors.

Basic workflow

1. Select a cell (or multiple cells)
2. Click the fill color bucket in the toolbar
3. Choose your color
4. Repeat for every pixel

Faster techniques

Fill multiple cells at once:

• Click and drag to select a range
• Apply fill color to all selected cells

Use the eyedropper:

• Select a cell
• Click fill color → Custom → Pick from existing cell
• Copies the exact color

Keyboard shortcut (sort of):

• After filling one cell, select the next and press Ctrl+Y (repeat last action)

Creating a simple sprite

Let's make a basic 8×8 coin sprite.

The design

We'll use 3 colors:

• Gold (#FFD700) - Main coin body
• Dark gold (#B8860B) - Shadow/edge
• White (#FFFFFF) - Highlight

Step by step

Row 1-2: Leave empty (transparent)

Row 3:

• Cells C-F: Gold

Row 4:

• Cell B: Dark gold
• Cells C-F: Gold
• Cell G: Dark gold

Row 5-6:

• Cell B: Dark gold
• Cell C: White (highlight)
• Cells D-F: Gold
• Cell G: Dark gold

Row 7:

• Cell B: Dark gold
• Cells C-F: Gold
• Cell G: Dark gold

Row 8:

• Cells C-F: Dark gold

The result: a simple coin with depth and shine.

Exporting your creation

Here's where spreadsheets fall short. There's no "Export as PNG" button.

Option 1: Screenshot

1. Zoom to 100% or higher
2. Hide gridlines: View → Show → Gridlines (uncheck)
3. Take a screenshot of your sprite area
4. Crop in any image editor

Problem: Resolution depends on your screen. Not ideal for game assets.

Option 2: Copy to Google Drawings

1. Select your sprite cells
2. Copy (Ctrl+C)
3. Open Google Drawings
4. Paste (Ctrl+V)
5. Download as PNG

Problem: Still captures as an image, not true pixel data.

Option 3: Use a conversion script

Some people have written Google Apps Scripts to export cell colors as pixel data. Search "Google Sheets to pixel art export" for community solutions.

Problem: Technical setup required.

The honest truth

Exporting is the weakest part of spreadsheet pixel art. You'll spend more time fighting the export than creating the art.

Limitations of spreadsheet pixel art

Let's be real about what spreadsheets can't do:

Spreadsheets work for learning and fun. They don't work for actual game development.

When to upgrade to real tools

Spreadsheet pixel art is a fun experiment, but you'll hit walls quickly:

Upgrade when you need:

• More than one sprite
• Animation frames
• Clean PNG exports
• Faster workflow
• Professional results

Your options:

1. Free editors - Piskel, Pixilart
2. Pro editors - Aseprite ($20, industry standard)
3. AI generation - Sprite AI (describe what you want, get it in seconds)

If you enjoyed the pixel-by-pixel thinking but want real tools, check out our beginner's guide to easy pixel art.

Skip the spreadsheet entirely

Here's the thing: if you're making sprites for a game, spreadsheets will slow you down.

What takes 30 minutes in Google Sheets takes 10 seconds with AI:

Instead of coloring cells one by one, just describe what you want:

pixel art gold coin, shiny, game item,
spinning animation, transparent background

Generate a coin sprite →

Generate a character →

Generate an enemy →

You get a game-ready sprite instantly. Then use the built-in editor if you want to adjust individual pixels—just like a spreadsheet, but designed for the job.

The verdict

Spreadsheet pixel art is:

• Fun for learning
• Good for understanding pixels
• A neat party trick
• Not practical for real projects

Use spreadsheets if:

• You're curious and want to experiment
• You're teaching kids about pixels
• You enjoy creative constraints
• You have no other tools available

Use real tools if:

• You're making a game
• You need more than one sprite
• You want to animate
• You value your time

The skills transfer. Thinking pixel-by-pixel in a spreadsheet teaches you the same fundamentals as any pixel art tool. But when it's time to actually ship something, upgrade to tools built for the job.

Related posts

Blog

2D pixel art for games: complete style guide

A practical style guide for 2D pixel art in games. Covers pixel art styles from 8-bit to modern HD, resolution choices, color theory, and keeping your assets consistent.

Blog

Anime pixel art — the JRPG tradition that never left

How anime pixel art evolved from SNES JRPGs to modern indie games. Techniques for eyes, hair, poses, and palettes at small scales.

Blog

How to make a pixel art game — the practical roadmap

A step-by-step plan for making your first pixel art game. Engine choice, art pipeline, scope control, and the tools that save the most time.