Most spreadsheet software does that because the zips are parsed as integers, not strings . Prefix numerical fields that may contain leading zeros with a non-numerical character/word and save yourself the pain of late discovery! You can just find and replace after it goes in successfully.

Spoken as someone that experienced the same pain years ago in local SEO data that made it way too far before discovery...