Target 9.5: Enhance scientific research and upgrade technological capabilities in developing countries. Target 9.c: Significantly increase access to information and communications technology. ODE Contribution: By offering a low-barrier, open-source tool for data validation, ODE empowers research teams, public institutions, and community organisations to work with structured data efficiently. Because it can work offline, it is ideal to be used in a low-resource country, which may be subject to power shortages and internet shutdowns. Also, being a lightweight application, it can be used on any machine. It supports inclusive innovation by enabling non-technical users to improve their data workflows without requiring complex infrastructure or advanced programming skills. Target 11.3: Enhance inclusive and sustainable urbanization and capacity for participatory, integrated human settlement planning. Target 11.6: Reduce the environmental impact of cities, including through improved data on air quality and waste. ODE Contribution: Open Data Editor is a practical tool for improving environmental data management and supporting inclusive urban planning. In Nairobi, Kenya, the Demography Project used ODE to harmonize air quality datasets collected from multiple sensors, covering pollutants, humidity, pressure, and GPS coordinates. What once took months to clean and prepare was reduced to seconds, as ODE automatically flagged inconsistencies like alphabetic characters in numeric fields and other structural errors. This allowed the team to generate a clean, unified spreadsheet that could be reliably used for street-by-street analysis of urban air quality, revealing patterns relevant to both national regulations and WHO standards. See: https://blog.okfn.org/2025/04/28/open-data-editor-use-case-a-giant-spreadsheet-of-environmental-data-now-accurate-for-analysis/ In Zagreb, Croatia, city officials found ODE instrumental in simplifying the analysis and validation of open datasets related to public infrastructure and city services. Features like schema navigation and file pagination helped them efficiently work with large files, making the process of producing and publishing quality data much faster and more consistent. See: https://blog.okfn.org/2025/05/20/open-data-editor-in-action-streamlining-data-governance-and-unlocking-the-potential-value-of-urban-data-in-croatia/ These real-world examples show how Open Data Editor helps small teams in urban contexts create clean, FAIR-compliant data, enabling more transparent, participatory, and evidence-based decision-making for sustainable cities and communities. Another example worth noting from Nepal on municipal data cleaning: https://blog.okfn.org/2025/06/24/how-open-data-editor-improves-our-local-government-data-practices/ Target 16.6: Develop effective, accountable, and transparent institutions Target 16.10: Ensure public access to information and protect fundamental freedoms ODE Contribution: Open Data Editor contributes to more transparent and effective public institutions by simplifying the process of cleaning, validating, and documenting public datasets. In practice, this means making it easier for governments and civic organizations to produce data that is consistent, trustworthy, and reusable. A clear example comes from our pilot work with local governments in Nepal, where ODE has been adopted to improve the quality of datasets related to electoral archives, environmental monitoring, and infrastructure management. Public servants reported that using ODE helped them identify errors and inconsistencies that had long gone unnoticed, significantly increasing confidence in their own data. One team described the experience as having “rekindled the spark” in their work, restoring trust in both their processes and the data they produce. The ability to work offline and with a simple interface also made ODE especially well-suited for low-resource environments. Through these real-world use cases, Open Data Editor is not only improving local data quality but also embedding open data standards into institutional workflows. This strengthens public access to information, supports civic participation, and enhances the integrity and accountability of public institutions, advancing the core aims of SDG 16.
