DataClean Pro CSV & Excel
日本語 / English Buy

Turn every client's messy CSV & Excel into
your usual format — in one click.

Columns in a different order every time. Extra columns you don't need. Codes still on the old scheme—— clean that incoming data with just a few clicks. No Excel formulas, no macros. Especially when a deadline is breathing down your neck, tidy it up fast and ship. Your data never leaves your PC.

▶ Try it in your browser See pricing

No sign-up to try the demo. Your data stays on your PC.

$29.99 one-time / Windows
Made in Japan 🧩 No Excel formulas or macros 🔒 Your data stays on your PC ♾ One-time purchase, no subscription

Built by a former sales-planning lead at a public company, to eliminate his own monthly busywork.

A Japanese craftsman working with quiet focus at a laptop in a minimalist wood-and-shoji studio — software crafted in Japan with care.

Sound familiar? The same manual work, every time.

Common headaches for anyone who receives data — sales, ops, finance (no Excel wizardry required)

🔀

Columns in random order

Every sender orders columns differently, your usual column is missing, extra columns appear. Re-sorting in Excel, every single time.

🈂

Garbled text & inconsistent notation

Wrong encoding garbles the text. Company names, casing, full/half-width and stray spaces are all mixed together.

🏷

Outdated codes

Department codes changed after a reorg, but the data you receive still uses the old ones. Manual find-and-replace, every time.

Clean it before you hand it to AI.

If you're feeding CSV or Excel to ChatGPT or Copilot, clean it first

🎯

More accurate answers

Messy columns, inconsistent values, and blanks are noise to an AI. Hand over only the columns you need, in a consistent shape, and accuracy goes up.

✂️

Fewer wasted tokens

Drop unused columns and extra rows before sending, and you cut wasted tokens — saving cost and time.

🔒

You control what's shared

All cleanup happens locally. You decide exactly what goes to the AI.

Try it right in your browser

No install. Clean real data in the demo below (the demo is limited to 5 columns × 50 rows; saving is product-only)

📄 Demo: import → clean

① Organize columns (keep/drop, rename, reorder) & replace values

② Preview after cleanup

🔒 Everything in this demo runs inside your browser. Nothing is uploaded anywhere. Buy to save & use

VLOOKUP — without writing a single formula.

Match against another file by key and pull in the columns you want. No tricky functions, no "$", no arguments.

VLOOKUP screen in English: product codes matched against a reference file to pull in Planned Qty and Owner Dept columns, shown added to the result table
Just pick the columnsChoose the key column on each side. No formulas at all.
Pull in multiple columns at onceRep name, department, planned quantity — grab them all in one go.
Pick the sheet for ExcelFor .xlsx reference files, choose which sheet to use.
Survives reorderingColumns match by name, so it won't break when the sender's layout changes.

What it does

Only the features non-engineers actually use on the job

🔀

Organize columns

Drop, reorder, and rename in one table. Handled by name, not position, so reordering won't break it.

🧹

Cleansing

Trim spaces, standardize width/kana (for Japanese text), zero-pad, and unify date formats — in one click.

🔁

Replace values

Code swaps like 2500→1500, partial replace like Inc.→Incorporated. Exact, prefix, or contains.

🔗

VLOOKUP TOP PICK

Match another file by key and pull in multiple columns like rep or department name. No formulas.

✚

Add columns

Calculated columns (price × qty = amount, tax-incl), splits (B-220 → symbol/number), and merging columns. No formulas.

📈

Aggregate & pivot

Cross-tabs like department × month: sum, count, average, max, min — in one go.

⚖️

Diff & reconcile

Match this month vs last by key to surface additions, deletions, and changes.

🔎

Data check

Find blanks, non-numeric values, and unexpected codes with color highlighting. Perfect for a pre-delivery check.

📁

Batch a folder

Clean and combine every CSV/Excel in a folder using a saved recipe.

📊

CSV & XLSX

Import and export both .csv and .xlsx, including choosing among multiple sheets.

💾

Save cleanup recipes

Name and save your steps. Reproduce a monthly routine in one click next time.

🈁

Encoding options

Output as UTF-8(BOM) or Shift_JIS(cp932), plus Western-legacy Windows-1252 and ISO-8859-1. Match whatever the recipient needs.

🌍

European CSV formats

Decimal comma (1.234,56), semicolon (;) delimiter, and DMY dates (31/12/2025). Clean overseas data without breaking it.

🧮

Row operations

Remove blank rows, dedupe, and filter by condition to clear out unwanted rows.

🔒

Fully local

No cloud upload. Your sales data and customer lists never leave your PC.

Real screenshots

No trial version, but you can see the real screens before you buy

Data check screen in English: a blank Qty and a non-numeric Unit Price (abc) highlighted in the source table, with a count of issues to review
Data check: find blanks, non-numeric values, and unexpected codes with color highlighting. A final check before delivery.
Add-columns screen in English: an Amount column calculated from Unit Price × Qty, and a product code split into Symbol and Number columns
Add columns: amount from price × qty, and a product code split into symbol and number. New columns, no formulas.
🔒

Your data stays put

Everything is processed on your PC. No external uploads — easy to clear with internal security policies.

♾

One-time, no extra fees

Not a subscription. Buy once, use it forever.

🪟

Windows app

Install safely from the Microsoft Store. Automatic updates.

Pricing

Every feature included, no add-on costs

$29.99
One-time purchase (buy once, use forever)
  • Organize columns, cleansing, replace values
  • VLOOKUP, calculated columns, pivots, diff & reconcile
  • Batch folders, CSV/XLSX in & out, encoding options (European CSV supported)
  • Save and reproduce cleanup recipes (unlimited)
  • Fully local processing
  • Free updates
Buy on the Microsoft Store

Available on the Microsoft Store — or try the demo above first.

Frequently asked questions

Is there a trial?

The demo on this page lets you try the real workflow for free (up to 5 columns × 50 rows; saving is disabled). The full product has no row or column limits and lets you save cleaned results and reusable cleanup recipes.

Is any of my data sent externally?

No. Both the demo and the product do all processing inside your PC (your browser). Your sales data and customer lists never leave, which makes it easy to clear with internal security policies.

Does it work on Mac?

We currently offer a Windows version. If you'd like a Mac or other OS build, let us know.

Is it a subscription?

No — it's a one-time purchase of $29.99. Buy once and use it forever, with no extra fees.

Can it handle Excel files?

Yes. It imports and exports .xlsx / .xls and lets you choose among multiple sheets.

Contact

Bug reports, feature requests, pre-purchase questions — all welcome.

Your message is delivered to the developer by email.