You guys are on the ball! Yeah, I was thinking just one more download option that had the correct columns in the correct order.
This isn't quite perfect though because, as far as I understand, the parts only have manufacturer numbers by default. I have to manually add supplier pns to a custom attribute. Which would be fine. But then the name of the supplier pn attribute needs to be strictly defined so that custom bom csv would pull the right attribute into the right column.
Without specifying an exact supplier pn, I still need to edit most lines in the Digikey order because they won't necessarily default to right packaging option (eg: cut tape). Supplier pn is always more precise and avoids issues with poorly defined manufacture pns when it comes to temp codes etc.