Skip to main content
Avalara Help Center

Are leading zeroes needed for the import template's zip codes?

Overview

I am preparing the excel file for import. Noticed that required column W ( zip codes) have four- digit codes where the first character is zero.

Environment

 Avalara Avatax

Resolution

  • Leading zeroes are required for zip codes that have them. You will receive an invalid address error otherwise.
    • Try '01234 (') before the zero to work around this.
    • Alternatively, format the column as Text and save as an Excel document rather than CSV