# A practical checklist for reconciling two contact lists
When a team combines a registration list with an attendance sheet, the same number of rows does not guarantee the same people. Separate the entries into three groups: in both lists, only in the first, and only in the second.
Contents
# Prepare the data
- Export only the fields you need. Use a stable identifier when names can be shared.
- Remove empty lines and decide whether leading spaces and capitalization should be ignored.
- Check repeated entries before comparing. A set comparison can hide duplicate rows and does not reconcile quantities.
- Keep a copy of the originals so a change can be traced.
# Test the method
For a non-sensitive example, compare Anna, Bo, and Chen with Anna, Bo, and Dana. Anna and Bo are shared; Chen is only in the first list; Dana is only in the second. A reviewer can then find out whether the two differences are cancellations, additions, or spelling mistakes.
List Matcher can show common and different entries in two lists. It compares text; it cannot determine whether two differently spelled names represent the same person. Check the current privacy information before using real contact details, and use sample data when possible.