---
metadata:
- name: generator
content: Diplodoc Platform v5.52.0
alternate:
- https://business.yango.com/support/en/branches/branches-csv.md
- href: en/branches/branches-csv.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://business.yango.com/support/en/llms.txt
# Updating data via CSV files
To set up automatic daily updates for branch data, create a CSV file.
CSV is a text format for representing tabular data. The first row contains column names and the next rows contain data itself. The contents of the columns are separated from each other by a comma.
You can download a [sample CSV file](https://doc-static.yandex.net/src/support/business-priority/en/import-branches-example_eng.csv).
To see the example in LibreOffice, import the text: select UTF-8 encoding, comma as a separator, and double quotes as a text qualifier.
To see the example in Excel, open it in **Data** → **Get external data** → **From text**. Select UTF-8 encoding, comma as a separator, and double quotes as a text qualifier.
## Step 1. Prepare a CSV file {#step-1}
### Content requirements {#requirements}
{% note alert %}
If these requirements aren't met, or if the file data doesn't match the website, the file won't be published.
{% endnote %}
Moderators verify that the data in the file matches the data on the website:
- **Address**
Legal addresses don't need to be included.
- **Phones**
Numbers must be identical.
If the website displays proxy numbers that differ from those in the file, specify this when submitting the file.
- **Business hours**
If any locations have restricted access, specify this when submitting the file.
- **Category**
The primary category must be the same on the website and in the file.
Categories must be semantically compatible.
Correct: `Tire fitting, Auto repair shop`
Incorrect: `Tire fitting, Confectionery`
- Number of branches.
- No duplicates — no two organizations may share identical addresses or coordinates.
{% note info "Exceptions" %}
Categories that may share an address but must have distinct coordinates (differing by more than 30 meters):
- **ATMs**
- **Parcel lockers**
- **Vending machines**
- **Payment kiosks**
{% endnote %}
The following attributes are recommended to match the organization's website:
- **Extension number**
- **Additional categories**
- **Holiday hours**
- **Building number and letter designations in addresses**
### Technical requirements {#requirements-tech}
1. File data must be UTF-8 encoded.
2. Use a comma as a column separator.
### Attribute description {#parameters-description}
#|
||**Attribute**|**Description**|**Required field**||
||`name`|{% include [popup-name](../_includes/popup/id-popup/name.md) %}|Yes||
||`country`|{% include [popup-country](../_includes/popup/id-popup/country.md) %}|Yes||
||`address`|Full branch address, down to the building number.|Yes||
||`address-add`|{% include [popup-address-add](../_includes/popup/id-popup/address-add.md) %}|No||
||`phone`|
A phone number with the country and area code. If there are multiple phone numbers, separate them with a semicolon (`;`).
Correct: `+44 (7700) 123-456, 100`
Incorrect: `+44 7700 123-456 доб. 100`|Yes||
||`rubric-id`|[The ID of the business category](https://doc-static.yandex.net/src/support/business-priority/en/rubrics_en.xlsx) this branch belongs to. If there are multiple business categories, separate them with commas. Branches can have up to three business categories, but at least one of them should match the chain category.|Yes||
||`url`|{% include [popup-url](../_includes/popup/id-popup/url.md) %}|Yes||
||`add-url`|An additional website for the chain (for example, a link to a social media page).|No||
||`working-time`|{% include [popup-working-time](../_includes/popup/id-popup/working-time.md) %}|Yes||
||`scheduled-working-time`|{% include [popup-scheduled-working-time](../_includes/popup/id-popup/working-time.md) %}|No||
||`lat`|Geographical latitude of the branch location. Use a dot as the decimal delimiter.|Yes (if the address is incomplete)||
||`lon`|Geographical longitude of the branch location. Use a dot as the decimal delimiter.|Yes (if the address is incomplete)||
|#
## Step 2. Upload the file to the website {#step-2}
Upload the file to your website using an updatable link. The data should be accessible via HTTP or HTTPS.
## Step 3. Add a link to the file in Yango for Business {#step-3}
1. On the chain page, go to **Branches**.
1. Under **Branch management**, choose **File**.
1. Add a link to the file, select the **CSV** type, and click **Check**. Checking the file may take several hours.
1. If the file is verified successfully, click **Post**. In the window that opens, check the changes in the branches. The map can show up to 50 branches with changes. Click **Yes, start the upload**. The file data will be moderated and uploaded to the Yango for Business database. If the file is large, the data upload may take several days.
If errors are found when checking the file, you'll see an error message. Fix the errors and re-submit the file for review.
To view the branch changes uploaded to the Yango for Business database from the file, click **Upload history**. The button is available within 24 hours of the first upload.
To update the data once, save the file in CSV or XSLX format and send it using the [form](https://business.yango.com/support/en/troubleshooting/main.md). Include your business's email address and phone number in the message. If we have any questions about the uploaded file, we will contact you.
The new data will appear in Yango Maps within a few days, provided the file is properly formatted.
Write to support
{% included (../_includes/popup/id-popup/name.md) %}
The name of this specific branch. Written in standard capitalization, with no quotation marks, all-caps formatting, or special characters.
Must match the chain name exactly as it appears on the website, with no branch-specific additions. Branch-specific additions belong in the `name-other` element only.
Correct: _Chamomile_
Incorrect: _Chamomile on Lenin Street_
{% endincluded %}
{% included (../_includes/popup/id-popup/country.md) %}
Country. Specified in full, without abbreviations.
{% endincluded %}
{% included (../_includes/popup/id-popup/address-add.md) %}
Additional address information that doesn't apply to other elements (shopping center/shopping and entertainment complex/shopping and entertainment center, floor, office, premises, boutique, entrance).
For example, `Roze shopping center, floor 2, office 203`.
Landmark descriptions and turn-by-turn directions are not permitted (for example, "100 meters north of the subway station," "blue building to the right of Trafalgar Square").
Don't use brackets or quotation marks.
{% endincluded %}
{% included (../_includes/popup/id-popup/url.md) %}
The chain's main website URL (without social media pages). Specified in lowercase, in full, including `http://` or `https://`.
To add social media links, use the `add-url` attribute. Individual branches may specify their own regional website.
URLs must not contain UTM parameters.
{% endincluded %}
{% included (../_includes/popup/id-popup/working-time.md) %}
Opening hours. Days off and non-working days aren't specified.
General business hours (without separate hours for individual departments).
{% cut "Example" %}
```xml
daily 11:30-21:30 break 14:00-14:30, break 16:30-17:00
```
{% endcut %}
If the business observes holidays, a separate `scheduled-working-time` element with exact dates is required.
{% endincluded %}