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

Remove duplicate rows —including the ones Excel misses.remove duplicate rows from CSV Windows

CSVPrune collapses records by any key column keeping the first or last, catches near-duplicates with a similarity engine, and saves the decision as a step that runs identically next time. Fully local.

CSVPrune removes exact duplicate rows or collapses records by any key keeping first or last, flags near-duplicates for review, and saves the choice as a replayable step.

$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

Merged exports and re-sends leave the same person in your file three times.

Pull data from two sources, append last month's list, or re-download after an edit and duplicates pile up — sometimes identical rows, more often the same customer with a newer email or a different capitalization. Counting, reporting, and emailing off that file all go wrong.

Where tooling usually breaks

Excel's "Remove Duplicates" only catches the easy half.

The built-in tool matches whole exact rows, so it misses records that differ by one stray space or a changed phone number, and it gives you no way to keep the most recent entry for each key. Near-duplicates slip straight through.

Where CSVPrune lands

Dedupe by any key, keep the row you want, catch the fuzzy ones.

CSVPrune removes exact duplicate rows or collapses records by the key columns you choose — email, order ID, anything — keeping the first or last occurrence. A similarity engine surfaces near-duplicates (token, phonetic, and edit-distance matches) for review, and every decision becomes a replayable step so the same de-duplication runs identically on the next import.

$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 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 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 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

Exact, key-based, and fuzzy de-duplication without the spreadsheet guesswork

Duplicates come in three flavours, and a spreadsheet only really handles the first. Exact duplicates are whole rows that match byte for byte; key duplicates are records that represent the same entity — the same customer, order, or SKU — even when other columns differ; and fuzzy duplicates are the near-matches separated by a stray space, a changed phone number, or a slightly different spelling. Excel's Remove Duplicates covers exact rows and stops there. CSVPrune addresses all three. Exact de-duplication removes identical rows while keeping the first occurrence. Key-based de-duplication lets you choose any column or set of columns as the identity — an email, an order number, a composite key — and keep either the first or the last occurrence, which is how you collapse a re-exported list down to the most recent record per person. For the hardest cases, a similarity engine analyzes candidates using normalized-exact, token-overlap, phonetic, and edit-distance strategies, grouping likely matches for you to review rather than deleting them blindly. Every choice — the key, the keep strategy, the fuzzy decisions — is captured as a replayable step, so the same de-duplication logic runs identically the next time the file lands, and an audited export can record exactly which rows were removed for a compliance trail.

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

How do I remove duplicate rows from a CSV on Windows?

Open the file in CSVPrune and choose duplicate removal. You can remove whole rows that match exactly, or — more powerfully — collapse records by a key column such as email or order ID, keeping either the first or the last occurrence. A similarity engine can also surface near-duplicates that differ by a stray space or capitalization for you to review. The de-duplication is saved as a replayable step, so the same logic runs identically on your next export.

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. Open the CSV that makes Excel freeze — instantly. Fix the garbled export before it corrupts your data. Join two CSVs without fighting VLOOKUP.

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