The user focused environment was made to be easy and quick. The interface allows for simple tasks as well as for complex data.

The software is completely free without accounts or cloud. The moment you opened the app, you downloaded everything you need to start comparing.

how to

1. Select 1 .xls file or 2 CSV files.
   Make sure your table has header and data setup like in this example file to avoid errors, because they are currently not saying what exactly is wrong. Also consider testing with the given file first to get a feeling for the app. Here you can find a working configuration.
   

2. fuzzy matching: add a tolerance to every column (e.g. 5 minutes between 2 datetimes should be handled as the same datetime).

   best match: decide for every column if it should be optional or mandatory the same in the best row. You will get a match with the best hit for every row.
   If you picked a .xls file, insert the names for the sheets where the tables live.

   
3. Configure your data with types and map the columns.
   The first input field is always from the first sheet or the first CSV you see above.
   It accepts Excel column names. So the first column is A, then B and so on - that includes .csv files. It reads "compare column A (from Sheet1) with column A (from Sheet2) and interpret both of them as normal text".
   

   Datatypes are similar to cellformatting in Excel. The type 'floating' contains values with commas (e.g. 1.5), 'integer' natural numbers (e.g. 4) and text should be obvious.
   Date or time can use normal Excel formatting but also read the cell as text and convert it. If you pick this type, you will see options how the cell should be interpreted. If you're not sure, just don't touch the options and try it first.
   If you have date and time information, it can be read by having both set in your configuration. Alternatively you can select a column as 'datetime', which interprets the values as a combined ISO-Datetime (e.g. 1999-09-14T00:42:00Z).

   If you use tolerance, keep an eye out for the tooltips, which appear when you hover above something, because the units of tolerance change with every datatype.

   You can add and remove mappings as you like. When you are done, consider saving it if you gonna need it again.
   
4. Compare and check the results.
   Depending on your filesize, this could take some time. I am working on a way to stop freezing the app and speeding up the entire process immensely.
   To get the results, click the left button to save the generated file and the right to reset.
   

If you have any problem using the app or think it is missing something, please write me a quick mail.

state: beta

Tablecompare is open to everyone here. You can get notified about new releases or updates.

Email address I'll never share your email with anyone else and only use it for said purpose.
You can unregister at any time with a mail.

Notify me

Email successfully added.

Email already registered.

Email does not exist.

Error with the registration. Try again later.

why does this exist?

Tablecompare is a byproduct of one of my hobby projects for testing new technologies. I had a use case where I needed this tool so I built it. It worked for me but afterwards it was sitting on my harddrive for years so I thought I might as well share it.
Since this is simply one of many hobby projects, handle this as a tool and not a product. But if you contact me, I will see what I can do to making your life easier.