# Boolean Data Type - Data Import Wizard

**URL:** <https://community.dhis2.org/t/boolean-data-type-data-import-wizard/39141>\
**Category:** Support - Assistance technique\
**Tags:** import\
**Created:** [5 May 2020 10:13 UTC](https://community.dhis2.org/t/boolean-data-type-data-import-wizard/39141 "2020-05-05T10:13:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikwato](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/vikwato/32/28121_2.png) [@vikwato](https://community.dhis2.org/u/vikwato)\
**Post date:** [5 May 2020 10:13 UTC](https://community.dhis2.org/t/boolean-data-type-data-import-wizard/39141/1 "2020-05-05T10:13:36Z")

</div>

Hi @carapai and anyone facing this challenge with the Data Import Wizard. What is the correct value to use for the Boolean data type? I have tried true/false, TRUE/FALSE, 1/0 but still shows as a conflict as shown below:

 ![image](https://dhis2.b-cdn.net/uploads/default/original/3X/d/5/d54f7a0bc049f707047cbfa3b15f334eef5092bf.png)

---

<div class="post-metadata">

**Author:** ![vikwato](https://dhis2.b-cdn.net/user_avatar/community.dhis2.org/vikwato/32/28121_2.png) [@vikwato](https://community.dhis2.org/u/vikwato)\
**Post date:** [5 May 2020 10:43 UTC](https://community.dhis2.org/t/boolean-data-type-data-import-wizard/39141/2 "2020-05-05T10:43:31Z")

</div>

So it turns out it’s an issue with Excel data formatting. I saved the file as csv, then opened it and saved it as xlsx and it has worked.