The exported CSV file opens in Excel. Due to the default settings in Excel, zip codes that begin with a 0 may appear as four digit zip codes in your exported file. This could affect records from the following states: 

  1. Connecticut

  2. Massachusetts

  3. Maine

  4. New Hampshire

  5. New Jersey

  6. Rhode Island

  7. Vermont

To revert these zip codes back to their full 5 digits, open your export in Excel and highlight all zip codes from within the Zip column.

Click Format > Cells to open the dialogue box. 

Choose Special > Zip Code, and click Ok.

Your zip codes should now show as full 5 or 9 digits with any 0s in front that are applicable.

Still need help? Reach out to us using the on-screen help message icon or by emailing us at

Did this answer your question?