Open Data Editor

Open Knowledge Foundation
United Kingdom of Great Britain and Northern Ireland

About

Launched: 2023
Record Updated: Dec 09, 2025
Data collection or management tool
Open Data Editor (ODE) is a free, open-source tool designed to help nonprofits, data journalists, activists, and public servants detect errors in their datasets. It is designed for people working with tabular data (Excel, Google Sheets, CSV) who don't know how to code or don't have the programming skills to automatize the data exploration process, and therefore spend much more time than they would like checking their datasets for possible errors and correcting them, before they are finally ready to move to the part of work which is actually interesting for them.

Mission

The technical mission of the Open Data Editor (ODE) developed by the Open Knowledge Foundation is to provide a free, open-source, no-code, cross-platform desktop application that empowers non-technical users working with tabular data to quickly detect and correct errors, enforce data-validation and metadata standards (notably the FAIR principles), and output clean, interoperable datasets ready for publication—while preserving privacy (local-first architecture), remaining lightweight (suitable for low-resource or offline contexts), and employing open standards (e.g., the Frictionless Data specifications) for maximum reuse and integration.

Key Achievements

Over the past year, the Open Data Editor has achieved several important milestones that reflect meaningful technical and organisational progress. First, the project was formally recognised by the Digital Public Goods Alliance, underscoring its maturity, openness and global public-interest value. Second, the introduction of AI-assisted data-quality features has significantly expanded the tool’s capabilities, enabling faster identification of anomalies, smarter suggestions for corrections, and improved handling of large, dense datasets while retaining a privacy-preserving, local-first design. Third, the project has strengthened its learning ecosystem through the expansion of its multilingual educational resources, including a comprehensive online course and integrated in-app learning tools, which together support non-technical users in adopting better data-cleaning and metadata practices.

Technical Attributes

Maintenance Status

Actively Maintained

Open Code Repository

Implemented

Technical Documentation

Implemented

Code License

Implemented

Open Product Roadmap

In Progress

Technical Attribute Statements

Programming Languages

  • python

Technology Readiness Level

  • Actual system proven in operational environment

Code Licenses Used

  • MIT License

Content Licensing

  • Creative commons licenses

Standards

Metadata

  • Linked Data Design Principles

Community Engagement

Code of Conduct

Implemented

Community Engagement

Implemented

Community Statements

User Contribution Pathways

  • Contribute to user research or user testing

Community Engagement Activities

  • Blogs
  • Community calls
  • Social media
  • Webinars and training

Policies & Governance

Governance Summary

Open Data Editor is a project of the Open Knowledge Foundation (OKFN), a not-for-profit organization incorporated in England & Wales.

Policies

Privacy Policy

Implemented

Governance Records

Implemented

Governance Structure & Processes

Implemented

Policy Statements

Board Structure

  • Advisory board or steering committee

Board Level

  • Provider

Community Governance

  • Formal

Additional Information

Organizational History

The Open Knowledge Foundation created the Open Data Editor (ODE). Initial development began around 2021–2023, with a beta release that aimed to help users detect errors in tabular datasets. However, early versions were overly complex and challenging for intended users to adopt. After recognising that the design process relied too heavily on technical assumptions and too little on the lived realities of journalists, researchers and public-sector workers, OKFN rebuilt ODE collaboratively with real communities. This redesign focused on clarity, simplicity, local-first privacy, and genuinely accessible language. Through extensive pilot projects across multiple countries, the tool evolved into a lightweight, stable and intuitive desktop application used by audiences working with large and messy datasets.

Organizational Structure

Business or Ownership Model

Non-profit organization

Full-time Staff

11-20

Volunteers

More than 20

Non-profit Status

Company limited by guarantee

Current Affiliations

Digital Public Goods Alliance, Open Knowledge Brazil, Open Knowledge Nepal, Escuela de Datos help disseminate the tool.

Funding

Primary Funding Source

  • Program service revenue

Funding Needs

While the tool itself is stable, it is at a pivotal moment. Funding will help with integrations and expand its utility across the data ecosystem, as well as the development of integrations with standards-based infrastructures (e.g., Frictionless Data, open-data portals, metadata pipelines) and the expansion of multilingual training assets and in-app learning tools to improve user adoption in low-resource contexts. Support will also allow us to generalise ODE’s design principles—simplicity, lightweight deployment, offline capability—to new complementary tools addressing other stages of the data lifecycle. Finally, additional resources could accelerate the formalisation of open governance, contributor pathways and inclusive community processes, which are now developed as the limited resources we have access to permit, but are fundamental for ensuring long-term sustainability and a stewarship reflecting our values.