tanaka-lusengo/tidy-ai

A lightweight spreadsheet cleaning tool powered by AI. # Tidy AI AI-powered spreadsheet cleaning and merging tool. Upload messy CSV, TSV, or Excel files — Tidy AI analyses data quality issues, maps columns across files into a unified schema, and produces clean, merged output ready for download. Built with Next.js 16, React 19, and Anthropic Claude via the Vercel AI SDK. ## Features - **Multi-file upload** — Drag-and-drop CSV, TSV, XLSX, or XLS files (up to 10 MB each) - **AI-powered analysis** — Detects data quality issues (missing values, inconsistent formats, duplicates, type mismatches) and generates a unified column schema across files - **Interactive schema editor** — Rename columns, change types, toggle inclusion, and review AI-proposed transformations before cleaning - **Clarifying questions** — The AI asks up to 3 questions to resolve ambiguities in your data - **Batched cleaning** — Large datasets are processed in parallel batches for speed and reliability - **Export options** — Download cleaned CSV, generate a styled PDF report, or copy a draft email summary ## Prerequisites - Node.js 22.x - pnpm 10.x ## Getting Started 1. **Install dependencies:** ```bash pnpm install ``` 2. **Start the dev server:** ```bash pnpm dev ``` 3. **Open** localhost in your browser. ## Environment Variables | Variable | Required | Description | |----------------------|--------------|-------------------------------------------------------| | `AI_GATEWAY_API_KEY` | Yes | Vercel AI Gateway key (authenticates with the gateway) | | `ENABLE_BYOK` | No | Set to `"true"` to enable Bring Your Own Key mode | | `ANTHROPIC_API_KEY` | Only if BYOK | Your Anthropic API key for direct billing | By default, the app routes AI requests through the Vercel AI Gateway. Create a `.env.local` file with your gateway key: ```env AI_GATEWAY_API_KEY=your-gateway-key-here ``` To use your own Anthropic API key instead (BYOK mode), add …