Data Utilization for Nonprofits — Practical Steps Any Small Organization Can Start Today

Introduction

Activity reports get written every year. Yet most people working in nonprofits and social-impact organizations share the same nagging doubt: do funders and government partners actually grasp what the numbers mean?

Reporting to supporters, applying for grants, collaborating with government agencies—at every turn, organizations are now expected to demonstrate accountability for results. What fundamentally strengthens that capacity for explanation is data utilization.

The reality, however, is sobering. As the Japan NPO Center (JNPOC; 日本NPOセンター) has repeatedly documented in its surveys on IT adoption among nonprofits, barriers of talent, cost, and organizational culture continue to hinder data utilization across the nonprofit sector. Government partners increasingly expect organizations that can "speak with data," yet frontline operations have not kept pace. How can this gap be closed? The following sections lay out practical steps that even a small nonprofit can begin today.

---

Barriers to Data Utilization in Nonprofits

Lack of Specialist Talent

"We don't have anyone who can analyze data"—this is the single most frequently cited challenge in the nonprofit sector. Staff may be competent with spreadsheets but unfamiliar with statistics; a system may have been procured but never properly adopted. The shortage of digital talent that plagues even large corporations manifests far more acutely in the nonprofit sector.

That said, it is worth discarding the assumption that nothing can begin without hiring a data scientist. Data utilization at the level of a program manager running aggregations in Google Sheets already constitutes a meaningful first step.

Cost and Competing Priorities

When personnel costs, rent, and program expenses leave budgets stretched thin, allocating resources to "building a data infrastructure" is difficult. For organizations consumed by the demands of day-to-day operations, data readiness tends to be perpetually deferred.

However, the combination of Google Forms, Google Sheets, and Looker Studio is free within their standard feature sets. An end-to-end pipeline from data collection to visualization can be established with zero initial investment.

Absence of a "Data Culture"

In organizations where activities are driven by intuition and passion, the very act of collecting numbers can be perceived as "managerial" or "bureaucratic." This barrier tends to be highest in organizations that still carry the founding team's original fervor.

The key is to reframe data not as a tool of management but as a language for articulating mission. Being able to show, in numbers, how many lives a program has changed can reinforce—not diminish—pride in the work.

---

Steps for Data Utilization

Collection — Deciding What to Measure

The first question is: "What would we need to measure for our impact to be convincing?" This is where outcome indicators become essential. "Number of participants" is an output; "behavioral change among participants" is an outcome.

Candidate measurement targets include the following:

• Changes in beneficiary status (pre- and post-intervention surveys)
• Service retention and dropout rates
• Stakeholder satisfaction
• Cost per unit of outcome

The critical point is to resist the temptation to measure everything at once. Start by selecting one or two "core indicators" and building a sustainable collection mechanism around them.

Organization — Structuring Data for Use

Raw data, as collected, is not ready for analysis. Input rules must be standardized, duplicates removed, and the data structured in a form amenable to analysis.

Responses collected via Google Forms flow automatically into Google Sheets. Standardizing column names, aligning date formats, and clearly separating free-text responses from multiple-choice entries—this painstaking organizational work determines the accuracy of subsequent analysis.

A common failure pattern is allowing years of data to accumulate in inconsistent formats, making retrospective aggregation impossible. Defining a clean format at the collection-design stage yields substantial long-term efficiency gains.

Analysis — Reading Patterns

Analysis need not involve advanced statistics. The kinds of reading that are practically useful for nonprofits include:

• Time-series comparisons (Did participation increase compared to the same month last year?)
• Attribute-based breakdowns (What differences emerge by age group, region, or referral channel?)
• Correlation observation (Do more frequent participants show higher retention rates?)

With Looker Studio, spreadsheet data can be automatically visualized as charts. Creating a dashboard and establishing the habit of reviewing it at monthly meetings prevents data from "lying dormant and unused."

Application — Informing Decisions and External Communication

This stage connects analytical findings to actual decision-making and communication.

Internal application includes using data as the basis for decisions to continue, improve, or discontinue a program. When data shows that participant satisfaction has declined for three consecutive months, the resulting conversation is far more constructive than one based on impressions alone.

External application encompasses grant reports, supporter newsletters, and website content. A sentence such as "This period we reached XX beneficiaries, of whom YY% reported an improvement in their situation" simply cannot be written without numbers.

---

Low-Cost Implementation: Getting Started with Google Tools

