Cross Check and Compare Two lists of Data

Use this free tool from Jet City Data to compare two lists of data. Without wastng time converting the data into Access or other SQL database, you can just paste the two lists of data here directly from Excel or other spreadsheet program and then choose the fields you want to compare. Only pull out the relevant data you need instead of wasting precious server processing time.

Fields to Match:
Return Method: Show me only rows in the first data that are NOT in the second data
Show me only rows in the first data that are NOT in the second data AND remove any duplicate rows from First Data
Show me everything (coming soon)
1st Fields:
First Row Contains Field Names
First Data:
2nd Fields:
First Row Contains Field Names
Second Data:


Instructions:

Step 1: Put the first row of data including the field names of the First Data in the first box labeled "Fields". This can be tab or comma delimited.

Step 2: Provide the names of the fields you want to check for matches in the second box labeled "Check Duplicate On". Providing multiple field names in that box will cause the program to combine those two fields and treat them as one. So for example, checking for dulicates or matches on two fields with rows containing "A,A" and "A,B" are not considered duplicate, whereas "A,B" and "A,B" are.

Step 3: Paste your two sets of data in the text boxes next to "First Data" and "Second Data". You can copy and paste directly from Excel or other similar spreadsheet program. Technically, the data should be in the format of "Tab-Delimited Text".


Note: Your data will not be saved, even temporarily, on our server. You will simply be presented with a list of results on the next page. The only required fiels in the second set of data are those that you are checking for a match on. The results will contain all the columns from the first data intact.



Copyright 2007 Jet City Data