Use the example files below to get started.

The file must be either a comma separated value (CSV) file with a .csv extension or a .txt extension. Within the file, each individual address record should be on a line with commas separating each element. In the case where an element already has a comma, you must enclose the element in quotation marks. You can use Microsoft Excel or Microsoft Access to generate the batch file. From the File ribbon in Excel, click Save As and set the Save as type dropdown to "(Comma delimited)(*.csv)." The fields listed below are required in the input file with the exception of the Plus4 field. If your data does not contain values for one of the fields, insert a blank column. Optional - if you remove the first row with the field names before uploading the file your output file will be ready to use with new field names.

• DatabaseId - Information to link the output data back to your database. Insert a column and leave blank if not available.
• Company/Last Name - Insert a column and leave blank.
• Address1 - Street number and name (including pre-directional and/or post-directional, and suffix/street type) or Post Office box number.
• Address2 - Secondary address unit designator and number (such as apartment or suite number). If address1 can be verified, address 2 will not be processed (unless it contains unit information). If address1 cannot be verified, then address2 will be processed and if verified, will be swapped with address1. Insert a column and leave blank if not available.
• City - The city for the address.
• State - The state for the address.
• Zip Code - The Zip code for the address
• Plus4 - The Plus4 for the address. The Plus4 input is optional and you can leave it blank or omit from the input file.

Sample batch file for Excel

Sample batch text file

When you are ready to upload, complete the form below!

You will receive an email with a download link for your job when your submitted job is complete. We have a document to help you review the batch output (this document is also included in the download file).

• The maximum file upload size is 400 MB
• Geocoding - the batch can process about 200,000 records/hour
• If you are submitting a very large batch consider uploading your file close to the end of the day

E-Mail Address:

Select a File to Upload:

Choose a comma separated value formatted file with a .txt or a .csv extension

Result Code Output:
Codes Only Long Descriptions