XLTools.net Columns Match

Hi All !

Today I had task about compare table data exported from MS CRM 2011. After investigate I faced with awfully nice tool  for MS Exel it name XLTools.net Columns Match for Excel 2013.
For me it was very convenient to use this tool and I has save my time using this instrument like analyst.

So, all about this tool you can reading here.

XLTools Columns Match app for Excel 2013

When you need your Excel columns to be compared with each other or with the set of standard values you may experience difficulties because it is a difficult task to be performed manually. Data may be missed, not copied, you may not know how to calculate the level of data similarity. With XLTools Columns Match app you don’t have a chance to make a mistake! Matching Columns wizard will help you to compare the sets of columns in Excel with each other or with the target columns, find the same or similar items and calculate the level of their coherence. Thanks to XLTools Columns Match app this process is performed immediately and you get a result in a user-friendly layout!
IT`s FREE !!!

How to work with Columns Match app for Excel 2013
1. Open your Excel 2013 worksheet
2. Open the Columns Match App:
  • Go to Insert tab in Excel;
  • Select Apps for Office;
  • Click on the Columns Match app and click Insert.
XLTools Columns Match App
3. Select the range of the cells which you would like to compare with each other or with the standard values:
  • Press the Select button on the pane;
  • Select the range of cells;
  • Please note that the first row in the selection will be detected as the header of the results table.
XLTools Columns Match Step 1 - Select target columns 
4. Select an empty cell where a system will paste the result of comparison.
XLTools Columns Match Step 2 - Select output cell
5. If columns chosen in Step 1 need to compared between each other then skip this step. If target columns from Step 1 are to be matched between standard values please complete this step:
  • Press the Select button on the pane;
  • Select the range of cells;
  • Please note that the first row in the selection will be detected as the rows’ title in the results table.
XLTools Columns Match Step 3 - select standard columns
6. The 4th Step is optional and lets you adjust comparison options. ‘Show % of matching’ mode is marked by default. This mode generates results table which displays the percent of columns’ matching between target columns and standard values.
The second option creates a table which displays True if values are identical and False if they are not.
XLTools Columns Match Step 4 - Adjust columns match options
7. Click the Match Columns button to start the process.
8. Once the app generates the table, you’ll see a toast notification that confirms the flatten table is created.
XLTools Columns Match result tab