Advertisement

Frequently Asked Questions

How do I start comparing Excel files in xlCompare?

Open xlCompare, click 'Compare Files,' select your Excel files (XLS, XLSX, CSV), then click 'Compare' to begin analysis.

Can I compare two Excel files with different structures?

Yes, xlCompare compares files by key columns, handling differences in structure, formulas, and data for comprehensive comparison.

How do I generate a comparison report after analyzing files?

After comparison, click 'Create Report' to generate a detailed report highlighting differences, which can be exported as needed.

What are the main differences that xlCompare detects?

xlCompare finds differences in cell values, formulas, named ranges, and Visual Basic forms, providing a thorough comparison.

How does xlCompare handle XML file comparisons?

It compares XML files as trees, ignoring node order and namespaces, using key attributes to identify differences.

Can I compare and merge files stored in version control systems like GIT or SVN?

Yes, xlCompare works as an external diff and merge tool for GIT, SVN, Perforce, and more, facilitating version management.

Is there a way to debug formulas and trace calculations within Excel files?

Yes, use xlCompare's calculation tracing feature to evaluate subexpressions and identify input/output cells in your workbook.

What are the limitations of the evaluation version of xlCompare?

The evaluation lasts 15 days and does not allow saving files; full features require a purchase.

How do I compare two files to see only the changed rows?

Select the 'Changed Rows' filter after comparison to view and export only modified data in your files.

How do I resolve merge conflicts in Excel or XML files using xlCompare?

Use the 3-way compare feature, review differences, and choose which changes to keep to resolve conflicts easily.

You May Like