# OpenRefine: how AI models rank it, November 2026

Gane Index, November 2026 Edition. Named in 18 judge labels across 3 categories by 10 of 14 models. Page: https://www.gane.ai/index/gtm/vendors/openrefine

## Standing by category

| Category | Share | Rank | Negative rate | Labels |
|---|---|---|---|---|
| [CRM data quality and deduplication](https://www.gane.ai/index/gtm/revops/crm-data-quality-and-deduplication/index.md) | 2% | 13 | 44% | 16 |
| [Data clean rooms](https://www.gane.ai/index/gtm/gtm-data/data-clean-rooms/index.md) | 0% | 51 | 0% | 1 |
| [Identity resolution](https://www.gane.ai/index/gtm/gtm-data/identity-resolution/index.md) | 0% | 83 | 0% | 1 |

## What the models said for it

- "use free OpenRefine for occasional bulk cleanup" (GPT-6 Luna, CRM data quality)
- "Best for developers/small teams: OpenRefine (data cleaning) or PrivacyGo Data Clean Room (open‑source collaboration)." (GLM 4.7 FlashX, Data clean rooms)
- "OpenRefine (Completely Free): Best if you want zero cost and can handle manual processes." (Grok 4.20, CRM data quality)
- "For technical teams on zero budget: OpenRefine for one-time cleanup of exported data" (Claude Haiku 4.5, CRM data quality)

## And against it

- "Free Manual Tools (OpenRefine, Excel-based solutions) ... These tools create a false sense of security." (Kimi K2, CRM data quality)
- "Avoid relying solely on manual export/import cycles using tools like Excel or OpenRefine" (MiniMax M2.5, CRM data quality)
- "OpenRefine is described as "Bulk deduplication and text normalization on exported CSV files" with the core limitations being "No CRM connection, no automation, no enrichment, learning curve required"" (Muse Glimmer 30B, CRM data quality)
- "free and open-source, but it requires manual exports/imports and technical effort, so it is less suitable for nontechnical users" (Perplexity Sonar, CRM data quality)

## By model

| Model | First choice | Alternative | Mention | Warning | Labels |
|---|---|---|---|---|---|
| Claude Haiku 4.5 | 0 | 1 | 0 | 0 | 1 |
| GPT-5.4 mini | 0 | 0 | 0 | 0 | 0 |
| Gemini 3.5 Flash | 0 | 1 | 0 | 0 | 1 |
| Perplexity Sonar | 0 | 1 | 0 | 3 | 4 |
| Grok 4.20 | 0 | 1 | 1 | 1 | 3 |
| Mistral Small | 0 | 1 | 0 | 0 | 1 |
| DeepSeek V4 Flash | 0 | 0 | 0 | 0 | 0 |
| Llama 4 Maverick | 0 | 0 | 0 | 0 | 0 |
| Qwen 3.7 Flash | 0 | 0 | 0 | 0 | 0 |
| Kimi K2 | 0 | 1 | 0 | 1 | 2 |
| GLM 4.7 FlashX | 0 | 2 | 1 | 0 | 3 |
| MiniMax M2.5 | 0 | 0 | 0 | 1 | 1 |
| GPT-6 Luna | 1 | 0 | 0 | 0 | 1 |
| Muse Glimmer 30B | 0 | 0 | 0 | 1 | 1 |

## Sources returned with these answers

The sites and pages cited by the answers that named OpenRefine, from 35 of the 35 answers that named it (only the models that return a source list).

### Domains cited

- g2.com: 24
- prospeo.io: 15
- gane.ai/index: 14
- coffee.ai: 12
- integrate.io: 11
- findymail.com: 10
- sourceforge.net: 10
- linkfinderai.com: 9
- techrepublic.com: 9
- cognism.com: 8

### Pages cited

- https://g2.com/categories/data-quality/f/crm: 17
- https://integrate.io/blog/top-10-data-cleansing-tools: 11
- https://linkfinderai.com/best-crm-cleaning-tools: 9
- https://prospeo.io/s/crm-data-cleansing-services: 9
- https://coffee.ai/articles/free-crm-data-cleanup-tool: 8
- https://findymail.com/blog/crm-data-quality: 8
- https://techrepublic.com/article/best-data-cleaning-software: 8
- https://g2.com/categories/data-quality: 7

## The company

OpenRefine; https://openrefine.org/. From Wikidata, fetched 2026-09-14.

## In its own words

What OpenRefine's own pages state, read 2026-10-05. Stated by the vendor, not checked by the index.

- Positioning: a powerful free, open source tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data. (https://openrefine.org/)
- For: everyone (https://openrefine.org/)
- Price stated: free (https://openrefine.org/)
- Free plan or trial: free (https://openrefine.org/)

## What it publishes

Every page openrefine.org exposes, read 2026-09-29: 1295 addresses. By kind, pages and the last 90 days:

- blog: 74 pages, 0 in the last 90 days, latest 2026-01-27
- conference or event: 1132 pages, 0 in the last 90 days, latest 2025-06-06
- Recent: 2026-01-27 blog: Fundraising 2025 campaign results https://openrefine.org/blog/2026/01/27/fundraising-2025-campaign-results
- Recent: 2025-12-17 blog: Year in review 2025 https://openrefine.org/blog/2025/12/17/year-in-review-2025
- Recent: 2025-10-01 blog: Annoucing store https://openrefine.org/blog/2025/10/01/annoucing-store
- Recent: 2025-08-20 blog: Antonin leaving https://openrefine.org/blog/2025/08/20/antonin-leaving
- Recent: 2025-06-10 blog: OpenRefine 2025 Barcamp https://openrefine.org/blog/2025/06/10/OpenRefine-2025-Barcamp
- Recent: 2025-06-06 conference or event: 2360 https://forum.openrefine.org/t/duplicating-rows-problem/2360

## Record

- Method: https://www.gane.ai/index/gtm/methodology
- License: CC BY 4.0. Cite as Gane Index, November 2026 Edition, www.gane.ai/index/gtm.