✦ No subscription — pay once, use forever

Clean messy CSV files
in minutes, not hours

DataMend removes duplicate rows, trims whitespace, standardizes dates, and transforms your data — no Excel formulas required.

Buy DataMend — £13.99 ↗ See all features

✓ One-time purchase   ✓ Windows, macOS, Linux   ✓ 14-day money-back guarantee

📂 Open CSV ↩ Undo ↪ Redo 💾 Save Recipe ⬇ Export
Clean
✓ Trim Whitespace
✓ Remove Duplicates
Remove Empty Rows
Fill Empty Cells
Text
✓ Change Case
Find & Replace
Columns
Rename Column
Split Column
Merge Columns
Dates
✓ Standardize Dates
# Name Email Signup Date Country Revenue
1Alice Smith[email protected]2024-01-15United States1,240.00
2Bob Jones[email protected]2024-01-22Canada895.50
3Carla Reyes[email protected]2024-02-03Mexico2,100.00
4David Kim[email protected]2024-02-14South Korea450.00
5Eva Müller[email protected]2024-03-01Germany1,780.00
6Frank Chen[email protected]2024-03-08Hong Kong3,200.00
7(empty)(empty)(empty)Australia(empty)
8Grace Park[email protected]2024-03-19South Korea670.00
Email
TypeText
Total rows8
Non-empty7
Empty/null1
Unique7
Avg length18.4 chars

Applied (3)
1. Trim whitespace
2. Remove dupes
3. Std. dates
Offline & private — your data never leaves your computer  ·  No subscription — pay once, own it forever  ·  All platforms — Windows, macOS, Linux

Everything you need. Nothing you don't.

DataMend is focused on one thing: getting CSV data clean and consistent as fast as possible.

One-click operations

Common cleaning tasks — trim whitespace, remove duplicates, change case, fix dates — are a single click. No formulas, no macros, no hunting through ribbon menus.

🔁

Reusable recipes

Save your sequence of operations as a recipe file. Next week, when you get the same export, load the recipe and clean it in 5 seconds instead of 30 minutes.

📊

Column statistics

Click any column header to instantly see: total rows, empty count, unique values, min/max/mean for numbers, most common values for text. Know your data before you clean it.

Full undo / redo

Every operation is non-destructive until you export. Step back through 50 operations. Explore changes freely without fear of breaking anything.

🔐

Completely offline

Your data stays on your machine. No cloud upload, no account required, no internet connection needed. Works on air-gapped machines. Safe for confidential data.

📁

Smart encoding detection

DataMend automatically detects UTF-8, Latin-1, Windows-1252, and other encodings. Open that "broken" export without manually converting first.

15 powerful operations, zero learning curve

✂️
Trim Whitespace Remove leading/trailing spaces from all text cells
🔍
Remove Duplicates Delete rows with identical values (choose which columns to compare)
🗑️
Remove Empty Rows Delete rows where every cell is blank
📋
Remove Empty Columns Delete columns where every cell is blank
✏️
Fill Empty Cells Replace null/blank cells with a fixed value (e.g. N/A, 0)
Aa
Change Case UPPER, lower, Title, or Sentence case — any column
🔄
Find & Replace Text or regex, case-sensitive or not, across any/all columns
🏷️
Rename Column Give any column a cleaner, more consistent name
Delete Columns Remove one or more columns you don't need
Split Column "Full Name" → "First Name" + "Last Name" by any delimiter
🔗
Merge Columns Combine multiple columns into one with a separator
↕️
Reorder Columns Drag and drop columns into any order
🔽
Filter Rows Keep or remove rows matching any condition (equals, contains, >, <, empty…)
📅
Standardize Dates Auto-parse any date format and convert to ISO, US, EU, or custom
Strip Characters Remove specific characters from cell edges (e.g. $ signs)

Built for people who work with data

Operations & Business Analysts

Clean Salesforce or HubSpot exports before importing into reporting tools. Standardize date fields, normalize company names, remove test records.

Bookkeepers & Finance Teams

Normalize bank transaction exports before importing to accounting software. Standardize date formats, clean vendor names, remove duplicate transactions.

Freelance Data Consultants

Clean client data in minutes instead of hours. Save operations as recipes and reuse them across similar projects. Bill your time on analysis, not cleanup.

Marketing Teams

Deduplicate contact lists before sending campaigns. Normalize country/city names, standardize phone formats, remove invalid email addresses.

E-commerce Teams

Clean product catalog exports. Standardize category names, fix price formatting, remove discontinued SKUs, reorder columns to match import templates.

Developers & QA Engineers

Quickly inspect and sanitize test data fixtures. Remove sensitive data, normalize values, split or merge fields to match API schemas.

Simple, honest pricing

No monthly fees. No "pro tier" upsell. Pay once, use forever.

Most Popular
£13.99
one-time purchase
✓ 14-day money-back guarantee
Buy DataMend — £13.99 →

Secure checkout via Gumroad. Instant download.

Frequently asked questions

What file formats does DataMend support?

DataMend opens CSV and TSV files. It exports to CSV (UTF-8) and Excel (.xlsx). Opening Excel files directly is planned for v2.

Does it work offline? Is my data uploaded anywhere?

Completely offline. DataMend runs entirely on your computer. No data is ever sent to a server. Safe for confidential, GDPR-regulated, or HIPAA-adjacent data.

How large a CSV file can it handle?

Tested with files up to 1 million rows and 100+ columns. For very large files (5M+ rows), operations work on the full dataset but the preview is capped at 100,000 rows for performance.

What's a "recipe"?

A recipe is a saved sequence of operations stored as a small JSON file. For example: "trim whitespace → remove duplicates → standardize dates → rename column". Load it next week on a fresh export to apply the same cleanup in one click.

Which operating systems are supported?

Windows 10/11, macOS 11+, and modern Linux distributions (Ubuntu 20.04+, Fedora 36+, Arch, etc.). No installation required — unzip and run.

What if it doesn't work for me?

14-day no-questions-asked refund. Email with your receipt and you'll get your money back within 24 hours.

Will there be updates?

All v1.x updates are included in the £13.99 purchase. v2 (if it happens) will be a discounted upgrade for existing customers.

Why not just use Excel or OpenRefine?

Excel requires formulas for everything and has no recipe/replay feature. OpenRefine is powerful but browser-based, slow to start, requires Java, and has a steep learning curve. DataMend is purpose-built for speed: open, click, clean, export.

Stop cleaning CSVs by hand.

£13.99, one-time. 14-day guarantee. Works on Windows, Mac, and Linux.

Buy DataMend — £13.99 →

Secure checkout · Instant download · Offline app