Xeneta can export the data that composes the Benchmarks graph to an Excel report.
To begin, we’ll need to generate the Benchmarks graph for the trade lane or trade corridor whose data we wish to export. Use the dashboard search or your followed trade lanes to reach the Benchmarks graph.
The report exported by Xeneta is affected by the filters you select for the Benchmarks graph. The filters that affect the data exported to the Excel report are as follows:
All other data related to the benchmarks — including market positions and rate quality — will be included by default. All of your uploaded freight rates available for the selected date range will appear as separate sheets in the exported report, separated by supplier name.
Depending on the size of your dataset, generating the report may take some time. Once it is ready, the report will automatically download to your computer.
The exported data will map your supplier prices for the selected origin-destination pair to Xeneta’s benchmark prices for every day included in the date range filter.
With the report available to you, you can use Excel features to transform and manipulate the data.
Creating a table will let you sort and filter your data in Excel. You can create a table in the following way:
1) Select all data columns in the Raw Data sheet.
2) From the Excel Ribbon display, select Insert > Table.
3) Check the My table has headers option and click OK.
Your data will now be structured as a typical Excel table, which can be used to filter and sort your data to your preference.
If you wish to see alternate visualizations of freight benchmark data, you can use Excel to create charts from the exported dataset. In this example, we’ll focus on creating a basic line chart with a trend line that captures the general movement of the market average freight rate.
1) Select the Day, My Price, Market Average, Market Low, and Market High columns in the Excel report.
2) Navigate to Insert and select the 2-D Line Graph chart option.
3) A line graph will be generated based on the benchmark data and the date will automatically be used as the x-axis.
4) Click on the chart and then on the green cross in the top-right corner of the chart to open the Chart Elements menu.
5) Select the Trendline option and then Market Average and click OK.
6) A dotted trendline for the Market Average benchmark will be added to your graph.
Exported reports provide an additional layer of analysis on top of the Xeneta platform. Using Xeneta’s data with Excel can be useful for exploring benchmarking data and understanding the market.