Open TXT and CSV files in xlCompare

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.

See Also: