In Workbench I am query Account and I want to set ParentId to null (there are some bad id's and I want to clear them). However when I clear out the cvs file and update using workbench the values are not cleared, when I rerun the Query. I am using excel to clear the values with a Delete.

2 Answers 2


There is a setting in work bench that you need to check called 'Insert Null Values'. This should allow you to do updates with null values.

  • Workbench->Settings: Check Insert Null Values, Apply Settings. Enjoy.
    – wp78de
    Commented Mar 29, 2022 at 20:49

And the value for the CSV column should be {empty}, don't put NULL, it won't work.

  • Nope. Blank string works though, null and {empty} do not
    – Quango
    Commented Feb 21, 2020 at 10:21

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .