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:
- New Hampshire
- New Jersey
- Rhode Island
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 firstname.lastname@example.org.