Skip to main content

Undoing a Spreadsheet Import

Undo an Insert Only import within 7 days from the results screen or My Imports. Imports that used Insert And Update cannot be undone.

L
Written by Lauren Hickey-Jednat

You can undo an Import Data+ import that used Insert Only for 7 days after it completes. Undoing deletes every record the import created. You cannot undo an import that used Insert And Update.


Can I undo my import?

Import option

Can I undo it?

Insert Only

Yes, for 7 days after it completes

Insert And Update

No


How do I undo an import?

The Undo this import link is on the results screen. You see the same screen whether you stayed in the import window or opened the import later from My Imports.

  1. Open the results screen. If you closed the window, select Menu, select Your Profile & Preferences, select My Imports, and double-click the import.

  2. Select Undo this import.

  3. In the Delete Confirmation window, read the warning, select Yes, and then select OK.

💡 Pro Tip: Not sure you want to undo? Select View all imported Contacts first to see which records the import created.


What happens when I undo an import?

Crelate deletes all of the records the import created, including records that were edited or used after the import. The Delete Confirmation window warns that the deletion cannot be undone.


Can I undo an Insert Only import after I updated those records with Insert And Update?

Yes, within 7 days. Crelate deletes all of the records the original import created, even if a later Insert And Update import changed their fields. The Delete Confirmation window warns that the records created or updated by the import will be deleted.

💡 Pro Tip: To reverse only the changes from an Insert And Update import, you cannot undo that import. Correct the fields on the records directly, or import the corrected values with Insert And Update using Id as the Update Identifier.


Why can I not undo my import?

  • The import used Insert And Update. Only Insert Only imports can be undone.

  • It has been more than 7 days. The results screen says imports can be undone for 7 days after they complete.

💡 Pro Tip: Importing a new list for the first time? Choose Insert Only. You can undo it for 7 days if something looks wrong.


Key takeaway

You can undo an import only when you used Insert Only, and only for 7 days after it completes. Open the results screen, either right after the import or from Your Profile & Preferences > My Imports, and select Undo this import. Undoing deletes every record the import created, including records edited or used since. You cannot undo an import that used Insert And Update.


What’s Next?

Did this answer your question?