# Cleanup summary

- input.csv: in 12 out 9 duplicates removed 2

## Issues by type (row-by-row detail is in issues.log)

- invalid or non-North-American phone: 4
- missing email: 4
- name left as typed (e.g. McDonald, van der Berg), please confirm: 2
- invalid date: 1
- invalid email: 1
- unrecognised province: 1
- blank row: 1

- Dates read using your confirmed DMY format that could also be read the other way: 2
- Flagged rows are kept, with bad values blanked. Removed duplicates are listed in removed_duplicates*.csv.
- Cells that start with = + - @ or a tab could run as formulas in Excel, so a leading ' was added to each. Those in the cleaned file are listed in issues.log; the removed-duplicate copies get the same treatment (a +1 phone there will show as '+1...).