If you find yourself doing the same Excel tasks over and over — merging files, cleaning data, building the same dashboard every month — I built something that might help: Kiolix Xel.

What it does

Kiolix Xel is a desktop app (Mac + Windows) that handles the mechanical side of Excel workflows. I prioritized two domains first because they came up most often in my own experience:

• SAP SD line data — order and sales line exports, aggregated into structured dashboards
• E-commerce purchase history — transaction data from online stores, unified and visualized

Beyond those domains, the core capabilities are:

• Consolidate multiple Excel files — union, merge, and join workflows with schema normalization across files that don't share the same column names
• Build dashboards automatically — KPIs, time series, breakdowns — generated from the structure of your data without manual configuration
• Export to HTML report, PDF, PPTX, or XLSX
• AI agent for batch operations (optional) — if you want it, you can describe a transformation in plain language ("remove duplicate rows by order ID", "stack these sheets by date") and the agent applies it across your dataset with a preview before anything changes. Works with a local LLM via Ollama (free, no data leaving your machine, though it needs reasonable hardware) or a cloud LLM you connect yourself (ChatGPT, Claude, or Gemini — your own API key). Skipping the AI entirely is fine; all other features work without it.

On data scale: tested up to 2 million rows. Excel's internal processing caps around 1 million rows, so for anything above that the processing runs in the app's embedded SQL engine on your machine.

All processing is local — no upload, no cloud pipeline for the analysis.

Free MS Store code

Kiolix Xel is a paid app, but I'm giving away a free MS Store code here in r/excel.

This is probably useful for you right now if:

• You regularly merge multiple Excel files from different sources
• You clean or standardize data before you can do any real analysis
• You rebuild the same dashboard or report on a recurring schedule
• You prepare presentation-ready output from raw data files

Redeem here: http://go.microsoft.com/fwlink/?LinkId=532540&mstoken=7WY69-P69T9-GDMM2-7279H-TDJFZ Code: 7WY69-P69T9-GDMM2-7279H-TDJFZ

Single-use — first to redeem it gets it. If it's already gone by the time you see this, comment or DM me and I'll send another.

If you're on Mac, the Mac App Store handles promo codes differently. DM me and I'll work something out.

Why I built this

A close friend mentioned they were still spending hours every week in Excel — not because they were behind, but because Excel is where operational data actually lives, and the friction is everything before the analysis: merging, cleaning, reshaping.

I've been a developer for over 16 years. A lot of that work involved taking raw data from various systems, normalizing it, aggregating it, and turning it into something a team could use. The teammates who worked with those outputs were genuinely appreciative, and while it wasn't the part of the job that paid extra, it was the part I found most satisfying.

If your specific workflow isn't supported yet, tell me — through the app's feedback or here on Reddit. The App Store and Microsoft Store review cycle adds some turnaround time, but I'll move as fast as I can.

Product page: https://xel.kiolix.com

Full disclosure: I built this. I've been following r/excel for a while and the problems here matched what I was building around. I'd rather put it in front of people who will actually use it than run paid ads.