lucid.page A practical checklist for reconciling two contact lists
Text size
Read time2 min

# 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

# 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.

End