Excel when used as a database reading the boolean values true and false as 1 and 0.

  • 14 December 2022
  • 2 replies


Excel when used as a database reading the boolean values true and false as 1 and 0.Has anyone faced this issue.If so what is the solution for this?


Best answer by Padmakumar 14 December 2022, 13:35

View original

2 replies

Userlevel 7
Badge +13

Hi @Viji 4688 ,


In the excel sheet what is the cell value you are getting when you click on any of the Boolean data?

Is it like, True in the cell but cell value is 1 or the opposite?

Userlevel 3
Badge +6

Dear @Viji 4688,


Yes, it's common for Excel to interpret Boolean values (true/false) as 1/0 when using it as a database. This is because Excel stores numerical values in a different format than text values, and the Boolean values true and false are considered text values in Excel.

One way to solve this issue is to convert the Boolean values to numerical values before importing them into Excel. For example, you could use an IF statement in your source data to convert true to 1 and false to 0. Then, when you import the data into Excel, the Boolean values will be stored as numbers and can be treated as such.

Another option is to use a different data type in Excel to store the Boolean values. For example, you could use the logical data type, which is designed specifically for storing Boolean values. This will allow Excel to recognize the Boolean values as such, and you won't need to convert them to numbers before importing the data.

Overall, there are a few different approaches you could try to solve this issue. The best solution will depend on your specific situation and the needs of your application. If you need additional help, you can contact the Microsoft Excel support team for assistance.