Kinetex Desktop · Compare

The tool travels with you.
The client data does not.

Local-first Workday data validation for consultants. Line up any two extracts by key, see exactly what changed, what’s missing, and why — and hand the client a sign-off report they trust. Yours on this project and the next.

Download for Windows See pricing

Zero install · the live demo runs in your browser with sample data

Windows 10 & 11 14-day full trial Runs entirely on your machine

Kinetex Desktop — Comparison Results
Kinetex Compare results: the Overview heatmap of a comparison, with match, source-only, target-only and differing counts per column

Compare the files you actually have

Flat files & workbooks

The extracts you already get emailed on a project.

CSVComma-separated XLSXExcel workbooks DGWData Gathering Workbooks EIBTemplate exports

Live connections

Pro

Query endpoints and databases directly. Skip manual exports.

Workday RaaSReports as a Service OracleDirect query SnowflakeDirect query

Used on go-lives, not demos.

4 years. 4,600+ commits. 1,900+ in the last 12 months.

GitHub contribution graph for the last 12 months

Built and maintained by a Workday conversion lead who still runs it on every go-live.

Try it right now, in your browser

No sign-up. Nothing to install. A real streamed session of the app with sample data, discarded when you close it. Pick a walkthrough.

Compare walkthrough

~2 min

Open a saved employee validation, run it, and read the results: the match overview, every difference with both values, and one worker traced cell by cell. Then drop in your own CSVs.

AI auto-mapping walkthrough

~3 min

Start from two files with mismatched headers and no key. Watch AI pair the columns, find the identifier, run the comparison, and explain what differs in plain language. AI is included in the session.

The demo streams the desktop app. Open this page on a computer to launch it.

Thoughtful screens, one for each question

A comparison is a series of questions: are these the same rows, what changed, where, and is it a data problem or a mapping problem? Each screen answers one of them.

Mapping

Map once. Reuse it every build cycle.

One row per target column, the source column beside it, matched by name automatically. Mark the key, switch off the columns you don't care about, and the whole setup is saved as a validation you reload next cycle.

  • Keys with measured uniqueness, not guesses
  • Columns paired as X ↔ X_REFERENCE automatically
  • Share a validation with a teammate as one file
Compare docs →
Mapping
The Mapping tab: target columns with their source columns, key columns marked, data types and translate groups per row
Test run

Test before you Run — like Workday does.

Run 1, 100 or 1,000 rows taken from both ends of the file, ordered by key, where the newest hires sit. No report is written, and it finishes in seconds on a 450,000-row workbook, so you find the mapping mistake before the full run, not after.

How Test differs from Run →
Test run
The Test run menu offering 1, 100 or 1,000 rows, next to the Run button
Overview

The whole comparison at a glance.

Matched, differing, only-in-source and only-in-target, per column, as a heatmap. A column that is entirely red is a translation or mapping problem, not a thousand data problems, and you can see that before opening a single row.

Comparison Results — Overview
The Overview heatmap: one cell per column showing the share of matched and differing values
Minimap

Every cell, in one picture.

One pixel per column and row, coloured by outcome. Patterns jump out that a grid hides: a solid column is a crosswalk gap, a horizontal band is one batch, a diagonal is a key offset, scattered dots are free-text drift. Click a callout and the map outlines the region; click the region and you're looking at those rows.

Comparison Results — Minimap
The Minimap: a canvas of every column and row coloured by match, difference or missing side, with a diagnosis callout open
Diffs

Then the row, the column and both values.

Every difference on one grid: key, column, source value, target value. Filter it, sort it, and open the worker behind any row. Rows that exist on only one side are listed separately, so "missing" and "different" never blur together.

Comparison Results — Diffs
The Diffs grid: one row per differing cell with key, column name, source value and target value
Worker Preview

One worker, source beside Workday.

Pick any employee and see their legacy record and their converted record side by side, with the differing fields flagged. Drag the divider to wipe between the two. It is the view the business user asks for, and the one that ends the "is this a real difference?" conversation.

Worker Preview
Worker Preview: a legacy system page on the left, the Workday-shaped record on the right, with a wipe divider between them and flagged fields
Translate

Legacy codes → Workday Reference IDs.

Build the crosswalk once as a translate group — M to Male, FT to Full_time, a cost-center number to its Ref ID — and every comparison, conversion and load that touches the column uses it. Fill Xlat proposes the pairs from the data itself and never overwrites one you typed.

Translate groups
A translate group editor: legacy values on the left mapped to Workday reference IDs on the right
Rules & Reference Sets

