This article explains steps you can take to import locations. For definitions of each column in the template, view the Import Locations - Definitions article.
Note: Make sure your Top Level GLN is “Published” before you import any “Published” GLNs. The Top Level GLN may be entered as “Administrative Parent” or “Parent Org” for any GLN you are importing.
1. To import locations, click Location from the top navigation bar, then the Import Locations link.
2. Click the Download Template button to download an Excel spreadsheet template so you can enter this data, then import this file into GS1 US Data Hub. This template does not include any pre-populated data.
Columns in bold are required. Columns have specific colors based on the GLN Type you are assigning to the GLN. The first 12 columns (A through L) are in blue and apply to the entire GLN.
3. Save the template to your computer.
Note: When you save this file, do not include the following symbols in the filename, otherwise you will receive an error when you process the file: ; / ? : @ = & " < > # % { } | \ ^ ~ [ ] `( )
4. Open the template and enter party or location data. To learn which values can be entered in columns, click the “Input Values” tab at the bottom of the template. You can copy a value from the Input Values tab and paste it in the appropriate column.
Note: If you did NOT yet assign a GLN to this location or party, leave the GLN column blank (as shown on the screen below). GS1 US Data Hub will automatically add the next available GLN, based on the GS1 Company Prefix you enter.