Differencia

Differencia is a data comparison and diff tool, exclusively for Mac OS X. Differencia can easily compare data files from multiple applications, even when file and data formats differ. Data file comparisons and reconciliations are painless, saving you time, money and frustration.

Differencia can be used to perform cash, stock, and bank reconciliations. It can compare Excel and Numbers spreadsheets, or diff data from SQL databases and any application that exports to a flat file format.

Click on thumbnails for screenshots

Compare Apples and Oranges

Differencia effortlessly handles different file and data formats, so there is no time-consuming, error-prone massaging of data files into the same format. Remove expensive custom software and directly compare raw data. Differencia delivers painless reconciliation, exception processing and comparisons.

Minimal Configuration

Differencia automatically identifies file layouts, even identifying the text, date, time or number format for each field. The only configuration required, is to select which fields to compare. With a comparison template from the online database, you can even skip that step. Simply select the files and run the comparison.

International Flag Bearer

Differencia can handle international date and time formats, so "13.11.07" matches with "11/13/07" and "13th Nov 2007". It also deals with number formats, matching "$1,000.00" with "USD 1.000,00". Differencia identifies localised text encodings and gracefully handles Mac, Unix and even Windows line endings.

Record Matching

Along with no reformating, records do not need to be sorted into a common order. Instead unique identity fields can be specified with flick of a switch. This might be an order number, transaction ID or SKU. Data fields can also be used to match records, such as the date and value of a banking transaction.

Designed for Humans

As a Mac application, Differencia has a familiar, easy to understand interface, as you should expect. Furthermore, Differencia aims to make comparing your data as simple as possible. Intelligence about reconciliation is built into the application, allowing the interface to be kept simple, yet powerful.

Supported File Formats

Compare and diff any "flat file" format, e.g., Comma or Tab Separated Values (CSV, TSV), and the Intuit Import / Export Format (IIF) used by QuickBooks. Use data from any application that exports to a flat file format. Use Excel & Numbers spreadsheets via an easy, reliable export to CSV. Please let us know what additional formats you would like added.

Differencia at Work

To best understand Differencia's unique capabilities, see the new data comparison tool in action in our screen shot gallery. You can also download a fully functional, 45 day trial version.