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 and I noticed that required column W (zip codes) lists four-digit codes whenever 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.