Follow

How Can I Compare Two Excel Files For Differences ?

VisibleThread Docs does not directly support comparing 2 excel spreadsheets. However there is a workaround that can work pretty well.

  1. Take sheet 1 in workbook 1, save as CSV from Excel. Save this CSV as 'sheet 1.csv'
  2. Take sheet 1 in workbook 2, save as CSV from Excel. Save this CSV as 'sheet 2.csv'
  3. Next close Excel and open each of these CSV's in Notepad
  4. Copy and paste the contents of 'sheet 1.csv' into Word, save as 'sheet1.docx'
  5. Copy and paste the contents of 'sheet 2.csv' into Word, save as 'sheet2.docx'
  6. Upload 'sheet1.docx' & 'sheet2.docx' to the same folder
  7. Run compare against them

 

excelCompareSupportArticle2.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.