Spreadsheet Pixel Art Generator
Free. No watermark. No sign-up.
Or drop a picture on the preview, or paste one.
How to make pixel art in a spreadsheet
Load a picture
The Choose picture button takes a file from your computer or phone. Dropping one on the preview or pasting a copied image works too. Bold, simple pictures such as emoji, flags and mascots suit a sheet best.
Decide the columns and the fills
Width in cells is the number of columns the picture will take, from 8 to 128, and starts at 40. The row count beside it follows the picture's proportions. Colors, 2 to 64, is how many different fills the sheet will use.
Copy the cells or download the workbook
Copy for Google Sheets puts the grid on the clipboard as colored, empty cells. Download Excel file (.xlsx) saves the same grid as a workbook with its cells already square.
Paste at A1 and square the cells
In the sheet, click cell A1 and press Ctrl+V, or Cmd+V on a Mac. If the picture looks stretched sideways, select its columns and make them as wide as the rows are tall. The table below has the numbers.
What you get from the spreadsheet pixel art generator
A workbook written part by part
The .xlsx is the standard Office Open XML package: a ZIP holding six small XML parts for the content types, two relationship lists, the workbook, one worksheet named Pixel art and the styles. It has no macros, formulas or images.
One fill style per color
Each color is stored once, as a solid fill in the styles part, and a cell only points to its style. Sixteen colors make sixteen styles however many cells there are, which keeps the file small.
Cells 16 pixels square
Columns are saved 1.57 characters wide and rows 12 points tall. Excel reports both as 16 pixels, so the picture opens with the right proportions and nothing to resize.
A clipboard table in two forms
The copy holds an HTML table with a background color on every cell, plus a plain-text version made only of tabs and line breaks. Spreadsheets read the first for the fills and get no text from the second.
Unfilled cells where the picture is empty
Transparent parts of a PNG, and whatever Remove background clears, are written as cells with no fill. In the sheet they look like any untouched cell, with the usual gridlines.
A message after each copy
Under the buttons the tool confirms the copy with the size, such as 40 x 40 cells. If the browser refuses clipboard access it says so and points to the Excel file.
How do spreadsheet cells become pixels?
A sheet is already a grid, so a cell with a fill color and nothing typed in it behaves like one pixel. The obstacle is shape. A new Google Sheets column is 100 pixels wide and its rows are 21 pixels tall, which makes every cell nearly five times wider than it is high. Excel's default cell is 64 by 20 pixels. A picture dropped into an untouched sheet is stretched by that much.
Excel adds a second trap: it measures column width in characters of the default font and row height in points. Typing 20 for both gives columns of 145 pixels and rows of about 27. A width of 2.14 next to the default 15-point row is what makes a 20-pixel square.
Filling cells is not how the best-known Excel artist works. Tatsuo Horiuchi draws his landscapes with the AutoShape tool.
Cell sizes in Google Sheets, Excel and the downloaded file
| Where | Column width | Row height |
|---|---|---|
| Google Sheets, new sheet | 100 pixels | 21 pixels |
| Excel, new workbook | 8.43 characters (64 pixels) | 15 points (20 pixels) |
| The downloaded .xlsx | 1.57 characters (16 pixels) | 12 points (16 pixels) |
Google Sheets: click the letter of the picture's first column, hold Shift and click the letter of its last, right-click, choose Resize columns and enter 21.
Excel after a paste: select the columns and drag the edge of one column letter. A tip shows the width in pixels as you drag. Stop at 20 to match the default rows.
More pattern tools
Pixel Art Generator
Turn a photo or drawing into pixel art on a grid.
Pixel Art Maker
Draw pixel art online, pixel by pixel.
Sprite Maker
Draw sprites frame by frame and export a sprite sheet.
Pixel Art Resizer
Scale pixel art up or down without blur.
8-Bit Image Converter
Turn a photo into 8-bit or 16-bit retro art.
QR Code Pattern Maker
Turn a link into a QR code bead or pixel pattern.
Pixelate Image
Pixelate a whole photo, or only the part you pick.
ASCII Art Generator
Turn a picture or text into ASCII art you can copy.
Pixel Art Grid
Blank pixel art grids to print, or a grid over a picture.
Spreadsheet pixel art: common questions
Why is my pasted picture stretched sideways?
The fills arrived, but the sheet kept its own column widths. The copied table asks for 16-pixel cells, and a spreadsheet is free to ignore that. Nothing is wrong with the picture. Narrow the columns until they match the row height, 21 pixels in Google Sheets, and it snaps into shape.
How do I open the Excel file in Google Sheets?
In Sheets choose File, then Import, then Upload, and pick the .xlsx. You can also put the file in Google Drive and open it from there. The fills are stored in the file itself. LibreOffice Calc and Apple Numbers read .xlsx workbooks as well, so Excel itself isn't required.
Can it build a self-checking mystery picture?
No. In a classroom mystery picture, a cell turns a color only when a student types the right answer somewhere, and that is done with conditional formatting rules. Cells from this tool have plain fills that are always visible. What it can give you is the finished picture to plan from: which cells need which color.
What size works for a class activity?
Small. A new Google Sheet has 26 columns, A to Z, so a Width in cells of 26 or less fits without adding any. With Colors at 4 to 8, students can match each fill from the toolbar's Fill color button and count cells along a row. A 20 x 20 picture is 400 cells to fill.
Why is nothing typed in the cells?
A fill is the whole picture, and a number in each cell would show on top of it. For a sheet that prints a number in every square with a key of colors beside it, use the color by number generator, which makes a page for paper instead of a spreadsheet.
Should Dithering be on for a spreadsheet?
Mostly not. Dithering trades smooth areas for a scatter of single cells in alternating colors. At normal zoom, where a cell is 16 to 21 pixels across, that scatter is easy to see and looks like noise. It only pays off for a photo you plan to view zoomed far out, where the scatter blends into shading.
How do I see a big picture all at once?
Zoom the sheet out. At 128 columns the downloaded workbook is 2,048 pixels wide, more than a 1,920-pixel monitor shows, and the same picture pasted into Google Sheets with 21-pixel columns is 2,688. Excel has a zoom slider at the bottom right of its window. Sheets has a zoom menu in the toolbar that goes down to 50%.
Does the picture change if I edit the cells afterward?
Only where you change it. Every cell is an ordinary cell with a fill, so you can recolor one with the fill bucket, clear a few, or insert a row through the middle. Nothing in the sheet links back to the picture you started from.
Which should I use, the copy button or the Excel file?
Use the copy to drop a picture into a sheet you already have, at any cell you click. Use the file when you want the proportions right without resizing, or when the button reports that your browser didn't allow copying, which some browsers do for formatted content. Both hold the same grid and the same colors.
How many colors can a sheet hold?
Far more than the 64 this tool goes up to: a cell fill can be any hex color. The practical limit is your own. If people will recolor or extend the picture by hand, 8 to 16 fills are easy to tell apart. For a photo that is only looked at, use the full range.
Why does the preview show lines that the PNG doesn't?
Grid lines draws the cell borders on the preview so you can count columns before you copy. It changes nothing else. The sheet draws its own gridlines once the cells are pasted, and Download picture (PNG) saves the bare colors, each cell enlarged to a sharp square, for sharing what the sheet looks like.
Is there a limit on how large the picture can be?
Width in cells stops at 128, and a square picture at that width is 16,384 cells. Spreadsheets themselves go much further, since an Excel sheet runs to column XFD and past a million rows, but a picture that wide could not be seen without scrolling.