Skip to content

Spreadsheet Cleanup Agent

The agent fixes messy spreadsheets and shows every change before applying it.

Beginner10h1–2 people17/20 fit
TL;DR

Build Spreadsheet Cleanup Agent for small businesses and ngos in ~10h with 1–2 people. Stack: LLM + DuckDB + Next.js.

Why it wins: Plan-then-apply is a great agent safety pattern to show.

Build flow

01 · Problem
Messy data with duplicates and inconsistent formats breaks every report.
02 · Solution
The agent profiles columns, proposes fixes (dedupe, date formats, name casing, phone formats) as a reviewable plan and applies accepted changes.
03 · Build
  1. 1Load the sheet into DuckDB
  2. 2Detect issues
  3. 3Draft a fix plan
  4. 4Apply and export
04 · Demo
Load a messy donor list and accept the proposed plan.

MVP checklist

  • Column profiling
  • Fix plan
  • Preview diff
  • One-click apply

Tech stack

TechRole
LLMLanguage model
DuckDBIn-process analytics SQL
Next.jsFrontend + API routes

Reference repos

Open-source projects you can build on. Links checked 2026-10-31.

Related ideas

More AI Agents
  • The agent drafts grant applications from your past reports and the funder's criteria

    Intermediate18h1–3
    RAGLLMMarkItDown
    18/20
  • Turn one blog post into a thread, a LinkedIn post and a newsletter blurb

    Beginner10h1–2
    LLMVercel AI SDKNext.js
    16/20