Urgent.News

What's breaking now, across thousands of outlets.

More in Tech

How to remove duplicate customers from a spreadsheet by email address

A customer list that has been fed by sign-up forms, imports and the odd copy-paste ends up with the same person on it two, three, four times.

  • Open customer list in Spreadsheet Editor by dropping .xlsx file
  • Highlight duplicate email addresses using conditional formatting
  • Remove duplicates, retaining first instance of each email address

More from Friday 6 November →