Skip to content
FREE TOOLS · PRACTICAL GUIDES · REAL-WORK HELP Built in Malaysia · Made for everyday work
stooper✳Ask a question
Menu
Get helpToolsGuidesAboutContactSearchSuppliers
← Apps & tools
MULTI-FILE WORKFLOWS

Data Automation Studio

Merge spreadsheets, map columns, reconcile records and reuse your rules. Your files stay on-device unless you approve an AI request.

Local processing by default · Optional AI with your consent
STUDIO 3.1 · REVIEW-FIRST AI
Quick test: load demo → run Merge → review 10 rows → select Reconcile → select October orders / supplier confirmations → run again.

Source files

Drag and drop spreadsheets here

Maximum 10 files, 20 MB each, 100,000 rows in total.

Standard output columns

Define your output structure.

Map each file to your output columns

Choose a source column for every target field.

Cleaning & safety rules

Duplicate detection requires key selection.

Workflow

Ready for your files.

Result preview

Review problems and any unmatched fields before exporting.

Preview reflects current export settings. Invalid records remain for manual review.

Review and source audit

Data workspace

Explore, filter, transform and download your final data.

No dataset

1. Load files → 2. Run workflow → 3. Transform / AI → 4. Review → 5. Download

0 / 0 rows

Live quality review (matches current filter): Run a workflow to analyse results.

Run workflow above first.

Review queue — first 20 issues

Transform column (local)

Group summary (local)

Final deliverables

Download results

IDs and leading zeroes are preserved as text.

Download template JSON

Templates store headers and rules, not customer data.

Recommended workflow

Upload files → map fields → run workflow → review issues → export.

Reconciliation does not delete records; duplicate keys are flagged.

Leading zeroes and formula-like text are protected.

What this tool can do

Clean CSV/XLSX files, map columns, combine tables, compare orders and supplier confirmations, flag problems, and export client-ready reports. AI suggestions require your approval.

Before using AI

Use fictional test files first. Select only the fields you need, avoid confidential data unless authorised, and review every AI-generated result. A project API key and separate API billing are required for AI features.

Privacy policy · Stooper tools

Useful first. Extra help only when you need it.

Still stuck on something specific?