Compare Two Lists

What this does

Compare Two Lists is a browser-based text cleanup tool for spreadsheet work. It is built for quick checks before you commit a formula, model assumption, chart value, or converted file to a workbook. The calculation runs locally in your browser, so you can test private numbers without uploading a spreadsheet.

A worked example

For example, use Compare Two Lists to validate one small sample first, then repeat the same logic in your workbook. This gives you a reference result before you build a final formula, report tab, dashboard, or import file. Compare Two Lists is useful when you need a quick, defensible answer before rebuilding the same logic in a larger spreadsheet.

Common mistakes

• Mixing formatted percentages with decimal inputs, such as typing 25 when the sheet expects 0.25.
• Copying a result into a workbook before checking units, delimiters, date systems, or rounding.
• Using one test row only; always try a normal case and an edge case before reusing the result.

FAQ