How to remove duplicates from import file in Excel before CRM import
Before you import your file into OnePageCRM, it's recommended that all duplicate contacts be removed. To check if there are any duplicates in your import file, apply the following operation in Excel:
- Tick the My data has headers to exclude the column headers from this operation.
- Under Columns, select one or more columns that might contain duplicates.
💡 To quickly select all columns, click Select All.
💡 To quickly clear all columns, click Unselect All.
💡 If your table has many columns, it might be easier to click Unselect All first, then choose only the columns you need.
💡 Removing duplicates only affects the selected range or table. Values outside the range of cells or the table are not altered or moved.
💡 Before removing duplicates, copy the original range or table to another worksheet or workbook as a backup.
💡 Analogical functionality is available in Google Sheets. Click on Data → from the dropdown select Data clean-up → Remove duplicates.