Why are leading zeros missing in the Excel file I want to import?

Leading zeros in number fields such as zip code and D-U-N-S® Number are not visible in Excel unless you apply custom formatting. For example, a D-U-N-S® Number with leading zeros such as 001234567 appears as 1234567 by default in Excel.

To include leading zeros, right click on an entire cell range (e.g., the D-U-N-S® Number column in Excel), select the Format Cells option, select the Custom category, and under Type enter the number of zeros corresponding to the number of digits in the field. For example, you’d enter 9 zeros for the D-U-N-S® Number column of your Excel file.