In our opinion, we really like the way to have all relevant elements in a single interface that is quite easy to understand. Options whether to process contents for inserted or deleted rows and columns.
Passwords for protected worksheets or workbooks can be entered to process them. Parallel scrolling and jumping within worksheets makes the navigation and difference viewing very convenient.
Color coded difference types that can be highlighted or un-highlighted with a single click. Un-checking a box, will instantly change the color coded cells in the active spreadsheet. Hyperlinked difference report with descriptions for each difference. Also this, in our opinion, is very simple and easy to understand. The difference report can be exported into Excel for further editing or viewing. Unfortunately Inquire has no feature to update differences.
The workflow ends by viewing differences only. Skip to content. Home Solution Comparison Blog Contact. Developer Microsoft Website www. Compare all Solutions. See all Solutions. Strongest Points. Weakest Points. Working with this Solution… The below rating is based on our evaluation sheet that gives points for more than 40 different questions.
What general Features does the Solution have? What makes working convenient? What can be customized? Which Differences can be found? It can also be started via the Inquire add-in from within Excel. While it does recognize that row 11 was inserted, it adds noise around it Deleted Row 12 and Added Row It misses the cell change and also introduces cryptic text for the VBA part of the new sheet Sheet2.
On the VBA side, it does a good job by showing a nice diff for the changed module and listing the new module correctly, too:. This is clearly not scalable if you ever need to compare a workbook with more than one sheet or a few workbooks :. The following screenshot shows the effect if you select only column B instead of B and C toghether as the column key:.
Excel files are difficult to compare stay tuned for a future blog post that looks more into the details of why that is and accordingly, good tools are hard to find.
If you receive invoices, part lists, price lists or other tables splitted into smaller parts - xlCompare is a best excel file compare tool to automate your work and increase your productivity. Why Use xlCompare? Fast and Efficient. Compare Excel worksheets within seconds and maximum accuracy. Get an accurate and easy to understand comparison report. Easy to Use. This Excel diff tool is extremely easy to use. We've made it as simple as possible.
You won't need to spend your time on learning this product. Just install it and use it! Clear Results. This is the perfect visual representation of the comparison results. The Benefits of xlCompare. Compare Excel Files. Compare your version of Excel file with version of your co-worker and merge changes. Comparison Report. Detect cell and structural differences. Show differences in the form of Color Coded Report. Merge Excel Workbooks. Combine Excel Worksheets. Combine several excel worksheets into one in single click.
Join and intersect Excel Tables. Excel Diff Viewer. Export Report. Changed Values. If you've changed cells value, or it was changed after recalculation - it will be highlighted by xlCompare. All cell formatting options are compared. Find Inserted Rows and Columns. Virtualy Aligned Rows. Added and Deleted Rows Columns are virtually inserted into another workbook to make native representation of the comparison results.
Every pair of the corresponding rows are on the same places. With aligned rows you see where merged unique rows will be inserted. Select range of the rows you want to insert and move them in one click on the plus icon. Combine Several Excel Sheets into One. Merge Cells. Select range of cells you want to merge and use Merge command. All values in the corresponding sheet will be updated in one click.
Merge Unique Rows. Select rows or columns you would like to merge and press PLUS icon to add them to other worksheet. You get only records you need! One Click Merge. Merge button combines spreadsheets in a without selecting differences one by one.
One mouse click and few seconds - your worksheets are combined into one. Display Formatted Difference Report. Display Difference. Display Difference option gives you ability to see updated value and difference. Focus on Changes. Sometimes updated value is not so important as difference between values. You get exactly what you need. Unique Feature. This feature is possible only in the xlCompare. It is not possible in the software based on the Excel application.
Save Color Coded Comparison Report. Save as PDF. Ideal for presentations. Save color formatted cells with their corresponding values or differences. Save as XLSX. Save as HTML. Visualized Difference Representation.
Scrollbar Marks. Worksheet Tabs. Hide Equal Sheets. Highlight and Remove Duplicates in Excel Tables. Highlight Duplicates. Filter Duplicates. Remove Duplicates. Only Unique Rows. Only Equal Rows. Changed and Equal Rows. Bulk Merge and Undo commands One click mass operations are essential part of the software, designed to save time and increase productivity.
You needs in quick and powerful merge commands which allows to manipulate whole worksheets. This greately increases your productivity if you are working with large amount of data. Undo Merge. Filter data you want to compare Reduce comparison noise by selecting cell and formatting options included into comparison Define comparison strategy which is most suitable for the data you have.
Exclude Hidden Rows. Calculated Values. If you are not interested in the calculated cells - exclude them and compare only formulas. Ignore Formatting. Modified Code. Changed Form Controls. Merge Projects. Resolve conflicted modifications just in a few clicks! Merge Forms. Merge Controls. Merge Properties. You've changed control background color on control - xlCompare will merge it into common version.
You see all controls on the Form including hidden ones. Diff Viewer for Version Control Applications. Compare Files with Common Base Version. Use 3-Way comparison mode to compare changes made by you and your co-worker in the same version of workbook.
0コメント