# Find and merge duplicate records

> Find records that are the same by e-mail, phone or name, and merge each group into one record without losing its links.

Source: https://artavolo.com/page/find-duplicates

Contacts typed twice, a customer who signed up again, a list brought in on top of another: duplicates are found and merged in a minute.

## Find them

1. Click the base's name at the top left and choose **Duplicates**, then the table.
2. Tick the fields that make two records the same: an e-mail, a phone, a name, or several together.
3. Press **Find duplicates**.

E-mails and text are compared without capitals or extra spaces, and a phone by its digits, so +359 88 123 4567 and 088 123 4567 are one number.

## Merge a group

Each group shows its records, the one made first ticked as the one kept. Pick another if you like, and press **Merge into the one kept**:

- its empty fields take the first value the others have; lists (several options, links, files) take all of them;
- every link to the others, from any table, now goes to the one kept;
- the others go to the trash, where they can be restored for 30 days.

Merging needs the right to change and delete records in the table. It is in the audit log.

## Related

- [See records on a map](https://artavolo.com/page/map-view)
- [Documents and e-signatures](https://artavolo.com/page/documents-and-signatures)
