Choose a project and set its constraints
Spreadsheet Pixel Art — Number Grids, TSV and Color Legends
Choose a pattern, preview numbered cells and copy a TSV matrix. Download CSV and a matching color legend with counts and attribution, then follow separate Excel and Google Sheets formatting steps.
Spreadsheet color-by-number grid
0 means transparent or empty, never white. Numbers 1–64 refer to source palette positions, not manufacturer bead codes. X increases rightward and Y downward from the top left.
16×16 · Cells: 64 · Empty cell: 192
Number matrix
| Y / X | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||||||||
| 2 | ||||||||||||||||
| 3 | ||||||||||||||||
| 4 | ||||||||||||||||
| 5 | ||||||||||||||||
| 6 | ||||||||||||||||
| 7 | ||||||||||||||||
| 8 | ||||||||||||||||
| 9 | ||||||||||||||||
| 10 | ||||||||||||||||
| 11 | ||||||||||||||||
| 12 | ||||||||||||||||
| 13 | ||||||||||||||||
| 14 | ||||||||||||||||
| 15 | ||||||||||||||||
| 16 |
Coloring range: B2:Q17
Color legend
| Number | HEX | Cells |
|---|---|---|
| 0 | Empty cell | 192 |
| 1 | #E85D75 | 64 |
| 2 | #F5C451 | 0 |
| 3 | #F7F4EA | 0 |
| 4 | #243047 | 0 |
CSV and TSV contain values only, not fills, formulas or an XLSX workbook. Keep the matrix and its matching legend together. If pasting produces one column, import the TSV with a Tab separator.
Creator: PixelMaster Studio · License: CC0-1.0 · Source: bright-heart
Excel and Google Sheets instructions
Excel
- Paste matrix TSV into A1 of a blank sheet. Import CSV through Data → From Text/CSV, using UTF-8 and a comma separator.
- Select columns B:Q and rows 2:17. Set row height to 15 pt, then drag column boundaries until width matches height. Excel column width is font-dependent, not pixels.
- Select B2:Q17. Home → Conditional Formatting → Highlight Cells Rules → Equal To. Add each nonzero legend number with its HEX fill. Leave 0 unfilled.
- Paste the legend into another sheet at A1. Check dimensions and counts, then save as .xlsx to retain manual formatting.
Official instructions
Google Sheets
- Paste matrix TSV into A1. Alternatively use File → Import, select CSV and a comma separator, or TSV and a Tab separator.
- Select columns B:Q, right-click → Resize columns → 24 pixels. Set rows 2:17 to 24 pixels too.
- Select B2:Q17. Format → Conditional formatting → Is equal to. Add each nonzero legend number and its HEX fill. Leave 0 unfilled.
- Paste the legend into another sheet at A1. Check dimensions and counts. Keep the document in Google Sheets to retain formatting.
Official instructions
- Cell value equals 1: fill #E85D75