ContextCleaner: see every entry in the Windows 11 right-click menu, and which app added it — on the Microsoft Store.
Guided workflow variation

Add the column the exportforgot — with a live formula.

CSVPrune previews calculated columns as a ghost column that updates as you type, using references, arithmetic, string logic, and helpers — then saves it as a replayable step. No spreadsheet drag-down, no script.

CSVPrune builds calculated columns with a live ghost-column preview and helper functions, then saves the formula as a replayable step that rebuilds on every future file.

Pay once. Own it forever.

One-time purchase on the Microsoft Store · No subscription · Instant install

Get it from Microsoft

Buy through the Microsoft Store—instant install, automatic updates, and a Microsoft receipt for easy expensing. No account needed on our site, and no subscription on Store purchases.

Full CSVPrune overview
One-time purchase No telemetry Local-first

windows · local-first · no telemetry · one-time purchase

If this sounds like your week

You need one more column the export didn't include — a full name, a margin, a flag.

Combining first and last into a display name, deriving profit from price and cost, or tagging rows that fail a rule are everyday needs. In a spreadsheet that means brittle formulas dragged down a million cells; in a script it means pulling in a developer for a five-minute job.

Where tooling usually breaks

Spreadsheet formulas don't travel, and scripts are overkill.

Excel formulas bog down on large files, break when columns move, and can't be reused on next week's export without rebuilding them. A one-off Python script solves it once but isn't something the rest of the team can run or repeat reliably.

Where CSVPrune lands

A live formula engine that becomes a saved, replayable column.

CSVPrune lets you write calculated columns with a real-time preview — a ghost column appears in the grid and updates as you type — using column references, arithmetic, string concatenation, if/then logic, and helpers like coalesce(), lower(), and trim(). The result is saved as a permanent step inside a recipe, so the same derived column rebuilds itself automatically on every future file and inside folder automation.

Pay once. Own it forever.

One-time purchase on the Microsoft Store · No subscription · Instant install

Get it from Microsoft

Buy through the Microsoft Store—instant install, automatic updates, and a Microsoft receipt for easy expensing. No account needed on our site, and no subscription on Store purchases.

Learn more about CSVPrune

windows · local-first · no telemetry · one-time purchase

What you get

Feature highlights

Opens what Excel chokes on

scroll, search, filter, and type-aware sort 100k+ row files instantly in a virtualized grid—no 1,048,576-row wall and no freezing.

Fixes broken exports

auto-detects and overrides delimiters (comma, semicolon, tab) and encodings (UTF-8/16, Latin-1) so CRM, Shopify, and Google Forms files stop arriving garbled—and leading zeros and long IDs are never silently mangled.

Deterministic cleaning pipeline

trim, normalize emails, find/replace (literal or regex), coerce numbers, currency, dates, and booleans, dedupe by any key column, and point-and-click prune rows—composed in the order you choose.

Live formula engine

create calculated columns with real-time preview and a ghost column in the grid, using column references, arithmetic, string functions, and helpers like coalesce()—saved as replayable steps.

Clean once, replay forever

save any sequence as a named recipe, apply it in one click, batch-run it across a folder, or point a watch folder at it so every new CSV is cleaned automatically.

Private by design

every row stays in local memory, with no cloud, no telemetry, and no network calls—auditable with Wireshark. Export to CSV, JSON, or XLSX, or run an audited export with a full before/after sidecar.

Especially when

  • Clean and dedupe messy CSV exports on Windows without uploading sensitive data to a web-based CSV cleaner
  • Open, search, and sort CSV files that are too large or too slow to handle in Excel
  • Fix CSV encoding and delimiter problems (UTF-16, Latin-1, semicolon, tab) that corrupt CRM, Shopify, and Google Forms exports
  • Replay the same cleaning steps on recurring files automatically instead of repeating them by hand every week

Who benefits

Real-world scenarios

The missing column

The export has FirstName and LastName but the import you are feeding needs a single FullName column, and you would rather not drag a fragile spreadsheet formula down hundreds of thousands of rows.

You type a short formula in CSVPrune, watch the FullName ghost column fill in live, and save it so the column is rebuilt automatically every time you process that report.

The Monday morning ritual

Every Monday you download the same report and run the identical cleanup — headers, test rows, dedupe, dates — entirely by hand, and it eats the first part of your week.

You save the sequence as a recipe and point a watch folder at your downloads, so each new export is cleaned and written out automatically the moment it lands.

The weekly tidy-up

A partner export arrives with trailing spaces, mixed-case emails, and a few blank rows every week, and you fix the same things by hand in a spreadsheet each time before anyone can use it.

You compose the trim, email-normalize, and row-prune steps once in CSVPrune, watch the live counts confirm the changes, and save it as a recipe so next week's file is a single click.

Deep dive

A formula engine that turns one-off math into a replayable step

Derived columns are one of the most common reasons people reach for a spreadsheet: a display name from first and last, a margin from price and cost, a flag for rows that fail a rule. The spreadsheet approach is a formula dragged down every row, which slows large files, breaks when columns shift, and has to be rebuilt by hand on the next export. A script solves it once but is not something a non-developer can rerun reliably.

CSVPrune gives you a live formula engine instead. As you type an expression, a ghost column appears directly in the grid and fills with real computed values from your data, debounced for responsiveness, with a preview of the first rows and keyboard-navigable autocomplete for column names. Expressions support column references (case-insensitive, tolerant of spaces and hyphens), arithmetic, string concatenation, comparisons and if/then/else logic, and production-grade helpers such as coalesce(), lower(), upper(), trim(), and len(). The important part is what happens when you commit: the calculated column is saved as a CalculatedColumn step in your recipe, so it is fully replayable. Apply that recipe to next week's file, run it across a folder, or hand it to a watch folder, and the derived column rebuilds itself every time without anyone retyping the formula. Evaluation is fast enough to stay interactive on tens of thousands of rows.

