EDI
An AI spreadsheet that runs on your own machine.
~/projects/edi $ glow README.md
Why I built it
Two years as an analyst meant two years in Excel, the worst software known to mankind. A billion dollar company, by the way. I lost work countless times because autosave was on holiday, stared at the screen while simple macros ran, and watched big datasets lock the whole thing up.
I couldn't just throw the file at an AI tool either. Company policy: you don't paste client data into a website. Fair enough. So I went all local and built something for myself. It started as EDIMA, Excel Doesn't Interest Me Anymore. The idea: my data, my model, my machine.
I thought it was my magnum opus. Things have changed since, so it's open source now. Go nuts.
What it does
- Ask a CSV or Excel file things in plain English: filter it, clean it, chart it, write formulas for it.
- No sign-up and no API key. Clone it, point it at a model, and the whole thing runs on localhost.
- You pick the model: Ollama by default, or LM Studio, vLLM, OpenRouter, Claude, OpenAI, Gemini or Groq.
How it's built
- Two modes. A simple question compiles to one SQL query; a complex one goes to a LangChain ReAct agent that queries and refines over several turns.
- The FastAPI backend is stateless: every request rebuilds an in-memory SQLite database from the stored sheet, cached on a hash of the rows.
- Charts come back as data (type, axes, series) and render in the browser with Recharts, not as images.
Decisions worth noting
- With a hosted model, it says exactly what leaves the machine: the question, recent messages, column names and at most 200 rows.
- Keys are never sent back to the browser. There is only an endpoint that reports whether one exists.
"dependencies": ["Next.js", "FastAPI", "LangChain", "SQLite", "Univer", "Recharts"]