Working with text file formats in the xlCompare
xlCompare works not only with Excel file formats - XLS and XLSM\XLSX. But with TXT and CSV files also.
Q: Does xlCompare support all variations of the text file formats?
A: No. xlCompare supports:
- Tab-delimited text file - this is .txt file, in which values in each row are separated by TAB character.
- CSV file - this format is not so easy as you may think. But, xlCompare works with files where values are separated by the list separator.
Typically this is , or ;.
Both formats are widely used to store database data. You can use xlCompare to compare\merge your databases.