How can I import a list that may contain "blank" data and have the field updated to be blank even if it already has text in it? | Community
Skip to main content
Danielle_Wong
Danielle_Wong
Community Manager
October 12, 2017
Solved

How can I import a list that may contain "blank" data and have the field updated to be blank even if it already has text in it?

  • October 12, 2017
  • 1 reply
  • 2077 views

For example, say I wanted to clear out some fields that were imported incorrectly for some of my contacts. Is there a way to clear that field out for these contacts? If so, how?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Loren_Posendek

Hi Danielle, you should be able to accomplish this by typing 'NULL' in the cell for values that you'd like to be blank. I'd test it to be sure, as some fields may have updates blocked upon import.

Another option is to pull a smart list using the email address filter. Copy and paste all email addresses from the list, then manually NULL out the fields.

1 reply

Loren_Posendek
Loren_PosendekAccepted solution
New Participant
October 12, 2017

Hi Danielle, you should be able to accomplish this by typing 'NULL' in the cell for values that you'd like to be blank. I'd test it to be sure, as some fields may have updates blocked upon import.

Another option is to pull a smart list using the email address filter. Copy and paste all email addresses from the list, then manually NULL out the fields.

Danielle_Wong
Danielle_WongAuthor
Community Manager
October 12, 2017

Hi Loren, this is super helpful. I will try this! thank you

Terms & ConditionsAccessibility statement

Loading footer...