Home / Guides / Tier list in Google Sheets
How-to · 4 min read

How to make a tier list in Google Sheets

By Farasat Abbas Naqvi·Updated July 2026

Google Sheets can make a basic tier list using colored rows and typed entries. It works in a pinch — here’s how, plus where it falls short compared with a purpose-built maker.

Want drag-and-drop instead of cells?
Try the maker

The spreadsheet method, step by step

  1. Open a new sheet and type your tier letters (S, A, B, C, D) down column A, one per row.
  2. Select each tier cell and fill it with a color — red for S, orange for A, and so on — using the fill-color tool.
  3. Widen the rows so items have room.
  4. Type your items into the cells to the right of each tier, or paste them in.
  5. To move an item, cut it from one row and paste it into another.
  6. To share an image, take a screenshot and crop it.
⏱ Quick reality check

Building a tier list this way takes most people 10–15 minutes of fiddling with cell sizes and colors. The same board in a dedicated maker takes under 2 minutes — and the export comes out already cropped, no screenshot needed.

Where Google Sheets struggles

The method works, but it fights you:

  • No real drag-and-drop — you cut and paste cells instead of dragging tiles.
  • Fiddly sizing — rows and columns need constant adjusting.
  • No clean export — you screenshot and crop rather than downloading a finished image.
  • No images in tiles — ranking pictures is awkward at best.

The faster alternative

A dedicated tier list maker handles all of that for you: paste a list and every item becomes a draggable tile, drag between tiers, recolor with one click, and export a clean PNG that is already cropped and ready to share. For ranking images, it is the only practical option. If you just need something quick and shareable, skip the spreadsheet.

Task
Tier maker
Sheets
Move an item
Drag
Cut & paste
Recolor a tier
1 click
Manual fill
Add images
Yes
No
Export image
1-click PNG
Screenshot
Skip the spreadsheet hassle

Paste your list, drag to rank, export a clean PNG — in about two minutes, free and with no login.

Make a tier list free Rank images →

FAQ

{{ f.q }}+

{{ f.a }}

Keep reading

Guide
How to make a tier list →
How-to
Share & export a tier list →
FN
About the author
Farasat Abbas Naqvi

Farasat is an engineer who designs websites and builds practical online tools in his spare time. He created Tier List Maker after using other ranking sites that asked for an account, stamped watermarks on downloads, or simply did not work well on a phone. He is not a professional gamer or a self-described tier-list expert — he builds and maintains this site himself, fixes issues, and adds features based on what visitors actually ask for.