How to Set field values to NULL using Data Import

tomknight · May 3, 2025, 12:13am

Hello,
Is it possible to use Data Import to set Lead emails to a blank value?

I have a CSV file listing several hundred bounced emails. I want to delete those bad email addresses from the Email field for those Leads and leave the field blank.

Is this possible?

I have tried to upload a CSV file with tow fields: ID, and Email, with the Email field blank on each row. ERPNext reports “success” but failed to change the value in the email field.
Thanks,
Tom

ahsantareen · May 3, 2025, 4:18am

Hi

Those Data fields can be updated as blank by working from list view of Lead docytpe as following;