Client Query - Data import missing leading zeros

This is a feature of many spreadsheet programmes and can be worked around. Before you being populating your spreadsheet, decide if you need leading zeros and if so change the format of those columns to text.