Compare lists and show similar entries

About Reconcile App

This reconcilation app is unhosted so you can download or save it and use it offline.

It respects your privacy so it wont send your data to a server or a cloud.

It is free Software (GPL) written in HTML5 and Javascript (JS).

Computation is powered by Levenshtein algorithm in JSLab Standard Library.

Design is powerd by CSS in Zurb Foundation.

Copyleft 2014 by Markus Mandalka.

×

How to compare spredsheets?

Its possible to compare a (single) column of a spredshead with a (single) columns of another spredsheat.

Just copy and paste both columns into the app and compare them:

• Just mark the whole column (clicking on its header) in Excel or OpenOffice Calc
• Copy it by pressing Control-c or choosing copy in the context menu (left mouse button)
• Paste it to the field List in Reconcile App: Click in the field and press Control-v or choose paste in the context menu (left mouse button)
• Do the same with other spredsheet copying and pasting a column to the field Comparision list

If you want to compare more than one column of each spredsheet or table, you have to use more complex tools like Spredsheet Deduper.

×

Running time

Running time depends mainly on the count of entries (on both sides: the count of lines of each list is a factor) and the CPU and only a little bit on RAM (only if to feew because swapping needed):

• Compare 1000 entries with 10000 entries (10000000 comparisions): 15 minutes.
• Compare 2000 entries with 10000 entries (20000000 comparisons): 30 minutes.
• Compare 1000 entries with 20000 entries (20000000 comparisons): 30 minutes.
• Compare 2000 entries with 20000 entries (40000000 comparisions): 1 hour.
• Compare 2000 entries with 40000 entries (80000000 comparisions): 2 hours.
• Compare 4000 entries with 40000 entries (160000000 comparisions): 4 hours.
• Compare 8000 entries with 80000 entries (640000000 comparisions): 16 hours.

If you want only exact matches (if you know there are no typos in your data and every char will be the same), set the field maximum changed chars (maximum Levenshtein distance) to 0 and if possible delete the entries in strings to ignore, so the calculation will be much faster.

×