I am trying to import data into the Accounts area, and have to transfer over to custom fields, "Agency" and "Block Email". These should be checkboxes.

However, whenever I try to import them, I consistently get the wrong results: all the "Agency" fields become "True", and "Block Email", "False". I have tried importing the values as a boolean, int (1=Yes, 2=No), but no avail. I also tried changing the data type to a dropdown. The same result.

I am not sure what to do at this point except pulling my hair out, so will appreciate any suggestions.

Hoa