A concrete implementation example follows. The cost of adoption is zero; all that is required is a Google account.

Designing a Beneficiary Survey (Google Forms)

Create a form that asks about the beneficiary's status before and after receiving services. "Rate your current level of difficulty on a five-point scale (pre-intervention)" followed by the same question post-intervention constitutes the simplest form of outcome measurement. Responses are automatically exported to Google Sheets.

Building a Monthly Dashboard (Looker Studio)

Connect a Google Sheets file as a Looker Studio data source. Create charts showing "monthly participant trends," "demographic composition," and "satisfaction score time series." Sharing the URL alone gives stakeholders real-time access to updated information.

Leveraging CANPAN

CANPAN (CANPAN), a nonprofit information disclosure platform provided by the Nippon Foundation (日本財団), is a free tool for accumulating and publishing financial information and activity reports. It serves the dual purpose of ensuring external transparency and organizing the information necessary for obtaining certified nonprofit status (認定NPO法人).

---

Common Threads in Successful Cases

What the leading data-utilization examples among Japanese nonprofits share is an ethos of "start small and sustain."

According to analysis in the "Giving Japan" white paper published by the Japan Fundraising Association, among certified nonprofit organizations (認定NPO法人), the top tier raising over 10 million yen in annual donations (22.6% of the total) accounts for 92.4% of total donation volume. One factor driving this concentration is communication design grounded in data. Organizations that have established a cycle of visualizing impact and conveying it to supporters are better positioned to build long-term donor relationships.

Even for smaller organizations, carefully analyzing data from a single survey and communicating "before and after" stories in a newsletter can meaningfully change supporter engagement. The starting point is not a perfect system but the steady accumulation of small evidence.

---

Structural Challenges — Institutional and Environmental Barriers to Data Utilization

Attributing the slow pace of data utilization among nonprofits solely to a lack of effort by individual organizations captures only half the problem. Behind the surface lie structural challenges affecting the sector as a whole.

First, fragmentation of information disclosure infrastructure. The Cabinet Office's NPO corporation portal (内閣府NPO法人ポータル), disclosure data maintained by individual supervisory agencies, and voluntary disclosures on CANPAN remain unintegrated. No mechanism exists for nonprofits themselves to manage and utilize their own data across these platforms. According to the Cabinet Office's "Survey on the Status of NPO Corporations and Use of the Certified NPO System" (2023), among roughly 50,000 NPO corporations, the proportion that electronically disclose their activity reports remains limited; standardization and machine readability of data are identified as ongoing challenges.

Second, insufficient capacity of intermediary support organizations (中間支援組織). The number of intermediary organizations equipped to support data utilization is limited, particularly in rural areas. The concentration of technical support resources in major metropolitan areas produces a digital divide within the nonprofit sector analogous to broader patterns of regional inequality.

Third, a mismatch between grant design and data utilization needs. Most grants are tied to single-year project plans, making it difficult to allocate funding to medium- to long-term investments such as "data infrastructure development" or "building an evaluation system." The irony is that the very structure that prevents investment in impact-measurement systems perpetuates the inability to fulfill accountability for results.

These structural challenges are not the kind that individual nonprofits can resolve by adopting free tools. The broader context—namely the trend toward evidence-based policymaking (EBPM; エビデンスに基づく政策立案) that is driving the expectation for data-informed collaboration with government—is explored in detail in the Introduction to EBPM. While the starting point for data utilization lies in the practice of individual organizations, building the ecosystem that supports that practice is the challenge facing the sector as a whole.

---

For nonprofit practitioners, data utilization is not a technology problem. It begins with a design question: "What do we define as impact?" and "Who do we want to reach, and with what message?" It is, in other words, a question of mission articulation. Start by choosing just one indicator from your organization's activities. One Google Form, one spreadsheet. That is enough to begin today.

For related practical methods, see also How to Build a Logic Model, How to Draw a Stakeholder Map, and Designing Collective Impact.

References

Survey on the Status of NPO Corporations and Use of the Certified NPO System

Cabinet Office. Cabinet Office NPO Homepage

Read source

Survey on IT Utilization among Nonprofit Organizations

Japan NPO Center (JNPOC). Japan NPO Center

Read source

Giving Japan 2024

Japan Fundraising Association. Japan Fundraising Association

Read source

Research on Promotion of Statistical Data Utilization

Statistics Bureau of Japan. Ministry of Internal Affairs and Communications

Read source