Comparable List
ID reconciliation workflow

How to compare ID lists without losing leading zeroes

Reconcile order, customer, and database IDs with explicit rules for whitespace, case, and leading-zero formatting.

5 min readBy Comparable List Editorial Team

Prepare → compare → reviewPrivate, local list reconciliation

A useful list comparison starts with a clear decision, not an upload. This workflow keeps the comparison in your browser and makes the matching rules visible, so the resulting exception list can be reviewed rather than blindly acted upon.

1. Choose the matching field

Confirm that each line contains the same ID system. Two numerical-looking fields may belong to different databases or represent different entities.

2. Prepare comparable sources

Use raw exports when possible, one ID per line. Remove header labels or use the spreadsheet tool to select the correct column first.

  • Use exports created for the same scope and approximate date.
  • Keep the original source files untouched for audit and recovery.
  • Compare one meaningful field at a time instead of mixing identifiers.

3. Normalize intentionally

Start with trimming only. Turn on Ignore leading zeroes only when the systems document those zeroes as display padding; otherwise 00123 and 123 may be distinct IDs.

4. Review the result before acting

Validate a small sample of Common and different IDs in the source systems. Then export exception lists for the reconciliation owner.

Ready to check your data?

The tool runs locally in your browser. Review the result before you act on it, especially when a list contains customer, account, or operational data.

Open ID list compare

Frequently asked questions

Does this comparison upload my list?

No. The comparison, normalization, audit, and export happen in the browser tab. A share link is an exception: it intentionally encodes list data in the URL, so do not use it for confidential information.

Should I turn on every cleaning option?

No. Use only rules that preserve the identity of every item. Review the Common result and the suggested normalizations before exporting or acting on a difference.

Can I keep this workflow for next time?

Yes. You can save a local template with the selected options, or save a result summary in this browser. Full source lists are never stored unless you explicitly choose that local-device option.

Related tools and guides

Need a spreadsheet column selector? Try CSV & Excel compare. For a general workflow, return to the two-list comparator or browse all data-cleaning guides.