Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm uploading records with the amazing and have a hard time to upload some records with NO value for optional fields. What do I have to put in those fields?

  • #N/A
  • 'null'
  • NULL
  • ''
  • ""
  • 0

Is there a definite guide or reference document that answers this?

share|improve this question

Inserting null values is an option that you need to manually set for the api call. Once you set that option you just leave the cells empty and it will null out any fields where the cell is empty.

In you set this option here: null setting

That option is greyed out for me and from the discussion boards it looks like they haven't implemented this feature yet so you may have better luck using the regular dataloader to do this. With the regular data loader you do this here: enter image description here

share|improve this answer
I can't use the standard dataloader as it does not allow me to auto-relate fields like the does. – Robert Sösemann Feb 20 '13 at 16:05
@RobertS You might want to look at the free informatica data loader. I know it has auto-mapping for fields/columns with the same name and supports inserting null values. – Greg Grinberg Feb 20 '13 at 16:10
I can't use Informatica as I am on a Mac :-( – Robert Sösemann Feb 21 '13 at 10:58
Does anybody know when will support null values?! – Robert Sösemann Feb 21 '13 at 10:59
@RobertS Have you tried Jitterbit data loader? I know it works on mac and I believe it supports auto-relation. – Greg Grinberg Feb 21 '13 at 14:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.