Does the “ref” column need to be numeric?

No, as long as the “ref” column is a unique identifier for the source row, and is less than 50 characters, it can be anything. However, it is generally a good idea to keep it a simple sequential number to make looking them up easier when researching overlaps or other issues identified by AceMapper.