Most address upload errors can be resolved by using our official templates and ensuring all required columns are filled correctly. For complete instructions on how to upload your file, please see How do I upload addresses to my address book?.
If you are experiencing errors during the upload process, check your spreadsheet for these common issues:
| Common Error / Issue | How to Fix |
| Wrong file type | We only accept Excel spreadsheet files (.xls or .xlsx). We do not accept Apple Numbers files, PDFs, Word documents (.doc or .docx), or other file formats. If you are using another program, please export or download your file as an Excel spreadsheet before uploading. |
| Missing or extra columns | Do not add or remove any columns from the template. The U.S. template requires exactly 6 columns, and the International template requires 5. Leave the column header in the spreadsheet even if you are not using an optional column like Address 2. |
| Missing required information | Recipient Name, Address 1, City, State, and Zip Code must be filled out for every U.S. recipient. Address 2 is the only column that can remain blank (for International addresses, Address 3 can also remain blank). If you are missing required information for a recipient, remove the entire row before attempting your upload. The error message will tell you which rows have the issue. |
| State not selected | For U.S. addresses, use the exact state abbreviations or spellings provided in the template's dropdown menu. |
| Zip Code is not valid | Ensure all zip codes are 5 digits and there are no blank cells in the zip code column. If your spreadsheet application (like Excel) automatically removes the leading zero from a zip code, type an apostrophe before the zero (e.g., '01234) in the cell to force it to display correctly. |
| Country cannot be blank | For international addresses, ensure the Country column is filled out. |
Template Downloads
- Download U.S. Template (includes military and U.S. territories)
- Download International Template
If you continue to experience errors, please contact our support team and attach your spreadsheet to your request so we can assist you.