Browsing workflow · 8 minute read

How to Turn a Long Spreadsheet Into a Ten-Item Shortlist You Can Explain

Saving everything moves the difficult decision to later. A three-pass workflow keeps discovery broad enough while forcing every final row to earn its place.

External routes and page guidance checkedHow pages are reviewed

Pass one: collect without pretending to decide

Choose one category and a clear brief. Save up to 25 candidates quickly, but record only title, source, visible price context and one reason the row caught your attention. This is discovery, not approval.

Pass two: remove evidence gaps

Delete rows that fail a requirement: wrong category, irrelevant source, missing measurement for a size-sensitive item, unusable photos or a price that depends on an unclear option. Do not spend equal time researching every weak row.

Pass three: compare survivors in pairs

Pair similar rows and use the same questions for both. Keep the one with clearer evidence, or keep neither if both share the same blocker. Pairwise comparison is easier than ranking a wall of unrelated entries.

The ten-item record

FieldWhat to write
CategoryThe narrowest useful product type
ReasonThe evidence that earned another look
Main uncertaintyThe next question to resolve
SourceWhere the external link actually leads
Weight sensitivityLow, medium or high—not a made-up estimate
StatusCurrent, re-check, duplicate or remove

Why ten is a useful ceiling

The number is not magic. It is small enough to re-check when listings change and large enough to preserve alternatives. If ten feels too restrictive, use ten per category rather than mixing categories into a larger unstructured list.

A shortlist is allowed to shrink to zero

The goal is not to fill every slot. In a weak category or uncertain search, an empty final list is more honest than ten rows saved to meet a quota.

Start the workflow

Choose one category and one requirement

Open the category guide, then apply the seven-point checklist during pass two.