# Export my Routes

## 1. Introduction

This guide will teach you how to select, customize, and export your completed routes using the route management system. Whether you need to share results with a team member via Excel or integrate data into a calendar, this process is designed to be straightforward and effective.

## 2. Initial Configuration

**Customizing Your Excel Export Settings**

When you choose to export to Excel, the system provides several options to tailor the resulting file.

1. **Select Your Sheet Layout:** Choose how the route data is organized:

   * **One sheet for all deliverers**.
   * **One sheet per deliverer**.
   * ***Context**:* This helps you decide if you want a consolidated view or detailed reports for individual team members.

   <div align="left"><figure><img src="https://3958050598-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7B1Ne0ZrVfxiqlDxzTPm%2Fuploads%2F4n2oTLsw1Uws7oJX99wX%2Fimage.png?alt=media&#x26;token=842a829f-4eee-45c8-b57e-14a896f7fb27" alt=""><figcaption></figcaption></figure></div>

💡 **Tip:** These configurations only apply to the Excel export option. Other formats (like PowerPoint or Calendar) will use their standard output settings.

2. **Selecting Custom Fields (Columns)**

You can choose which specific columns (fields) appear in your exported file.

1. Click on **other** within the configuration window.
2. You will see a list of **available fields** and **display fields**.

<figure><img src="https://3958050598-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7B1Ne0ZrVfxiqlDxzTPm%2Fuploads%2FwMqYRVyG4hNTufFP2DEG%2Fimage.png?alt=media&#x26;token=be7d4092-1148-49c2-98e2-50aa186818a5" alt=""><figcaption></figcaption></figure>

3. You can also **enable the custom configuration** if needed.

* *Context:* When finished, the export file will contain both **standard and mapped columns**.

4. Click **Save** when you are done customizing the fields.

***

## 3. Feature Explanations and Benefits

The primary benefit of the route export feature is its flexibility, allowing you to quickly share data in formats suitable for various stakeholders.

#### Diverse Export Destinations

By clicking the **export option** and selecting **other**, you unlock a wide array of export types.

| Export Feature                                                   | Benefit/Usefulness                                                                               |
| ---------------------------------------------------------------- | ------------------------------------------------------------------------------------------------ |
| **Export to Excel**                                              | Ideal for detailed data analysis, calculations, and structured reporting.                        |
| **Export to PowerPoint / Office 365 PowerPoint / Google Slides** | Useful for quickly generating presentations or summaries for meetings.                           |
| **Export to Calendar (Office Outlook / Google)**                 | Allows route schedules and timings to be integrated directly into personal or team calendars.    |
| **Export a summary of routes send by email**                     | Efficiently shares a high-level overview of the route plan with recipients.                      |
| **Export to Masternaut .GPX / Extended .GPX**                    | Necessary for use with specific GPS navigation systems or advanced mapping software.             |
| **Export to KML format Google etc.**                             | Standard format for viewing geospatial data (like routes) in mapping tools (e.g., Google Earth). |
| **Export to Webhook**                                            | Facilitates automated data transfer to other operational systems.                                |

## 4. Exporting a Route to Excel

This is the most common task and includes selecting the route, choosing the destination, configuring settings, and finalizing the download.

Follow these steps to successfully export your selected route:

**Locate Optimization Section**

1. Start from the system **home page**. Click on Optimization

**Select the Route**

2. **Click the route** that you wish to export.

<figure><img src="https://3958050598-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7B1Ne0ZrVfxiqlDxzTPm%2Fuploads%2FV9RAvLKsqemsU2oM2bhp%2Fmsedge_IxNELUyjK3.png?alt=media&#x26;token=06d9efcf-2acd-44b1-8c64-c2e393e737d4" alt=""><figcaption></figcaption></figure>

3. **Initiate the Export Dialogue**

**Choose Excel Format**

4. Since you wish to export the data in Excel, click on **export to Excel**.

<figure><img src="https://3958050598-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7B1Ne0ZrVfxiqlDxzTPm%2Fuploads%2FXVMrQMhNhZc58VRQPeCX%2Fmsedge_Nzp886r8us.png?alt=media&#x26;token=999dbd2b-78b8-4083-94d9-bb39107b7f24" alt=""><figcaption></figcaption></figure>

**Configure and Generate the File**

5. Review and adjust your initial configuration settings (Sheet Layout, Timings, Data Integrity) as outlined in Section 2.

<figure><img src="https://3958050598-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7B1Ne0ZrVfxiqlDxzTPm%2Fuploads%2FIvaaIzOqxkP6wLv5arMn%2FOperationsandRouteManagement-ExportmyRoutes_timestamp_1_to_09%E2%80%931_to_15.gif?alt=media&#x26;token=4c0b0c25-c12b-4104-a9b8-e88e7b5c78bf" alt=""><figcaption></figcaption></figure>

6. If you customized fields, ensure you clicked **Save**.

<figure><img src="https://3958050598-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7B1Ne0ZrVfxiqlDxzTPm%2Fuploads%2FnfR1Z94Q9sjKY7ALFw9e%2FOperationsandRouteManagement-ExportmyRoutes_timestamp_1_to_46%E2%80%931_to_53.gif?alt=media&#x26;token=ae8c9def-4f59-4d9a-a2e8-227225e9cdcc" alt=""><figcaption></figcaption></figure>

**Finalize Export and Open File**

7. Click the **downloaded file** to open it

<figure><img src="https://3958050598-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7B1Ne0ZrVfxiqlDxzTPm%2Fuploads%2F3ZpHFJd5YpC2CgdQ2JCC%2FOperationsandRouteManagement-ExportmyRoutes_timestamp_2_to_31%E2%80%932_to_34.gif?alt=media&#x26;token=9983b970-38f7-4f23-ac3e-f6b177a58251" alt=""><figcaption></figcaption></figure>

8. Please find the **downloaded excel file** below.

<figure><img src="https://3958050598-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7B1Ne0ZrVfxiqlDxzTPm%2Fuploads%2Fgit-blob-f4d7826e888f44573b62a0fa2de9f1dd36199fae%2FEXCEL_93xWEQKAjS.png?alt=media" alt=""><figcaption></figcaption></figure>

***

## 5. Productivity Tips

Here are some ways to make the route exporting process more efficient:

* **Customize Columns for Efficiency (Filtering Data):** If you only need two or three specific data points for a quick analysis, use the **other** option in the configuration menu to remove unnecessary fields. This keeps your report clean and focused, ensuring the export file contains only **standard and mapped columns** that matter most.
* **Use Calendar Export for Scheduling:** Instead of exporting complex data, use the **export to calendar** option (Office Outlook or Google) to quickly give deliverers their finalized shift timings and route appointments, simplifying daily logistics.
* **Save Configuration Time:** Once you have set up your desired sheet layout and field selections (like generating **one sheet per deliverer** or including **shift timings**), click **Save**. This allows you to quickly execute the export in the future without re-selecting all the detailed configurations.
