We reconcile vendor data from 3 different ERP systems every month. What used to take my team 2 full days now takes about 45 minutes with Dataweaver.
Now with Database Connections and Weaver Modes
Your data is messy. Describe the fix. Done.
Works with CSV, Excel, JSON, databases, and cloud logs. Your data never leaves your machine.
No credit card·No uploads·Your files never leave your machine
See it in action — 60 seconds
“We were merging HubSpot and Salesforce exports every Monday morning — one had phone numbers with country codes, the other didn’t, one had company names with Ltd. and Inc. variations, the other was just raw — and I had a whole forty-five minute routine I’d built in Excel to clean and reshape it. Three macros, two pivot tables, a VLOOKUP I was terrified to touch”
“…Dataweaver replaced the whole thing in one shot, and now it runs in under five minutes while I drink coffee.”
RevOps Lead, Series B Startup
0 hoursevery Monday morning
120 minsame task, zero formulas
Just describe what you need.
Clean, reshape, and derive — without a single formula.
Cleaning
Finds data issuesNormalization
Fixes formats automaticallyTransformation
Derives new columns from your data847 rows processed·12 flagged·dates standardized·1 column added
| invoice_id | invoice_total | date | days_outstanding + Derived |
|---|---|---|---|
| INV-0042 | $1,240.00 | 01/15/26 | 34 |
| INV-0043 | $890.00 | 01/16/26 | 18 |
| INV-0044 | $320.00 | 01/16/26 | — |
Built for people who deal with data daily.
“Every month I get three vendor files in different formats. The dates never match, the IDs are inconsistent, and I spend a full afternoon just getting them into our system.”— Sarah K., FP&A Analyst at a 200-person SaaS
vendor_iddateamountstatus
V-001Jan 15$1,200.00→ ✓ clean
VEND0012026/1/151200.00→ ✓ clean
00115-Jan$1.2K→ ✓ clean
3 formats → 1 standard · 4 minutes
“Our Salesforce export has "Ltd." and "Limited" and "LLC" as separate companies. I’ve been merging duplicates by hand for six months.”— James R., Revenue Operations
company_nameresult
Acme Ltd.→ Acme
Acme Limited→ Acme
ACME LLC→ Acme
847 duplicates merged · 8 minutes
“Client sent me a 50,000-row CSV at 11pm and needs it deliverable-ready by morning. Half the columns are garbage.”— Priya M., Independent Consultant
col_Acol_B(empty)result
raw_val_1mixed—→ clean
RAW_VAL_212/ab—→ clean
raw-val-3N/A—→ clean
50k rows cleaned · 12 minutes
“I don’t have a data team — I am the data team. I need the investor report numbers to be right, not close enough.”— Daniel W., CEO, Seed-stage
monthrevenuegapresult
Jan$42,100—→ $42,100
Feb???missing→ $38,900
Mar$51.2Kformat→ $51,200
Investor deck ready · 6 minutes
“I need every transaction in the same format before I can even start. The bank exports, the ERP exports, the manual entries — none of them agree.”— Karen L., Internal Auditor
txn_iddateamountresult
BNK-00101/15/26$1,200→ ✓ unified
ERP-10012026-01-151200.00→ ✓ unified
MAN_1Jan 151.2K→ ✓ unified
3 sources unified · 15 minutes
“Our event lead list has 4,000 contacts and I know at least a third are duplicates or have bad email formats.”— Alex T., Growth Marketing
emailresult
John@ACME.com→ john@acme.com
john@acme.com→ (duplicate)
(blank)→ (removed)
1,200 dupes removed · 3 minutes
“We get supplier files in six different formats and I have to manually normalize them before every quarterly review.”— Maria S., Procurement Lead
supplier_codeunitqtyresult
SUP-001pcs100→ ✓ standard
S001pieces100→ ✓ standard
sup_1ea100→ ✓ standard
6 formats → 1 · 9 minutes
“The payroll export and the HRIS never agree on employee IDs. I spend two days every month reconciling them.”— Chris P., People Operations
emp_id (Payroll)emp_id (HRIS)result
E001EMP-001→ ✓ matched
E0022→ ✓ matched
E003EMP-3→ ✓ matched
100% matched · 20 minutes
“I could write a Python script, but it’d take me 45 minutes to handle all the edge cases. Dataweaver does it in 3 and I can move on to actual engineering work.”— Raj P., Senior Backend Engineer
scriptedge_casestimeresult
parse_csv.py12 handlers45 min→ 3 min
normalize.py8 formats30 min→ 2 min
validate.py6 checks20 min→ 1 min
45 min scripting → 3 min · shipped
Why teams switch to Dataweaver
Describe what's wrong.
Get it fixed.
>“standardize all dates and flag missing payment values”
✓ 2,847 rows cleaned✓ 34 issues flagged✓ 12 formats fixed
Plain English in, clean data out. No formulas, no code, no waiting.
Your files stay on your machine.
GDPR-compliant by design. No cloud. No uploads. Ever.
Runs again tomorrow.
Save any workflow. Run it on next month's file too. Never redo work.
Your Monday morning
WITHOUT DataweaverWITH Dataweaver
8:00 AM
Open the vendor file. Wrong date format. Again.
8:45 AM
Start VLOOKUP. Column headers don't match. Try INDEX MATCH instead.
9:30 AM
Google “convert DD/MM to MM/DD in Excel”
10:30 AM
Finally matched. Wait — 3 duplicates slipped through.
11:00 AM
Start actual work. Three hours gone.
8:00 AM
Drop the file. “Fix dates and match vendors”
8:05 AM
Done. Start the actual work.
☕ Coffee time
0 hours wasted →0 minutes
“But what about ChatGPT?”
ChatGPT can write formulas — but you still copy-paste back and forth, it can't handle large files, it can't connect to your database or cloud logs, and your data goes to the cloud. Dataweaver works directly on your files, databases, and logs — locally, with interactive charts and full audit trail.
Minutes, not hours.
FinanceMismatched vendor IDs across 3 exports, wrong date formats, VLOOKUP that breaks every import→ 10 min Vendor reconciliation
RevOps'Ltd' and 'Limited' and 'LLC' as separate companies across 5,000 rows→ 15 min CRM cleanup
Data Ops5 vendor reports, none with the same columns, one in German date format→ 12 min Multi-source consolidation
ReportingSame vendor, different column order every month. Rebuild the mapping from scratch.→ 8 min Monthly standardization
AuditRaw transaction logs, uncategorized, amounts in mixed currencies→ 30 min Audit prep
Frequently Asked Questions
What is Dataweaver?
Dataweaver is a local-first AI data analyst desktop app that analyzes spreadsheets, CSVs, databases, and cloud logs on your machine, with no file uploads and automatic PII redaction. Built by TechCora.
Is my data safe?
Your files never leave your machine. Dataweaver’s AI only sees metadata — column names, types, and aggregate statistics like min/max values. Any personally identifiable information is automatically redacted before anything reaches the AI. Your actual rows and cell values stay on your computer.
What if the AI makes a mistake?
Your original files are never modified. Dataweaver creates separate working copies for each step, and you get a clean output file at the end. If something looks wrong, your source data is exactly where you left it.
My spreadsheets are messy — will this work?
That’s specifically what Dataweaver is built for. Inconsistent column headers, mixed date formats, multi-sheet workbooks, duplicate entries — describe what you want cleaned up in plain English and Dataweaver handles the rest.
Do I need to be technical?
If you can describe what you want in a sentence — “remove duplicates,” “standardize dates,” “flag rows where the total is blank” — you can use Dataweaver. No formulas, no code, no training required.
Is it free?
Free to download with 25 AI operations included — no credit card required. Planning and data summaries don’t count toward that limit, only transformations do.
What file formats does Dataweaver support?
CSV, Excel (.xlsx, .xls), JSON, and Apache Arrow files. Dataweaver also connects to SQL databases (PostgreSQL, MySQL) and GCP Cloud Logging. It handles files with millions of rows efficiently.
How is Dataweaver different from ChatGPT for data analysis?
ChatGPT can write formulas but requires copy-pasting back and forth, can’t handle large files due to token limits, and sends your data to the cloud. Dataweaver works directly on your local files, handles million-row datasets instantly, preserves privacy with automatic PII redaction, and provides interactive charts with full audit trail.
Dataweaver vs Excel — which is better for data cleaning?
Dataweaver processes 1M-row files in under 3 seconds versus Excel’s 30+ seconds. It offers AI-powered transformations in plain English versus manual formulas. Source files are never modified in Dataweaver (immutable originals), while Excel edits in-place. Dataweaver is GDPR-compliant by design with no cloud dependency.
What platforms are supported?
macOS 12 and later, and Windows 10+. Download for free from dataweaverapp.com.
Your files never leave your machine. Dataweaver's AI only sees metadata — column names, types, and statistics — never your actual rows. Every transformation runs locally, whether through built-in Rust tools or AI-generated code in a sandboxed environment.
Files processed on your device·AI sees metadata only·GDPR-compliant by design
No credit card. No cloud. No catch.
Your next clean dataset starts now.
Free for macOS & Windows. Your files stay on your machine.
Get Dataweaver — FreeDownloaded 2,400+ times·Built with Rust·