From a crowded list to two real choices

Trim a Spreadsheet Down to Two Good Options

A shortlist is useful only when you can remember why each row is still there. Start with what the item must do, then remove anything that misses the basics.

Write down the item, its intended use and one must-have detail. Remove rows that miss that detail, compare the survivors on the same points, then keep one main choice and one backup that offers something genuinely different.

Before you open another result

Every new thumbnail can look like another possibility. Pause and write five things: the product type, how you will use it, one must-have detail, one preference you can compromise on and the missing fact most likely to change your choice.

Example: “Find a compact crossbody bag for daily travel. It must show usable dimensions and a secure closure. Color is flexible. Interior layout is the main unknown.”

This note is there to keep you honest. If a bag cannot meet the closure requirement, a good-looking thumbnail is not a reason to keep researching it.

Cut the list in four passes

01

Write the need

Note the must-have and the detail that would make you reject a row.

02

Remove the easy noes

Close wrong categories, dead links and repeated rows before studying the photos.

03

Compare the survivors

Use the same measurements, photo checks and price basis for every remaining row.

04

Choose or pause

Keep one main choice, one different backup and one missing detail to check.

Write down the same details for every row

CheckWhat to writeWhat it helps you do
Basic fitMeets, partly meets or misses the stated needRemove rows that require changing the original goal
What is shownSpecific photos, measurements, options and construction detailsPrefer rows that answer the question that matters
Current linkWhether the destination still resembles the saved item and optionNotice when two pages no longer agree
Price contextLower, similar or higher than genuinely comparable candidatesAvoid treating the lowest figure as a verdict
Weight attentionLow, medium or high sensitivity to packed size and weightNotice categories where shipping could change the comparison
Next actionKeep, check one gap or removePrevent candidates from remaining open without a purpose

Not every unknown deserves another tab

It could make the item unsuitable

A missing chest measurement, incompatible specification or unclear bag dimension needs an answer. If you cannot get one, remove the row.

A single photo or unit could settle it

The row can stay for now, but write the exact view, source match or measurement you still need.

It will not change the choice

Some small details can remain unknown. Say that plainly instead of treating them as confirmed.

Example: choosing between six crossbody-bag rows

Imagine you need a compact daily bag with known dimensions and a secure closure. None of the rows below represents a live product.

RowUseful detailsImportant gapDecision
ADimensions, interior view and clear closurePacked weight not shownPrimary candidate; weight remains a comparison note
BStrong exterior photosNo interior or depth measurementOne focused check before keeping
CSame design as A with fewer detailsAdds nothing newRemove as duplicate work
DClear size and a lighter constructionClosure differs from the briefRemove because the non-negotiable fails
EDifferent interior layout and complete measurementsHigher figure than the groupKeep as a deliberate fallback
FAttractive thumbnail onlyDestination and measurements unclearRemove and choose a better documented row

Spend time on details that could change your choice

Before opening a new page, ask what you would do with the answer. Would you switch rows, remove one or keep it? If every possible answer leaves the list unchanged, that detail can wait.

Thing to checkWhy it mattersWhat to do
Confirm a required measurementHigh: the answer can make the item unsuitableCheck before keeping the candidate active
Find one missing construction viewMedium to high when construction separates the shortlistUse one focused search or compare a better-documented row
Open another page with the same photos and unknownsLow: it adds volume without answering the important questionClose it and keep the clearer source
Confirm a minor cosmetic detail that will not change the roleLow unless it is part of the briefRecord as acceptable uncertainty

Give each row no more than three focused checks. If the same deal-breaker remains after that, compare a different row instead of repeating the search.

Common shortlist failures

  • Changing the goal: every attractive result changes what you think you need. Return to the note you wrote at the start.
  • Fake variety: several rows look different but lead to the same source and miss the same details. Keep the best documented version.
  • Never deciding: every row stays open indefinitely. Give each one a next action or close it.
  • Fixating on the first price: make sure the size and option match before comparing figures.

Keep a note you will understand tomorrow

What I need: item, use and must-have detail

Main choice: best reason to keep it and one known limitation

Backup: what it does differently

Rows I removed: one short reason for each

Next step: one check that could change the choice, or stop

“Looks good” will not help tomorrow. “Main bag: dimensions and interior shown; packed weight still unknown” tells you exactly where to continue.

The stopping rule

Stop when another result is unlikely to solve a new problem or replace one of your two choices. Repeated rows do not make the comparison stronger.

Related reading