Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I correct problems with Bools in Excel CSV files?

April 26, 2017csv Excel files problems

0

Posted

How do I correct problems with Bools in Excel CSV files?

1 Answer

0

Posted

If you work in Excel with a CSV file that contains Bools, Excel uppercases the Bools, interpreting them as the built-in functions TRUE() and FALSE(). This cannot be changed by using either a retype or find/replace. However, the application expects lowercase true and false, and throws an exception if the uppercase tokens are passed. Workaround: After you finish working in Excel, save the file, close Excel, and open the CSV file in a text editor. Replace TRUE with true and FALSE with false.