When you click Export on the Road transports list, an export window opens first. Here you choose exactly which columns go into your Excel file, in which order, and how dates and times are shown. You can also save your setup as a template and reuse it later.
New Visibility columns are not added to your export automatically. You decide when to include them, so existing Excel formulas and Power BI reports keep working.
The export window
The window has four parts:
Template: select a saved setup, or leave it on "None - start from scratch". The more actions (...) menu lets you discard unsaved changes or delete a template. An "Unsaved changes" label appears when your current setup differs from the saved template.
File settings: lets your define preferable settings
file name (the .xlsx ending is added automatically)
date format
timezone in which time related fields are converted too
Available columns (left): columns are grouped into sections. Open a section to see its columns. Use a section's checkbox to select or clear all its columns. A counter shows how many are selected, for example 4/30.
Selected columns (right): shows your columns in the order they will appear in Excel. Drag to reorder, or use the bin icon to remove a column. The total column count is shown at the top.
Select Save template on the left of the footer. Cancel and Export are on the right. Export is disabled until at least one column is selected.
Column sections
Transport and status: core transport data such as IDs, status, dates and carrier.
Stop data: stop-level fields such as stop name, arrival time and city. Each selected stop field is repeated for every stop. For example, a transport with 3 stops and 3 selected stop fields gives you 9 stop columns, so the file can be wider than the preview suggests.
Customer-specific fields: fields provided by your company or integrations. This section only appears if your company has these fields.
Carbon emissions: CO₂ and related emission fields
Export with your usual setup
Go to the Road transports tab and click Export.
Leave Template on "None - start from scratch".
Select the columns you need in the left pane.
Drag columns in the right pane into your preferred order.
Set the Date format and Timezone.
Click Export. The file downloads with only your selected columns, in your chosen order.
When you open the export window again, it remembers your last columns, order, file name, date format and timezone in your browser. To repeat an export, click Export and then Export again.
Save and manage templates
Save a template: set up your columns, order, date format and timezone, click Save template, choose Save as new template, enter a name (up to 80 characters) and click Save template. The template then appears in the Template dropdown.
Update a template: select it in the dropdown, change your setup, click Save template, choose Update "name", then click Update template.
Discard changes: open the ... menu next to the template and choose Discard changes.
Delete a template: open the ... menu, choose Delete template and confirm. This cannot be undone.
Templates are private. Only you can see the templates you create.
Good to know
Only the columns you select appear in the file, in the order you chose.
If a template has no timezone saved, your own timezone is used.
The default file name is YYMMDD-visibility-shipments-report. You can change it.