Catch what Workday would reject, before the load.

"Name under 35 characters." "Required fields can't be blank." "Value must be in this Reference Set." Rules run across the whole file and report every violation with its row, so the failure shows up on your desktop instead of in a Workday load report two hours later.

Rules
The Rules tab with a few data-quality rules and the Violations list showing rows that failed
Excel variance report

Evidence for the sign-off meeting.

Every run writes an Excel workbook: the summary, the differences with both values, the rows found on one side only, and the configuration that produced them. It opens in Excel like any other spreadsheet, which is exactly what the business expects to receive.

COMPARE_… .xlsx
The Excel variance report open in Excel, with Summary and Differences sheets
Agent access

Drive validations from your terminal or AI assistant.

Kinetex ships its own MCP server, so Claude Code, Claude Desktop or Codex can work the app for you. Ask in words; the agent opens or creates a validation, runs it, and reads back the result. Every mapping, key and run it proposes goes through the same checks as a click.

  • Reconcile on request: open a validation, run it, read the match summary
  • Query the schema: a file's columns, the key, the translations to fill
  • Parse the differences and have them explained in plain language

Runs beside your agent on your machine, no relay and no cloud hop. The agent sees what the app shows it, under the same privacy setting as the AI features. Desktop app, Pro plan.

Claude Code — connected to Kinetex Desktop
run the hires validation against today's extract and tell me what changed
Opening P3_HIRES_VS_TENANT · key EMPLOYEE_ID · 496 source rows, 500 target rows
Run complete in 4.2s
In both 496 · target only 4 · source only 0 · rows with differences 3
3 differences, all in HIRE_DATE: the source has 2026-10-01, the target 2026-09-30 for the same three workers. The dates sit a day apart, which usually means a timezone shift on export rather than a data problem.
4 target-only rows are new hires dated after the source extract. Want the Excel report?
yes, and open it
Written to downloads\COMPARE_P3_HIRES_VS_TENANT.xlsx · opened
AI you control

Map with AI. Keep Worker data out of it.

Column mapping suggestions and difference analysis, with four privacy modes: redact, pseudonymize, synthetic, or send raw. Before anything is sent, a preview shows the exact payload, value by value, and lists any column that would go unchanged. Use the hosted AI, your own provider, or a model running on your own hardware.

AI & privacy guide →
Map with AI — what will be sent
The AI payload preview: the privacy mode selector and the exact redacted values that would be sent

… and so much more

Calc fields

Join, find & replace, zero-pad, substring or split columns, with a live before/after preview on real rows. The result maps, translates and keys like any column.

Filters on either side

Compare only the active workers, one pay group, or one batch, added straight from the Mapping grid.

Excel as-is

Pick the worksheet and the first data row, so a DGW with documentation rows under the header compares without a CSV export. Password-protected workbooks open in the app.

Suggest Keys

Candidate keys ranked by real combined uniqueness, with what each pairs with on the other side and how many rows that was measured over.

Monitor

Every run kept, with its counts, its report and the configuration that produced it. Reload any of them.

Fast re-runs

Unchanged files aren't re-read. The data engine stays warm, so a preview that once took 22 seconds takes about 2.

Also in Kinetex Desktop

Compare is the heart of it. The same mappings and translate groups carry into the rest of the conversion.

Engineered for real conversion projects.

Fast, private, and dependable when go-live is 48 hours away.

100% local-first

Data is processed on your CPU and stays on your disk. No upload, no relay, no account wall to run a comparison. Client files never leave the laptop they were extracted to, so the NDA conversation is a short one.

On-device executionNo uploadNo account

Tested on 450,000-row workbooks

Dozens of columns and hundreds of thousands of rows on an ordinary consultant laptop. Minimap and Test run were built against a 450,000-row workbook, the kind that locks Excel up mid-scroll.

450,000 rowsOrdinary laptop

Agent & terminal ready

An embedded Model Context Protocol server. Drive validations, inspect mappings and query diffs from Claude Code or a local agent, under the same privacy modes.

MCP server

Signed MSIX, self-updating

Code-signed by Kinetex Consulting Services, Inc. Installs as an MSIX package and picks up new builds on its own.

Code-signed

Support from the builder

Email reaches the person who wrote it, and who still runs it on live Workday projects. What the next build cycle needs usually ships before it.

Builder direct

Want to see Kinetex in action?

Download it, open the two files from your last build cycle, and have the differences on screen before the coffee is ready.

14-day full trial · Local-only processing · Enterprise licensing available