How to 'undo' an import

Updated a month ago

Delete key

Sometimes importing can go a little awry... And whilst there's no 'undo' button, this guide will help you reset or re-import to get things ship-shape!

link First things first: what went wrong?

link Dealing with duplicates

If you've had lots of records created that are duplicates then you've likely forgotten to set deduplication for that particular record type. You can check your import template to make sure you'd chosen a field to deduplicate by. Deduplication settings

With the data that's been imported, there's two ways to deal with it depending on how large your data set is:

  1. Merge the duplicates (easiest for small data sets)
  2. Archive the records created and re-import (easiest for large data sets)

link Merging duplicates

Select the duplicates (e.g. all the events with the same name), click the action button and choose 'Merge records'. Anything pointing at those records will now all point at the one merged record.

Read more about merging records.

check_circle_outline Easy peasy, done and dusted!

link Fixing incorrect data

You've imported some data and it's just not quite right... maybe you forgot to map a particular column, maybe you mapped the wrong thing to one of your fields, or maybe you just hadn't realised your spreadsheet had some messy data in it!

The solution will depend a little on what your import was doing:

link Archive and re-import

If you have created any new records, it's usually best to archive those records and then run your import again. You won't usually need to worry about any existing records that were updated, as they'll be updated again by your re-import.

help_outline If you've set deduplication settings for all the records you're importing to, and every record has something in that field (e.g. you're deduplicating People by email and every person you're importing to has an email address) you can simply re-import without needing to archive!

  1. Select all the records that were created by this import. See our FAQ for some tips to find them!
  2. Click the action button and choose to 'Archive' them
  3. Fix your data errors, and run your import again.

check_circle_outline If at first you don't succeed, try, try again! All sorted.

link FAQ

link How can I find the records that were created by this import?

Here are some handy suggestions to help narrow down your lists to just those you want to archive.

If only a few records:

  • Sort your list by the 'Created' date, this should bring the records to the top and you can manually select them

If many records, add filters for:

  • 'Created by me'
  • 'Created date is today' (only if you haven't created any other records today)

Still need to be more specific? Add something unique about that import, such as:

  • If you were importing attendees for a particular event, you could add 'Event is XYZ' to your filter
  • If you were importing a list of people who volunteer, you could add 'Type is Volunteer' to your filter
  • If you were importing payments from Facebook, you could add 'Source is Facebook' to your filter

Contact Us

It'd be great to hear from you! To reach out, fill in your details below and we'll get back to you.


Register for webinar

To join this webinar, please enter your details below and we'll send you details on how to join.