Import and export
Two buttons at the top of Customs offices work with files:
- Bulk upload adds many offices at once from a spreadsheet: your whole network, prepared offline.
- Export downloads the register, as Excel or CSV.
Before you start
- Bulk upload needs the right to import offices (Organisation admin, Secretariat admin or System admin). Export needs the right to export them. See What each role can do.
- You can only import offices for the countries you maintain. The template already lists them.
Bulk upload
-
On Customs offices, select Bulk upload.

-
Under Download a template, choose one:
Template What it gives you Excel workbook (Recommended) Drop-down lists, typed cells and date rules, so a mistake is caught while you type it. CSV The column headings and one example row. Nothing is checked until you upload. -
Fill the template in offline, one office per row.
-
Back in the window, drop the file onto Drop a file here, or click to choose one, or select it and choose the file. Excel or CSV, up to 5.0 MB and 500 rows.
-
Select Upload. The button stays greyed out until a file is chosen. To leave without importing anything, select Cancel.
Every row is checked as it arrives. A row ITS cannot accept is reported with its reason, and the other rows still go in.
The rules for each row
The window lists them under Before you upload:
- Country, station code, name and office type are required on every row.
- The station code is the three characters after the two-letter country
prefix of the office code: Uganda's Busia is
UGBUS, so its station code isBUS. - Office type decides where a transit may cross a border, so record it accurately. Only an office marked INLAND refuses an entry or transit stamp.
- Leave the neighbouring country empty for a seaport, an airport or any inland office. A border post only faces a country across a land or river frontier.
- You can only add offices for the administrations you maintain.
- An office already in the register is reported, not overwritten. To correct one, edit it on the screen, or export, edit and upload the exported file.
The template's columns
The template has one sheet, Customs Offices, with these columns. The Excel workbook also carries a How to fill in this workbook sheet and drop-down lists.
| Column | Required | What to enter |
|---|---|---|
| Country | Yes | The country the office is in, chosen from the list. Only the countries you maintain are offered. |
| Station Code | Yes | The three-character station code, without the country prefix: BUS, not UGBUS. |
| Name | Yes | The office's name as it should appear on a declaration. |
| Office Type | Yes | BORDER for an office where the customs territory is entered or left, including a seaport or airport. INLAND for anywhere else. |
| Neighbouring Country | No | For a BORDER office on a land or river frontier, the country on the other side. Leave it empty for a seaport or airport, and for any INLAND office. |
| Latitude | No | Where the office is, in decimal degrees north of the equator (south negative), to at most six decimal places, for example 0.636. Fill in Latitude and Longitude together, or leave both empty. |
| Longitude | No | Where the office is, in decimal degrees east of Greenwich (west negative), to at most six decimal places, for example 34.281. Fill in both together, or leave both empty. |
In the Excel workbook, Latitude refuses a number outside -90 to 90 and Longitude one outside -180 to 180 as you type it. A row with only one of the two is refused when you upload it. See The office's position.
Because an existing office is never overwritten by a new row, the way to fix many offices is: Export them, correct the file, and upload the exported file. Do not retype them into a fresh template.
ITS reads an exported file as well as a template: the export carries the full office code instead of Country and Station Code, and the upload accepts either.
Export
-
On Customs offices, select Export.

-
Choose Excel (opens in Excel or Sheets) or CSV (plain text, opens anywhere).
-
Select Export as Excel (or Export as CSV) to download the file, or Cancel.
The file holds the offices your Scope, Country, Type, Status and search leave on screen, every page of them: the row count in the window is the file's. Both formats carry the same columns, with each office's full code in place of Country and Station Code.
To work on your own offices only, set Scope to My administration before you export. A row for a country you do not maintain is refused on upload.