Compare two spread sheets and identify differences

I have a spread sheet that lists document ID number, document date (date document is planned to be issued) and multiple other columns of document data. The original document list is modified and a new one created. I would like to compare the new list to the old list and have the new,deleted,and modified items identified in some manner.
1.
Any thoughts on how I could proceed?
2. Is there a way to extend the above to a general spread sheet to spread sheet comparison with differences identified such is done in Microsoft Word?
Thanking you in advance.
Bill