Spreadsheets vs. Water Analytics

4 Biggest Risks of Using Excel for Utilities

Until a few years ago, no single piece of software brought together all of the information and functions crucial to running a water and wastewater utility.

Clunky legacy solutions often fell short or left gaps, and operators had to make due with haphazard, improvised solutions instead: manual SCADA exports, post-it notes, desk drawers stuffed with documents, and maybe most frustrating of all, spreadsheets.

But as more of our work moves online and low-cost digital tools have become widely available, the excuses for managing mission-critical information in this way are quickly running out.

Information management platforms like Klir are making it easier than ever to capture what happens in our organizations in a way that’s faster, more reliable, and safer than spreadsheets, all within a single, dedicated water analytics platform.

As more water utility operators engage in digital transformation projects, it pays to ask the question: what exactly are we missing out on by sticking to our spreadsheets?


Hemorrhaging critical information and losing work

Spreadsheets are a leaky medium in general: when we start relying on them to organize critical processes or store large amounts of data, some of it inevitably gets lost.

Permitting is a common example of this. Many larger utilities often find themselves having to manage, catalogue, and maintain thousands of permits at a time. But when that documentation lives in dozens of different spreadsheets scattered across dozens of different computers, permitting data often gets duplicated, overwritten, misplaced, or lost entirely. 

That’s because spreadsheets:

  • Often force us to rely on memory, specifically the memory of the person who initially created, formatted, named, and stored the spreadsheet.
  • Become increasingly unstandardized as team members come up with their own private ways of storing information in them.
  • Don’t automatically sync, leaving documentation prone to confusing duplication, errors, and accidental deletion.
  • Force team members into an opaque environment defined by information silos, rather than a single source of truth.

As the water industry confronts the ‘silver tsunami,’ the pressure for utilities to come up with a less leaky system for managing permitting and other kinds of mission-critical information is only increasing.

Losing time on repetitive tasks

Spreadsheets tend to be popular with smaller or new organizations because they appear, at least initially, to take less time to set up than a dedicated information management system. 

But the irony is that as the amount of information we store in them increases, spreadsheets take more time to maintain, not less.
That’s because spreadsheets:

  • Don’t automatically populate, forcing employees to spend more time on data entry, pulling them away from more important tasks.
  • Are difficult or impossible to integrate with other systems, such as scheduling software, email, GIS, SCADA, LIMS—and even other spreadsheets.
  • Aren’t custom built for water. As the complexity and variety of tasks in our spreadsheets increases, the more work they take to set up and maintain.

Hemorrhaging critical information and losing work

Another symptom of spreadsheet reliance is that your staff is never fully confident in their information. That’s because spreadsheets:

  • Live offline, decreasing accessibility and transparency.
  • Belong to different owners, increasing the risk of duplication and redundancy. 
  • Have no restrictions around version control, making mistakes hard to flag or trace back to their source.

Inherently contain out-of-date data, as they lack real-time capabilities.

Introducing security risks

In addition to being unreliable, spreadsheets simply aren’t as secure as the purpose-built tools that water operators have at their disposal today. 

Whether you’re sharing spreadsheets over email or constantly swapping Excel files using local drives, spreadsheets create an information ecosystem that is difficult to secure, leaving your data vulnerable.


Why water analytics beat spreadsheets
every time

Enter modern water analytics platforms like Klir, which promise to fix these problems by providing a cloud-based, secure, centralized repository for critical reporting data and information crucial to plant operations.

By liberating information from spreadsheets and managing it this way, water utilities can:

Cut down on data loss and ambiguity

Dedicated water analytics platforms create a central, secure, and reliable collection point for all of your information, enabling you to:

  • Simplify reporting and cataloguing, reducing the risk of duplicate or lost information. 
  • Reduce risk of regulatory violations by processing data in real time and creating a reliable source for compliance information. 
  • Liberate and preserve institutional knowledge by putting all of the utility’s critical assets in one easy to access location.

Save time through automation

Water analytics software like Klir are built for tasks like permitting and sampling, making it easier to automate data collection and analysis enabling users to:

  • Automatically track and update tasks and targets in real time.
  • Generate actionable reports with minimal effort.
  • Rely on built-in failsafes that protect and ensure the integrity of your assets.

Enable collaborative, confident asset building

Unlike spreadsheets, platforms enable collaboration and information exchange in real time, creating an environment that encourages staff to build and take care of information assets, rather than making it a chore.

Solutions like Klir allow water operators to build and share a single source of truth with their colleagues, removing the possibility of ambiguity and duplicates and giving operators confidence in their data. 

Better accommodate growth and find new efficiencies

Using spreadsheets is a bit like looking at your organization through a keyhole. Centralizing and cataloguing your information using a dedicated platform, on the other hand, is like zooming out to get the full picture, providing your team with an entirely new perspective on which processes might need revising. 


Aggregating information this way and looking at it through intuitive analytics tools opens up an entirely new world of possibilities for plant operators. 


For the first time, you can see where trends intersect to identify cause/effect relationships and gain efficiency by identifying overlap in your internal processes. And as the amount of information your organization generates grows, those insights will only grow stronger.

Klir is the single platform you need for water management

Built with IT professionals in mind, Klir is the operating system for water.

Ready to learn how Klir can support your utility's transition to cloud-based data management? Speak to one of our experts.