GEO-Address Excel Spreadsheet Layout

The submitted files should be in Microsoft Excel 2000 or greater format.  Each file may only have up to 10,000 local tax jurisdiction requests.  The files may be submitted via e-mail attachment if the file size is less than 2 MB to tax@columbus.gov.  Otherwise, the files should be burned to CD and mailed to:

City of Columbus
Income Tax Division
C/O Administrative Secretary
50 W Gay Street
Columbus, OH 43215 

After the file has been updated with the Local Tax Jurisdiction name, it will be sent back in the same manner as it was received.  If the file was burned to a CD and sent in, please include a blank CD for the updated file.

File Layout - The application expects there to be a worksheet present that is named Sheet1.

Mandatory Columns - These columns must be present (in any order) and spelled exactly correct.

1. Address (should be address line 1 - do not submit PO Box or addresses which include a PO Box)
2. City (postal city)
3. Zip (not including the +4 - submit only zip codes within Central Ohio)
4. LTJ - Local Tax Jurisdiction (this column will be updated with the corresponding city)

Optional Columns - There can be many other optional columns present.

Below is an example of what a typical file should look like...