Skip to content

Running a List Comparison

Joe edited this page Feb 26, 2020 · 1 revision

Running a comparison is fairly straight forward, you can add any number of local STP/CAB files to the left or right lists, or import a list from any SharePoint Online/OnPrem site that you have setup. Each list maintains a comparison index, so lists in the left and right table at index 0 will be compared, and so on and so forth.

Run List Comparison.

1) Simply select the Add New button on the left hand or right hand side to add a local or online list to the table. If you have SharePoint credentials setup you'll be able to select Online otherwise you'll only be able to select Local.

Main Screen

2) Selecting Local will open a standard windows open file dialog window and will filter .stp or .cab files so that you can compare exported list templates.

2a) Selecting Online will load a new page and display all of the available lists from the SharePoint site that your SharePoint credentials are authorized to see at the provided Site URL.

3) Once you've got all the lists added that you want to compare simply click Run Comparison and the application will start to do a two way comparison between each comparison index.

Main Screen

4) A new page will show you the name of the lists that were compared against each other per row and whether they were a match. It also tries to perform View matches as Online vs Local list comparisons can often be distorted by system created lists.

5) If you double click on one of the comparison result rows you can view the two way match results.

Main Screen

6) Items marked in Red are NOT in the other comparison list, this works both ways, so Red items in the left list are not present in the right list, and vice versa.

Clone this wiki locally