Skip to content

Can I export data to Excel or a PDF?

Yes. You can export the Main Content table and the summary tables to Excel. You can export the Pivot Summary to a PDF.

Before you start: upload a file, or open one that you uploaded before.

  1. In the Function Menu on the left, open Visualization and click Main Content.
  2. Click Export To Excel (1 in the picture). You can do this at any time. The data on your screen is exported to an Excel file.

Main Content screen with the Export To Excel option highlighted in the Function Menu

If a filter is on, only the filtered data is exported. If you changed which columns are visible, only the visible columns are exported.

The summaries in the Analytics section have options to export their tables to Excel. These are Cargo Summary, Route Summary, Bay Summary, Height Summary and Allocation Summary (1 in the picture).

  1. Open one of the summaries.

Analytics section of the Function Menu with the Cargo Summary, Route Summary, Bay Summary, Height Summary and Allocation Summary options highlighted

  1. In the Function Menu, click an Export option (1 in the picture). The summary table downloads as an Excel (.xls) file. If a summary has more than one table, for example Route Summary, the Function Menu has one Export option for each table.

The Route Summary page with the Export options for each summary table in the Function Menu

  1. In the Function Menu, open Analytics and click Pivot Summary. Three buttons show below it: Hide Report Options (1 in the picture), Show Table Options (2) and Export To PDF (3).

The Pivot Summary menu with the Hide Report Options, Show Table Options and Export To PDF buttons

  1. Change the pivot table as you need.
  2. Click Export To PDF (1 in the picture). The pivot table downloads as a PDF.

The Pivot Summary with the table options shown and the Export To PDF button in the Function Menu

To download your BAPLIE data as a .txt file, or to convert it to another BAPLIE version, click here.