Open Data Editor
Open Data Editor: A focused open-source editor for validating, correcting, and documenting tabular files. Ranked #19 of 26 in Data Preparation Software by our editors (6.4/10); pricing: Free plan; best for free validated tabular editing.
At a glance
- Editor score6.4 / 10
- PricingFree plan
- Best forFree validated tabular editing
- Free planYes
- Paid fromFree
- DeploymentDesktop
- Founded2004 · London, England, United Kingdom
- Facts checked20 Sep 2026
Where it wins
- Free, open-source desktop app for Windows, macOS, and Linux
- Frictionless validation highlights problematic cells and reports errors
- Local AI explains columns and suggests analysis questions
Where it doesn't
- No verified workflow automation or scheduled data preparation
- Export is centered on CSV and Excel files
- Desktop deployment may not suit browser-first collaboration
Our verdict on Open Data Editor
Open Data Editor is a free, open-source desktop application for nonprofits, data journalists, activists, and public servants who work with tabular data. It imports Excel and CSV files, folders, Google Sheets, GitHub sources, open data portals, and online tables. Users can inspect and edit datasets, update metadata, validate tables with Frictionless validation rules, and export corrected or error-marked files. It runs on Windows, macOS, and Linux, with a local-first approach intended to preserve privacy.
Validation is the product’s clearest strength. Problematic cells are highlighted, an errors report describes issues, and validation can be triggered when a file is saved. Excel exports can include the data, error descriptions, and blank rows, while CSV export supports a simpler tabular output. This makes Open Data Editor a practical fit for reviewing quality problems before publication or analysis, especially when a team needs visible error context rather than a purely technical validation result. Metadata editing also helps users document a table alongside its contents.
The optional AI features stay focused on local assistance: local models can explain table columns and generate suggested analysis questions from table data. That adds a useful interpretive layer without changing the product’s central role as a desktop preparation tool. Open Data Editor is a strong choice for free, validated editing across common tabular formats and public-data workflows. Choose another product if scheduled preparation, verified workflow automation, or a broader automation layer is essential.
Your product? Our editors can test Open Data Editor in depth and publish a review, labelled as paid · from $149/mo →
Open Data Editor pricing
Open Data Editor fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Data profiling | Not verified |
| Visual workflows | Not verified |
| Deployment | Desktop |
| Scheduled runs | Not verified |
| Source connectors | Not verified |
| Row limit | Not verified |
| Deployment | Desktop |
| Platforms | Windows, macOS, Linux |
| Support | Email, Community, Docs |
| Built for | Solo, Small business, Mid-market (editorial estimate) |
| Integrations | 4 integrations: Google Sheets, GitHub, open data portals, Frictionless Framework |
| Pricing | Free plan |
| Website | okfn.org |
| Facts checked | 20 Sep 2026 |
Open Data Editor integrations
Open Data Editor lists 4 integrations on its own site.
- Google Sheets
- GitHub
- open data portals
- Frictionless Framework
Alternatives to Open Data Editor
- Alteryx DesignerA capable visual preparation suite for enterprises, priced for committed teams.9.2
- Amazon SageMaker Data WranglerA capable AWS-centered workspace for preparing and analyzing machine-learning data.9.1
- AWS Glue DataBrewA capable AWS-native choice for visual preparation, profiling, and scheduled data jobs.9.0
See all Open Data Editor alternatives →
Used Open Data Editor? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Open Data Editor for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Open Data Editor is listed in our Data Preparation Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/open-data-editor/"><img src="https://www.itechguides.com/best/badge/open-data-editor.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update