Import rates with Excel templates
Proxio's Excel based import templates can be used to import your rates into Proxio.
Written By Johan Vagerstam
Last updated About 2 hours ago
Download the templates from ‘Rates’ > ‘Rate documents’ > ‘Import’. In the left panel, under ‘Import templates’, select ‘Standard template’ or ‘Multileg template’.

About using Excel Rate import templates
The templates can be used to import rates in a structured way, following the instructions and documentation that are available inside the template.
There are two worksheets (tabs) in the Excel template files.
Import - This worksheet is where you add information about the tariff / rates. This is the actual data that will be imported.

Documentation - This is a worksheet where you find instructions and examples about the data, if a column is optional or mandatory.

Note:
The standard import template is a general template used for many (but not all) rate formats. The documented descriptions gives guidance about how to fill in the template, but there can be situations where a column value is mandatory although documentation say it’s optional.
The standard template cannot be used for distance based pricing logic - e.g. when one of the price axis are distance based. For distance based pricing please use the Import Wizard (see the article Using the Import wizard).
Naming guidelines for Excel templates
The Tariff Name entered in the import template is very important. If you want to add all data in the Excel file into one tariff/rate sheet - you need to specify the exact same Tariff Name on every row. For more information, please review the column description table below.
Standard import template
Use this template when you have prices of a relation/lane based transport. This is often used for A→ B Transports, from a supplier to a factory or from a warehouse to a customer.
Below is a summary of the columns in the import template and description of each column. (The descriptions are also available in the Documentation tab in the Excel template.)
As example, here is a standard template with example data for FCL (Full Container Load). As the name for the rows in the example are the same, they would be added into the same Tariff/Rate sheet after the import is made in Proxio.
SEA-FCL-Example filled in.xlsx
40.7 KB• Spreadsheet
Location, units and column names
City, state and location code. The templates have separate columns for city, for state/region/province and for location code, for both origin and destination. Use state/region/province for countries like the US, where a city and postal code are not enough. Use a location code for places such as airports (IATA) and ports (UN/LOCODE).
Older templates still work. Files with the old column headings can still be imported.
Columns are read by name. Proxio reads the columns by their heading, not by their position. Keep the headings exactly as in the template, but you can change the order of the columns.
Metric or imperial units. A tariff can state if it uses metric or imperial units. For Proxio's predefined carrier services, weight and volume limits are converted to the units of the service. For services described in the spreadsheet, the units and values in the file are kept as they are, also in multi-leg tariffs.
US ZIP codes. 12345 and 12345-0000 count as the same place. Proxio still stores the code as you typed it.
Re-importing rates
When you import new rates for a rate sheet that already exists, Proxio reuses the existing rate sheet if the name, services and legs match:
Same start date (Valid From): the current revision is updated.
New start date: a new revision is added.
If you change the dates of a revision to correct it, the revision keeps its identity. You cannot edit a revision until it has fully loaded.
Exact values and ranges. Freight columns can hold exact values, for example a set number of pallet places, as well as ranges. More pallet place headings and price headings with units are supported. If a column in the freight price section is not recognised, the import stops with an error, so no prices are left out without you knowing.
Standard Multileg template
Use this template when you have pricing of multiple transport legs. This is most often used in Air and Ocean when there are pre-carriage, main carriage and on-carriage.
An example:
Pre-Carriage: Inland transport pricing by road from a factory to a sea port.
Main-Carriage: Sea port to sea port pricing for on ocean container transport.
On-Carriage: Inland transport pricing by road from sea port to a warehouse.
The prices of multi leg transport allows for a combination of multiple pricing sheets into one worksheet, e.g. the Excel based multi leg template.
Note: For the multileg template, there are extra options to add three (3) types of surcharges. You can build up the columns so they fit the price brackets you would like to import.
As example, here is a multi leg template with example data added to pre-carriage, main-carriage and on-carriage. As the name for the 3 rows in the example are the same, they would be added into the same Tariff/Rate sheet after the import is made in Proxio.
[Add attached file with example rows filled with multileg example-template]
Customized import template
If you have needs that goes beyond the standard templates, there is an option to adjust the import templates to your own formats. Consult your Key Account Manager or contact Proxio support team if you are interested in learning more about customised import templates.
How to Import an Excel Rate template
Follow these steps to import your rates in Proxio.
select ‘Rates’ > ‘Rate documents’ > ‘Import’. Select the file you want to import.
When the file is uploaded you can view it in the list view.

Click on the drop-list icon, and select ‘Relation-tariff template, Multiple tariffs‘ if you import rates using the standard template (single leg) or select ´Relation-tariff template, Multiple tariffs´ if you are using the multileg template.
On the following screen, you have some optional fields to add a suffix or prefix. Just click ‘Queue import‘. The file is now pending import on the server. After a few moments the import should start. The time can vary depending on server load at that time.
When processing is done and successful, the rate-sheet(s) create will be available as links in the dialogue. In this example, one bid sheet was created.

Was this helpful?
Still need help? Share an idea