5 Signs Your Department Has Outgrown Spreadsheets for Community Health Work
Spreadsheets aren’t the enemy! But disconnected work that results in every priority being tracked a different place isn’t helping your team move faster. Here are five ways to tell whether your work could benefit from consolidating (outside of Excel).
1. Nobody's sure which spreadsheet is the "real" one anymore
If your last community health assessment involved file called something like "FINAL_v3_useThisOne," you know this one! As soon as more than one or two people are touching the same data, version control can become a nightmare (and the worst case scenario leads to an incorrect number making it into a board presentation because someone pulled from an outdated copy).
2. Your improvement plan is tracked in an inbox, not a platform
Progress updates that live in email threads and shared drive folders only reach the people already in the loop. Everyone else finds out where things stand when leadership asks for a status update — which usually requires someone spending two weeks reconstructing an answer that should have taken five seconds to pull up.
3. A board question is answered with "let me get back to you"
This one is a big tell! If a reasonable question about your community's data can't get answered in the room (because it requires a custom export, a new chart, or digging through last year's file), there's an issue with your tech stack.
4. Every external data request costs someone an afternoon
When a funder, partner organization, reporter, or resident wants "the numbers behind" something you published, answering requires a staff member stepping away from everything else to pull it together for them. What a time waster! Once this starts happening regularly, it becomes an invisible line item in how your team spends its time.
5. You can list the data you have, but not the story it’s telling
Today, most departments have more data than ever before — program data, claims data, survey results, and a dozen public sources. But it’s spread across just as many files. Having the data isn't the same as being able to see it layered together. If cross-referencing two data sources means someone manually merging spreadsheets before anyone can find a pattern, the volume of data you have isn't working for you (yet).
If Two or More of These Sound Familiar...
...you're not behind, and this isn't a knock on your team! It's just a sign that the tools running community health work haven't caught up to how much there is to track. Spreadsheets are fine for one person tracking one thing, but they stop scaling the moment a department is running a multi-year improvement plan, coordinating with outside partners, and fielding data requests from every direction at once (which describes most community health teams today).
Discipline around file naming or shared drive organization won’t fix the problem long-term. You need a platform where the current version is the only version, tracking happens in one shared place instead of an inbox, and a board question gets answered on the spot instead of "next week."