Workbook Compare Pro
← Video library

Pause and guess · 37 sec

They sorted the CSV. Did anything change?

Match CSV records by their unique ID to compare identical data in a different order.

Link to this video

Read the transcript

Someone sorted the export. Did a single amount change? Pause and follow the record IDs. Compared by position, the first row looks completely different. Alice is now in row two of the data. In CSV and TSV options, set Match rows by to Key column. Enter Record ID. Every row needs its own unique, nonblank ID. Compare again. All three records match. The rows moved, and every amount stayed with its owner.

Try the 7-day evaluation