A dependable workflow for finding overlaps and differences in spreadsheet exports, one column at a time.
Comparing two CSV columns sounds like a one-click task until the results matter. Maybe you are reconciling product SKUs from two systems, checking a newsletter export against a registration list, or reviewing a supplier file before an import. In each case, the useful answer is not merely “these cells are different.” You need to know whether a value is genuinely missing, formatted differently, duplicated, or simply in a different order. This guide shows a private, repeatable way to get that answer with Comparable List. The comparison happens in your browser, so the contents of your columns are not uploaded to our servers.
Before copying anything, name the question. “Which customer IDs appear in this month's export but not last month's?” is a much better question than “Are these columns the same?” It tells you that order does not matter, that each ID should count once, and that the output should focus on values unique to either list. If you need to compare row-by-row relationships—for example, an email address paired with a price—keep the rows together in a spreadsheet instead. A list comparison treats every line as an independent item; it is designed for membership and overlap, not for preserving relationships across columns.
Open the CSV in a spreadsheet application and copy only the cells you intend to compare. Paste the first column into List A and the second into List B. Comparable List understands line breaks, and its “split Excel tabs” option is helpful when copying a vertical range from Excel or Google Sheets. Exclude headers such as customer_id or SKU; otherwise they become ordinary list entries and may show up as a false match. If your export has blank lines, they are ignored. Keep an untouched copy of the source file. A clean comparison should make review easier, not replace the source of record.
Use a small sample first when the file is unfamiliar. For example, compare SKU-001, SKU-002, SKU-003 against sku-002, SKU-003, SKU-004. This immediately reveals whether case differences should count. It is much easier to set the right rule on four values than to discover a formatting mistake after reviewing thousands.
Formatting is the most common reason a visually obvious match is reported as different. Turn on “trim whitespace” when leading or trailing spaces are accidental, as is common after a CSV export. Turn on “ignore case” for identifiers that are defined as case-insensitive, such as many email addresses or internal product codes. Do not use it blindly: case can matter for passwords, API tokens, and some technical identifiers. Comparable List also deduplicates a repeated item within each list for membership results. That is normally correct for a presence check, but it is not a frequency analysis. If you need to know that an item appeared seven times rather than once, use a pivot table or a counting workflow after you identify the values to investigate.
Start with “In both.” It confirms the values the two sources agree on and gives you a quick sense of overlap. Then open “Only in A” and “Only in B.” These are the review queues: every item is present in one source and absent from the other after your chosen normalization rules. Do not assume either queue is an error. A newer export may legitimately contain new records, or a source may use an archived value. Copy a result group back to a spreadsheet, add a status column, and annotate why each exception exists. This makes the next reconciliation faster and creates an audit trail without putting sensitive list contents in a third-party comparison service.
A good comparison has a simple arithmetic check: unique values in A plus unique values in B plus shared values should explain the distinct values you see across both inputs. Scan the first few exceptions for stray punctuation, non-breaking spaces, prefixes, or an accidental header. If a large fraction of values differ unexpectedly, stop and inspect the source format rather than working through the whole result manually. Common causes include comparing display names to IDs, using a comma-separated cell as one line, or mixing an old export with a new filter. Once the results look plausible, save the source version and the date of the comparison alongside your notes.
For an everyday membership check, you can now compare the two lists directly. The tool is intentionally simple: it gives you a clear set of matches and differences, while the judgment about what those differences mean stays with you.