If you are currently working with an ids.xls file, let me know or what task you are trying to complete (e.g., migration, lookup, clean up) so I can provide specific formulas or scripts to help. Share public link
High risk of manual data corruption (e.g., accidental sorting of a single column that breaks ID alignments).
If you are an administrator or data analyst responsible for generating identity files, stop using the .xls format.