Possible to run a test saying if two large tables are equal? Or if two rows are equal?

I have a program that gives me a .csv file output to check to see if data in the program has changed to compare against my access database.
I take the .csv file and paste my access file data for the same timeframe and same fields into column AF then put this formula in cell Q2 =IF(A2=AF2,"","NO") then drag across to AE2 then autofill to the end of the data, make sure the sort ascending is based on the same field (in this case an ID) so that the columns A and AF should match. Then apply a filter to columns Q through AE and look for any "NO" and that shows me which if any fields have changed.
Perhaps that will give you some idea of what you could do. I'm sure there are other ways.

Since you have Office 365. You can use PowerQuery (Get & Transform).

Add both tables to PQ, and join (merge) tables using all columns as key. Using Left/Right Anti join to return rows only found on one side, to show where there's mismatch.