To diff specific columns of two .csv files, using miller CLI tool and process substitution <()

$ colordiff -u <(mlr --icsv --opprint cut -f 'id,avg_sourcing_spread' then format-values -f '%.4lf' then put '$avg_sourcing_spread=round($avg_sourcing_spread*100.0)' service.csv) <(mlr --icsv --opprint cut -f 'id,sourcing_spread' then format-values -f '%.4lf' then put '$sourcing_spread=round($sourcing_spread*10000.0)' superset.csv)

We can also use the spreadsheet to diff two tables:

  1. highlight the first table
  2. select the conditional formatting tool
  3. add the rule A1<>Sheet2!A1

In LibreOffice Calc there is a specific tool to compare tables.

  1. Open Document B
  2. Click Edit > Compare Document
  3. Choose Document A
  4. The resulting dialog should list the differences