TSM Verifier - TransportMe

Upload your spreadsheet (.xlsx file)
Configure which sheets are STIMS/TME and select key columns for matching
Review STIMS Data tab to see all source records (read-only)
Configure mappings on TME Data tab - select which STIMS column each TME column compares against
Edit TME values by clicking on any cell - differences show the STIMS value below
Import STIMS records (optional) to add missing records from STIMS to TME
Export your corrected TME data when done

Teal = All mapped fields match

Orange = Has differences in mapped fields

Green = You've edited this row

Purple = Only in STIMS (no matching TME record)

Yellow = Only in TME (no matching STIMS record)

Striped Purple = Imported from STIMS

When you export, Column A shows the status of each record:

UPDATED = Record was updated from STIMS data

UNCHANGED = Has differences but was not changed

NO STIMS = Record does not exist in STIMS

NO TME = Record was imported (didn't exist in TME)

MATCHED = All fields match, no changes needed

No Data Loaded