Taskbar Sentinel: back up your pinned apps & restore your taskbar in one click — on the Microsoft Store.
Guided workflow variation

Join two CSVs withoutfighting VLOOKUP.merge and enrich CSV files VLOOKUP Windows

CSVPrune loads a second reference file and enriches your data by key — or diffs the two — bringing the matching columns straight into your working set. Fast on big files, and entirely on your machine.

CSVPrune loads a second reference CSV and enriches your data by key VLOOKUP-style, or diffs the two files, bringing matching columns into your working set — fast and fully local.

$14.99 USD — Perpetual License

One-time purchase · Lifetime updates · Delivered via the Microsoft Store

Get it from Microsoft Store

Purchased and updated securely through the Microsoft Store. No account needed on our site, no subscription, and a Microsoft receipt for easy corporate expensing.

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

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

If this sounds like your week

The detail you need lives in a second file, and VLOOKUP is fighting you.

Your orders export has customer IDs but no names; the names are in a separate customers file. Stitching them together is the classic lookup problem — and on large sheets VLOOKUP is slow, fragile, and falls apart the moment a key has a stray space or the column order shifts.

Where tooling usually breaks

Spreadsheet lookups are brittle exactly when the data is big.

A mistyped range, a non-exact match, a re-sorted reference tab — any of these silently returns wrong values, and recalculating a lookup across hundreds of thousands of rows can lock the spreadsheet for minutes at a time.

Where CSVPrune lands

Load a reference file and enrich or diff in place.

CSVPrune lets you load a second reference CSV in the same session and enrich your data VLOOKUP-style — pulling matching columns in by key — or diff the two files to see what changed or is missing. The new columns join your working set immediately, ready to clean or export further, and the whole operation runs locally with the full datasets kept in the Rust backend.

$14.99 USD — Perpetual License

One-time purchase · Lifetime updates · Delivered via the Microsoft Store

Get it from Microsoft Store

Purchased and updated securely through the Microsoft Store. No account needed on our site, no subscription, and a Microsoft receipt for easy corporate expensing.

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 orders-without-names file

Your orders export lists customer IDs but no names, the names sit in a separate customers file, and stitching them with VLOOKUP keeps breaking on key mismatches and slows the sheet to a crawl.

You load the customers file as a reference in CSVPrune and enrich by ID, and the names and details join your orders instantly, ready to clean further or export.

The merged mailing list

You combined three sign-up exports and the same subscriber now appears multiple times with slightly different capitalization, so your count is inflated and people would get duplicate emails.

CSVPrune collapses the list by lowercased email, keeps the most recent row for each person, and flags the fuzzy near-matches for a quick review — leaving one clean record per subscriber.

The hand-off

Finance wants a formatted XLSX and an internal tool needs JSON, but Save-As keeps dropping leading zeros and the online converters want you to upload the file first.

CSVPrune exports the same cleaned data to XLSX and JSON locally with identifiers intact, and you save the conversion as part of the recipe so future hand-offs are one click.

Deep dive

Cross-file enrichment and diff without the VLOOKUP fragility

A lot of real work lives across two files rather than one: orders that reference customers, transactions that reference a chart of accounts, leads that reference a territory map. The spreadsheet answer is VLOOKUP or its newer cousins, and on small tidy data it is fine — but it grows fragile exactly as the data grows. A non-exact match returns the wrong row, a re-sorted reference tab breaks the formula, a key with a trailing space silently fails, and recalculating across hundreds of thousands of rows can lock the sheet for minutes. CSVPrune treats this as a first-class operation. You load a second reference CSV into the same session and either enrich — pull matching columns from the reference into your working set by a shared key — or diff the two files to see what is new, missing, or changed between them. The matching happens in the Rust backend against the full datasets, so it stays fast on large files, and the resulting columns join your working data immediately, ready to be cleaned, have formulas applied, or be exported. Like every other operation, an enrichment can live inside a recipe, so a recurring join — this week's orders against the current customer master — becomes a repeatable step rather than a formula you rebuild each time. It effectively turns CSVPrune into a lightweight, private data workbench for the everyday two-file problems that would otherwise mean a database or a brittle spreadsheet.

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

Learn more
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

Learn more
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

Learn more

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 sub-5MB 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 (<5MB 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 merge or VLOOKUP two CSV files together?

Yes. Load a second reference CSV into the same session and CSVPrune can enrich your data by a shared key — pulling matching columns from the reference into your working set — or diff the two files to see what is new, missing, or changed. The match runs in the backend against the full datasets, so it stays fast on large files where spreadsheet VLOOKUP slows down, and the enrichment can be saved in a recipe so a recurring join becomes a repeatable step.

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. Fix the garbled export before it corrupts your data.

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.

$14.99 USD — Perpetual License

One-time purchase · Lifetime updates · Delivered via the Microsoft Store

Get it from Microsoft Store

Purchased and updated securely through the Microsoft Store. No account needed on our site, no subscription, and a Microsoft receipt for easy corporate expensing.

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