Trusted by pragmatic desktop users

Built for people who prefer tools that stay local.

Real workflows: focus timers that stay visible, batches that never leave the disk, and renames you can rewind.

Customer review 01

PinPoint: Always On Top saves me so much time as I can organize all my report materials without having to flip between windows or tabs. I love the fact that it is straightforward and simple.

Senior Accountant · Manufacturing Company · United States · PinPoint Reviewed About PinPoint
Customer review 02

I used to get so frustrated when my Taskbar would freeze and disappear. Taskbar Sentinel has eliminated that pain without subjecting me to another subscription.

Darren · Calgary, Alberta, Canada · Taskbar Sentinel Reviewed About Taskbar Sentinel
Customer review 03

OpticBatch and MetaForge are a lifesaver for me as a person with a passion for photography. They give me the ability to stay organized and keep personal information confidential when I post pictures online.

Sherri · United States · OpticBatch & MetaForge Reviewed Browse the full catalog

Quotes are shown with customer permission; names and locations appear as reviewers provided them.

Our Core Moat

Engineered to respect your system boundaries.

System Resource Monitor (Idle State Comparison)
Automata Labs low idle memory footprint compared to generic Electron applications

Lightweight Native Stack

Compiled Rust core wrapped inside an optimized Tauri shell. No heavy background node loops or duplicate Chromium engines cooking your memory footprint (<25MB idle RAM).

100% Local-First Privacy

Executes entirely on-device with full offline isolation. Absolute zero background telemetry policies, no metrics aggregation, and zero mandatory cloud-sync accounts.

Perpetual Fallback Licenses

Pay a single, clear one-time purchase price. Own your specific native software utility execution tier permanently without artificial subscription paywalls or ongoing usage tax.

FAQ

Straight answers—no glossary dump

Can I add a calculated column to a CSV without Excel formulas or a script?

Yes. CSVPrune has a live formula engine: type an expression and a ghost column appears in the grid, updating with real values as you type. You can reference other columns, do arithmetic and string concatenation, use if/then/else logic, and call helpers like coalesce(), lower(), and trim(). When you commit, the calculated column becomes a saved, replayable step in a recipe, so it rebuilds automatically on future files and inside folder automation — no dragging formulas, no separate script.

Is CSVPrune private, and does it work offline?

Yes on both counts. CSVPrune runs entirely on your machine with no cloud, no telemetry, and no network access of any kind — there is no networking code in the app, so it works fully offline and nothing you load is ever uploaded. Your data stays in local memory for the session, and only minimal settings such as window state and recent paths (which you can turn off) are saved to disk. You can verify the zero-network behaviour with a connection monitor.

What file types and sizes does CSVPrune handle?

CSVPrune loads CSV files with comma, semicolon, or tab delimiters (auto-detected, with a manual delimiter and encoding override for UTF-8, UTF-16, and Latin-1) and is designed for large files, with smooth performance on hundred-thousand-row datasets and guidance up to around 500 MB. You can export your cleaned data to CSV, JSON, or XLSX, copy it to the clipboard, or use an audited export that adds a full before/after sidecar for compliance.

How much is CSVPrune, and is it a subscription?

CSVPrune is a one-time purchase on the Microsoft Store — no subscription and no account required to use it. You own the version you buy and it keeps working offline. Use the Microsoft Store button on this page for the current listing and price, and because the privacy posture is structural rather than a setting, you can verify the local-only behaviour yourself at any time with a network monitor.

Related pages

Clean the messy export in one repeatable pass. Remove duplicate rows — including the ones Excel misses. Open the CSV that makes Excel freeze — instantly. Clean sensitive CSVs without uploading them anywhere.

Clean it once.
Replay it forever—on your machine.

CSVPrune opens the files that break Excel, fixes encoding and delimiter garble, dedupes by any column, builds calculated columns with a live formula engine, and saves your steps as a replayable recipe. Export to CSV, JSON, or XLSX. No cloud, no telemetry—verifiable with Wireshark.

Pay once. Own it forever.

One-time purchase on the Microsoft Store · No subscription · Instant install

Get it from Microsoft

Buy through the Microsoft Store—instant install, automatic updates, and a Microsoft receipt for easy expensing. No account needed on our site, and no subscription on Store purchases.

Open full product page

Technical specifications

Technical specifications for procurement

Spec Implementation
Data Sovereignty Every row stays in local Rust in-memory state for the session; the full dataset never crosses to the cloud and is serialized only for your explicit export or clipboard copy
Telemetry Status None; zero network code, verifiable with Wireshark or Resource Monitor
Core Runtime Rust + Tauri v2 backend (heavy CSV parsing, cleaning, and profiling stay in Rust) with a React 18 virtualized grid
Network Requirements Fully functional offline; no network access requested in the Tauri capability set
Deployment Compatibility Windows 10 and 11 via the Microsoft Store; macOS universal build via direct download
Import Auto-detects comma, semicolon, and tab delimiters; manual delimiter and UTF-8/16 + Latin-1 encoding override
Cleaning ops Trim, normalize emails, find/replace (regex), coerce number/currency/date/boolean, dedup-by-key, visual row prune, calculated columns
Automation Saved recipes, batch-run across a folder, and watch-folder auto-clean of new files
Export CSV, JSON, or XLSX, plus audited export with a full before/after sidecar JSON; ~500 MB file ceiling