The spreadsheet method, step by step
- Open a new sheet and type your tier letters (S, A, B, C, D) down column A, one per row.
- Select each tier cell and fill it with a color — red for S, orange for A, and so on — using the fill-color tool.
- Widen the rows so items have room.
- Type your items into the cells to the right of each tier, or paste them in.
- To move an item, cut it from one row and paste it into another.
- To share an image, take a screenshot and crop it.
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.