
AutoTable: My One-Click Spreadsheet Cleaner Built with Google Gemini
This is a submission for the Built with Google Gemini: Writing Challenge What I Built with Google Gemini I built AutoTable , a high-efficiency, one-click spreadsheet cleaner designed for knowledge workers who are tired of manual data sanitization. It's a specialized SaaS application that transforms messy, inconsistent tabular data (CSV, Excel) into validated, ready-to-use formats. The Problem: Knowledge workers spend hours fixing inconsistent headers, mixed data types, stray whitespace, and duplicate rows. Most users don't want to write complex Excel macros or Python scripts—they just want a fast, trustworthy way to get a clean table. The Solution: AutoTable handles the heavy lifting with a multi-stage, idempotent transformation pipeline. It features: Header Normalization : Standardizing messy columns into uniform snake_case. Smart Type Detection : Coercing chaotic strings into proper Numbers, Booleans, or Dates. Fuzzy Deduplication : Identifying nearly-identical records using similari
Continue reading on Dev.to
Opens in a new tab

