Article

Using ChatGPT to clean data: an experiment

Roberto Rocha · robertorocha.info

A data journalist's controlled experiment showing exactly where AI cleaning fails.

Open on robertorocha.info ↗

The question it answers

  1. Can AI clean up my messy data: duplicates, formats, and half-filled columns?

Read with it

  1. OpenAI's own recipe, including keeping the original file untouched while writing a cleaned copy. learn.chatgpt.com Guide Clean and prepare messy data (official use case) OpenAI
  2. Video How to Clean Up Messy Data in Minutes with Claude AI (Excel) p2automation
  3. Video How CFOs Are Cleaning Messy Excel Data with AI: 3 Methods, Zero Manual Work Christian Martinez (AI for Finance)
  4. Video AI in Spreadsheets: How to Clean Data, Translate, Classify at Scale The GRAPH Courses
  5. Video Julius AI: From Messy Data To Clean Report NeuralNine
  6. Video Watch me CLEANING DATA with SQL & AI in minutes Jess Ramos
eChai Partner Brands The partnership →