How to import your contact list from Excel

How to import your contact list from Excel

To open this article in a new tab, click here.

There will be times when you need to upload multiple airline contacts from an Excel list. In this article, you’ll find out how to use Freightos Rate & Quote's contacts import feature. Before starting, make sure that you have Microsoft Excel installed or that you have your contacts in a G sheet and downloaded as a .xsv file.
  1. Download the Freightos template

To upload your contacts, you will need to first of all find the Freightos standardised template so you can fill in your contact details. To find this, head to the Tools tab and then click on Templates. From here, find the template named ‘Customised contacts’ then click on the Excel icon under the Downloads column.

Once the Excel file has loaded, click on the file and open it.

2. Enter your contact details

Once inside the file, you will see a colour-coded key which tells you what every column means.

Once you’ve familiarised yourself with the columns, you can start to upload your contacts.

Once you’ve entered all of the information for each contact, you can then save the file and prepare it for upload. The more information you enter will be better for your contact details.

Important: in order to successfully upload, you will need to remove the colour coded key at the top of the Excel file. Make sure that the top column starts with the Airline Code column.

Once you have checked everything and deleted the key, save the file, but remember where you save your file.

3. Uploading your file

When you’ve finished entering your contact details, saved and checked there are no columns that shouldn’t be there, you’re ready to upload your file. To do this, head to Settings and then Contacts.

Then click on the arrow symbol next to the plus symbol underneath the search button.

Click on Choose file and find the previously saved Excel location. If you want to overwrite all previous contacts, you can select the box. Beware that this will remove all previously uploaded contacts and they will be replaced with the new list.

Once you’ve found the file, select it and, once added to the upload box, click Import. If there are any issues with your file upload, you will receive a notification telling you which columns aren’t quite right. If this is the case, open the Excel file and make the suggested changes.

Once your file has been uploaded successfully, you should receive the following notification:

4. Finding your new contacts

When the file upload has finished, you can use the filters to find the newly uploaded contacts. Select the GSA, Airline and, if necessary, the city too. Click ‘Search’ and they should show up in the search results.

If you have any other questions about how to add airline contacts using the upload tool, you can chat to us by clicking on the green speech bubble icon located at the bottom right-hand side of your Rate & Quote account.


    • Related Articles

    • How to upload multiple clients using an excel file

      To open this article in a new tab, click here. You can upload multiple clients with conditions at one time by using the Excel file upload feature on your account. Important: this feature is only available for Professional, and Enterprise account ...
    • How to upload rates

      To open this article in a new tab, click here. If you have a global Freightos for Forwarders account, you can add main leg rates for specific clients. This allows you to upload rates and to use them for quotations. Using the global rate upload ...
    • How to upload your client details using an Excel file

      To open this article in a new tab, click here. Using the multi-client upload tool, you can upload information for multiple clients at the same time using the XLSX file uploader. Firstly, open the side menu, select the Accounts and pricing section, ...
    • How to add individual clients

      To open this article in a new tab, click here. When searching for static rates, you may want to apply specific client conditions or profiles for repeat quotes. You can add and select specific client conditions depending on weight breaks, services and ...
    • How can I contact you?

      You can get in touch with us through any of the following methods: Online Contact Form Submit your inquiry through our contact form for a response by email. By Phone Call us directly on the numbers below: US: +1 888 727 0239 UK: +44 800 260 6989 Live ...