Extract From Excel
Clean messy Excel data. Without fighting Excel.
3 followers
Clean messy Excel data. Without fighting Excel.
3 followers
This is a lightweight web app for one-off data cleanup tasks in Excel or CSV files. It’s designed for those moments when you’re handed a messy spreadsheet and just need a clean result—once. Instead of building formulas or workflows, you paste raw text, describe what you want, and let AI extract, summarize, or classify the data. Ideal for individuals and small teams handling occasional, unstructured data without overengineering.
This started as a small script to clean a messy CSV for a friend. She received an Excel file listing company stores, but in some rows the store name also contained part of the address. She needed those addresses separated into their own column.
I exported the file as a CSV and wrote a script using an LLM to extract the address text and place it into a new column. Later, I turned that script into a web app.
The app is meant for one-off data cleanup, extraction, and classification tasks. I chose an LLM that’s slightly more capable than handling simple cases like extracting a city from an address or a year from a date, so it can also handle generalization tasks such as summarizing pain points from a column of user feedback.
It currently runs on Cloudflare AI Workers’ free plan, so usage is limited per user. I also use the TOON format to reduce token usage.