---
metadata:
  - name: generator
    content: Diplodoc Platform v5.57.3
alternate:
  - https://yandex.com/routing/doc/en/lite/guide/address-book.md
  - https://yandex.com/routing/doc/ru/lite/guide/address-book.md
  - href: en/lite/guide/address-book.md
    type: text/markdown
    title: Markdown version
  - href: llms.txt
    type: text/markdown
    title: llms.txt
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.com/routing/doc/en/llms.txt

# Address book

To save frequently used addresses and use them when creating orders and planning, use the address book. To make it available, open **Settings** and enable the **Saved addresses** option. The table with the saved addresses will appear under **Master data** → **Addresses**.  

Here, you can:

* [Add an address manually](#add-manual).
* [Upload addresses from Excel](#add-via-excel).
* [Edit addresses](#address-edit).
* [Delete addresses](#delete-address).
* [Plan routes](#planning-on-address-book).

The address table has the same fields as the [order settings](https://yandex.com/routing/doc/en/lite/guide/orders.md) and has a similar workflow.

![](_images/address-book.png){style="border: solid 1px #cccccc; max-width: 800px;"}{.container-gallery}

## Adding an address manually {#add-manual}

1. Go to **Addresses**.

1. In the upper-right corner, click **Add address**.

1. You can fill in the **Address**[*](*required) field in one of the following ways:

    - Type in the address.
    - Select the location on the map. The selected location will appear in the **Address** field.

      You can move the marker if needed, and the address will update automatically.

1. Fill in the following fields:

    - **Delivery time**: Time interval in which the location needs to be visited. If not specified, the default period 00:00–23:59 is used.
    - **Service duration**: Time allocated for visiting the location. If not specified, the value from the [company settings](https://yandex.com/routing/doc/en/lite/guide/settings.md) is used.
    - **Company**: Company name.
    - **Recipient**: Recipient's name.
    - **Phone number**: Recipient's phone number.
    - **Comments**: Comments on the location.

    ![](_images/new-address.png){style="border: solid 1px #cccccc; max-width: 800px;"}{.container-gallery}

1. Click **Save**.

## Adding an address via Excel {#add-via-excel}

To import addresses from an Excel file:

1. Go to **Addresses**.

1. Click **Upload from Excel**.

1. Download and fill out the [template](https://courier-admin.s3.yandex.net/lite/import-userplaces-examples/en/Locations.xlsx).

1. Click **Upload**.

In case of upload errors, download the file with errors, fix them, and upload the file once again.

Only new addresses will be added to the address book if you upload addresses from a file. If an address is already in the list, it won't be added again, changed, or deleted. 

After the file is successfully uploaded, you'll see the number of imported addresses.

## Editing an address {#address-edit}

To edit an address:

  1. Go to **Addresses**.

  1. Select the address.

  1. Enter the new value in the field you want to change.

  1. Click **Save**.

To change the location on the map, move the marker where it needs to be.

## Deleting an address {#delete-address}

To delete an address:

  1. Go to **Addresses**.

  1. Open the address.

  1. In the lower-left corner, click ![](_images/trash.svg).

  1. Confirm your action.

## Planning routes from the address book {#planning-on-address-book}

1. Go to **Addresses**.

1. Select the addresses.

1. Enter the planned date.

1. Assign a courier to the selected addresses in one of the following ways:

    - Manually from the list.
    - Using [automatic planning](https://yandex.com/routing/doc/en/lite/guide/planning.md#automatic-planning): Select **Assign to couriers**.

1. Click **Build route**.

![](_images/address-to-courier.png){style="border: solid 1px #cccccc; max-width: 800px;"}{.container-gallery}

To view the resulting solution, [edit](https://yandex.com/routing/doc/en/lite/guide/planning.md#edit-route), and [send the route for processing](https://yandex.com/routing/doc/en/lite/guide/planning.md#route-send-to-work), open **Route planning**.

<!-- source: en/lite/guide/_includes/feedback.md -->
<a href="../feedback">
  <span class="button">Contact support</span>
</a>


<!-- endsource: en/lite/guide/_includes/feedback.md -->

[*required]: Required field.