ElkwaiSolutions

OFFLINE BUSINESS SOFTWARE · VERSION 1.1.0

Data Cleanup & Import Studio

One import from several exports. Every row accounted for.

Map source columns, apply explicit rules and review duplicates within each file or across the whole batch. Export a combined import with separate source-row lineage, rejected originals and the evidence behind every transformation.

One named user. Buy the current version once. No subscription, AI provider, or upload of your files.

01 A usable import, not just a quality score

01

Accepted rows

Renamed fields and explicit transformations, ready for your own destination-system review. IDs and decimal values remain text.

02

Rejected originals

Missing required values, invalid shapes and selected duplicate cases, with source-row numbers and clear reasons.

03

Repeatable evidence

A reusable template, original parsed rows, source hash where available, applied rules and a JSON change receipt in each file's folder.

02 Inspect a complete example

The included fixture has eight rows: inconsistent casing, an exact copy, invalid email and date shapes, a missing required value, and a thousands-separated amount. With the displayed rules, four rows pass and four are retained for review.

Illustrative fixture, not client data
InputSelected ruleResult
Accounts@Example.org Trim + lowercaseaccounts@example.org
00120.50Decimal shapePreserved exactly
2024-02-30Calendar dateRejected; original retained
Repeated exact rowSeparate exact copiesFirst valid copy retained; extra copy reviewed
Run the rules and download the example output

Across files Catch overlaps before they reach your business systems

Consolidate branch or supplier exports

Bring up to ten files through one reusable mapping. Column order can differ; every mapped field must exist. Keep the combined accepted CSV separate from its source-row lineage, so extra audit columns do not disrupt your importer.

Separate copies from conflicts

Exact-copy review retains the first valid mapped copy in selected file order. Repeated-ID review quarantines every ambiguous member and lists the fields that differ. Nothing guesses which amount, address or record is correct.

Trace every outcome

A complete row-disposition CSV links each source record to its output row or rejection reasons. Numbered file IDs distinguish identical filenames. Original parsed rows remain in each source folder.

Try two overlapping exports

Choose Cross-file example in the working preview. Compare exact-copy and repeated-ID policies, inspect duplicate groups, then download the complete illustrative audit. Old templates retain per-file behavior.

03 Buy once. Keep the purchased version.

Data Cleanup & Import Studio 1.1.0

A single offline HTML application, instructions, license and signed release records in a private ZIP.

  • 10 files per batch; reusable templates
  • Column mapping, trimming, case conversion and required-value checks
  • Email, decimal and YYYY-MM-DD text-shape checks
  • Per-file or cross-file duplicate review; no guessed merge
  • Combined accepted CSV with separate source-row lineage
  • Complete duplicate review and row dispositions, originals and change receipts
$69one timeIntroductory pricing

One named user; internal business and authorized client work. Future versions, custom integration and scheduled updates are not included.

Verifying purchase and private download availability.

Tax is shown at checkout. A 30-day download retrieval window is separate from your continued offline use of the purchased version. Review the software license, purchase terms and privacy notice.

04 Where it fits

CRM and contact imports

Rename columns and check required fields and email shapes. Nothing verifies mailbox ownership or sends messages.

Inventory and supplier exports

Preserve product codes and leading zeros. Review duplicate identifiers rather than merging items with uncertain identity.

Invoice and operations records

Check explicit date and decimal formats. Locale conversion, accounting reconciliation and business accuracy remain separate tasks.

Limits you can plan around

UTF-8 comma, semicolon and tab files. 5 MB, 50,000 rows, 200 columns and 1 million cells per file; 20 MB input and 40 MB generated output per batch. Cell and issue audits cap at 50,000 with a clear truncation notice. CSV output includes every processed row.