Version 1.6.0 offers check for data consistency

Aug 29 2021

Version 1.6.0 offers a new feature that many users have asked for. With “Data > Check Data Consistency …” you can easily check if the values in the currently active column look consistent.

But what does “look consistent” mean?

Data consistency is crucial for most use cases where CSV files are involved, but typically consistency depends on that very use case. To find possible inconsistencies, Tablecruncher checks all the values within the currently selected column and tries to find out what data type is present in most of the cells. Any cell with content that doesn’t match the data type of the majority of cells in the selected column, is flagged as “potentially inconsistent”.

Currently, it checks for these types:

  • Integer
  • Floating point (with decimal point)
  • Floating point (with decimal comma)
  • Date
  • Email
  • Number (Digits, optionally combined with points, commas and/or hyphens)

Of course, the check for inconsistent line lengths (different cell number per row) is additionally performed when opening a CSV file.

Older versions are ready to be downloaded on the Download page.


  • Feature: Check data consistency
  • Fixed: Some smaller bugs

Download Free    Buy Now!
Version 1.6.0
requires Mac OS X El Capitan, macOS Sierra, High Sierra, Mojave, Catalina, Big Sur (Intel/ARM64), Monterey (Intel/ARM64) or Ventura (Intel/ARM64)

This website uses cookies

We use cookies to analyze our traffic and to provide shop functionality. We also share information about your use of our site with our analytics and shop partners. You consent to our cookies if you continue to use our website. More details in our Privacy Information.