![logo2.png]](https://help.brandwizard.io/hs-fs/hubfs/logo2.png?height=40&name=logo2.png){kind=logo}
How to export companies via file?
To export companies via a file, you need to fill in the data in the file to upload it to your account. You can download the file template from the Validation and import of companies page (more details here) in your personal account or request it from your manager.
After filling out the file, send it to your technical specialist or import it yourself in your personal account on the Validation and import of companies page.
Attention!
- Mandatory fields are marked (*) below.
- The remaining fields are optional, but they will affect the card’s occupancy.
- You cannot change the names and positions of columns. If you do this, we will not be able to import the data.
Description of columns
Moreover, you can put some fields in your native language (Brand name, company name, legal name, street, explanation of the address, short/long description).
| *Brand name | For example, BrandWizard. |
| Optional brand names (up to 5 names) | For example, Brand Wizard. What are alternative names and how to find them can be read here. |
| *Company name | How your company will be named on the maps. The company name may match the brand name. Requirements for company names can be read here. |
| Additional name (en) | The name of your company in English. |
| *Allowed company names | Alternative company names. You can find more details here. |
| *Active | If the branch is active, write "yes". Otherwise "no". |
| *Closed | If the branch is closed, write "yes". Otherwise "no". |
| *Temporarily closed | If the branch is temporarily closed, write "yes". Otherwise "no". |
| Tariff plan | Your tariff plan. You can find it from the manager. |
| *Branch code | The branch's unique number (numeric). You need to assign any digit that will be unique for each address. For example, 1, 220. |
| Legal name | The legal name of your company without a form of ownership. Where is the legal information that is entered when creating a company displayed can be read here. |
| Form of ownership | For example, LLC, Inc, PLC, etc. |
| Full address | The full address of your company. Includes country, city, region, locality, house number/building. |
| *Country | The country of location of the branch in full. For instance, Poland. |
| *Region | The region where the branch is located. |
| *Settlement | For example, Warsaw. |
| *Street | The full name of the street. Do not write the words st./street. Other designations, for instance, avenue, lane, can be specified. |
| *House and building | Number of the building. For example, 1. |
| Explanation of the address | For example, 8th floor, office 1. |
| Postal code | For example, 222000. |
| *Latitude | It must be indicated with a dot and without spaces (Correct - 53.155. Incorrect - 53,155). |
| *Longitude | It must be indicated with a dot and without spaces (Correct - 53.155. Incorrect - 53,155). |
| Address language | The address language is specified in two-letter format, currently supported: English: en, Russian: ru, Spanish: es, Lithuanian: lt, Polish: pl, Ukrainian: uk. By default, Russian: ru is used. It is used when searching for fakes and duplicates. |
| For example, hello@example.com. | |
| *Main telephone | The first phone number in international format. For example, +971 600 000000. |
| Additional phone numbers | Additional numbers. For example, +971 600 111111, +971 600 222222. |
| *Website | Link to the website. For example, https://example.com/. |
| Social networks |
Links to groups, separated by commas (sources that can be added: Youtube, Twitter, Facebook, Instagram, Telegram, LinkedIn, TikTok, WhatsApp). Examples of links:
|
| Logo |
You need to attach a link to the image. As a cloud for storing photos, you can use the free service https://cloudinary.com/. Which image cannot be placed as a logo can be read here.
Requirements for the logo for the Google catalog:
Attention! Only links of the https://static.tildacdn.com/tild6666-3830-4438-a232-333931323031/_1.png |
| Cover |
You need to attach a link to the image. There may be photos of stores, any corporate images, etc. As a cloud for storing photos, you can use the free service https://cloudinary.com/.
Attention! Only links of the https://static.tildacdn.com/tild6666-3830-4438-a232-333931323031/_1.png form are accepted. The image format must be specified at the end of the link: jpg, jpeg, png. |
| Gallery |
You need to attach a link to the image. Requirements for the gallery photos:
Requirements for photos for the gallery in the Google catalog:
Parameters of photos for the photo gallery in the catalog 2GIS(URBI):
|
| *Categories | The number of categories, separated by commas. You can specify up to 5 categories in the list of categories, but it is very important to specify them in the correct order. The first three categories should reflect the essence of your company’s activities as much as possible and further reduce their significance. The list of categories can be viewed here. For example, 8533, 10432 |
| *Working hours |
Separately for each day of the week. The format should be as follows: 10:30-17:30. If the location has a break, then the format should be like: 09:00-13:00, 14:00-18:00. If there is a day off, then leave the field empty. Attention! It is important that the working hours do not overlap with the schedule of the following day. For example, the location operates on the following schedule: Mon-Thu: 08:00-01:00, Fri-Sat: 24 hours. The correct format is: Mon-Wed: 00:00-01:00, 08:00-23:59 (or until 00:00), Thu: 08:00-23:59 (or until 00:00), Fri-Sat: 00:00-23:59 (or until 00:00). |
| Payment: Credit cards | If applicable, fill in "yes". Payment by credit cards implies that you can pay with a bank plastic card through the terminal. |
| Payment: bank account | If applicable, fill in "yes". Indicates that an individual can make a payment at the bank’s cash desk. |
| Payment: cash | If applicable, fill in "yes". |
| Payment: Banking transfer system | If applicable, fill in "yes". Payment by invoice as for legal entities from a current account to a current account. |
| Payment: via internet | If applicable, fill in "yes", if you can make a payment on the site. |
| Short description | Up to 200 characters, you cannot add links. |
| Long description | Up to 500 characters, you cannot add links. How to make a proper description of your business can be read here. |
| It is possible to specify different data for catalogs. If you want to send information about your company to 2GIS, Yandex and Google that is different than in other catalogs, you must fill in the following fields: | |
| 2gis: company name | For example, 2gis BrandWizard. |
| 2gis: brand name | For example, 2gis BrandWizard. |
| 2gis: website | For example, https://2gisversion.brandwizard.com. |
| 2gis: Social networks | Please provide the links to the groups, separated by commas. Sources links to which can be sent: Youtube, Twitter, Facebook, Instagram, Telegram, Google+, LinkedIn. If you don’t need to send a link to a specific social network to the catalog, it can be redirected to “blank”. E.g.: Instagram: , Facebook: , Youtube: https://www.youtube.com/watch?v=BUc5KgnD0Xs&ab_channel=BrandWizard. |
| 2gis: Main number | For example, +971 600 000000. |
| 2gis: Additional phone numbers | For example, +971 600 111111, +971 600 222222. |
| 2gis: Explanation of the address | For example, 8th floor, office 1. |
| 2gis: Categories | You can see the available categories for this catalog here. |
| 2gis: Working hours |
Separately for each day of the week. The format should be as follows: 10:30-17:30. If the location has a break, then the format should be like: 09:00-13:00, 14:00-18:00. If there is a day off, then leave the field empty. Attention! It is important that the working hours do not overlap with the schedule of the following day. For example, the location operates on the following schedule: Mon-Thu: 08:00-01:00, Fri-Sat: 24 hours. The correct format is: Mon-Wed: 00:00-01:00, 08:00-23:59 (or until 00:00), Thu: 08:00-23:59 (or until 00:00), Fri-Sat: 00:00-23:59 (or until 00:00). |
| 2gis: E-mail | For example, 2gis@2gis.com. |
| Google: company name. | For example, Google BrandWizard. |
| Google: brand name. | For example, Google BrandWizard. |
| Google: website. | For example, https://googleversion.brandwizard.com. |
| Google: Social networks | Please provide the links to the groups, separated by commas. Sources links to which can be sent: Youtube, Twitter, Facebook, Instagram, Telegram, Google+, LinkedIn. If you don’t need to send a link to a specific social network to the catalog, it can be redirected to “blank”. E.g.: Instagram: , Facebook: , Youtube: https://www.youtube.com/watch?v=BUc5KgnD0Xs&ab_channel=BrandWizard. |
| Google: Main number. | For example, +971 600 000000. |
| Google: Additional phone numbers | For example, +971 600 111111, +971 600 222222. |
| Google: Explanation of the address | For example, 8th floor, office 1. |
| Google: Gallery |
You need to attach a link to the image. Requirements for photos for the gallery in the Google catalog:
|
| Google: Categories. | You can see the available categories for this catalog here. |
| Google: Working hours |
Separately for each day of the week. The format should be as follows: 10:30-17:30. If the location has a break, then the format should be like: 09:00-13:00, 14:00-18:00. If there is a day off, then leave the field empty. Attention! It is important that the working hours do not overlap with the schedule of the following day. For example, the location operates on the following schedule: Mon-Thu: 08:00-01:00, Fri-Sat: 24 hours. The correct format is: Mon-Wed: 00:00-01:00, 08:00-23:59 (or until 00:00), Thu: 08:00-23:59 (or until 00:00), Fri-Sat: 00:00-23:59 (or until 00:00). |
| Google: E-mail | For example, google@google.com. |
| Google: Long description | It must not exceed 750 characters.How to make a proper description of your business can be read here. |
| Yandex: Company name | For example, Yandex BrandWizard. |
| Yandex: Brand name | For example, BrandWizard. |
| Yandex: Website | For example, https://yandexversion.brandwizard.com. |
| Yandex: Social networks | Provide the links to the groups, separated by commas. Sources for which links can be sent: YouTube, Twitter, VK, Facebook, Instagram, Telegram, OK.ru, Google+, LinkedIn. If you do not need to send a link to a particular social network that was previously specified in the main social networks field, you can override it with "empty." Example: Instagram: , VK: , YouTube: https://www.youtube.com/watch?v=BUc5KgnD0Xs&ab_channel=BrandWizard. |
| Yandex: Main telephone | For example, +971 600 000000. |
| Yandex: Additional phone numbers | For example, +971 600 111111, +971 600 222222. |
| Yandex: Explanation of the address | For example, 8th floor, office 1. |
| Yandex: Gallery |
You need to attach a link to the image.
|
| Yandex: Categories | You can see the available categories for this catalog here. |
| Yandex: Working hours |
Separately for each day of the week. The format should be as follows: 10:30-17:30. If the location has a break, then the format should be like: 09:00-13:00, 14:00-18:00. If there is a day off, then leave the field empty. Attention! It is important that the working hours do not overlap with the schedule of the following day. For example, the location operates on the following schedule: Mon-Thu: 08:00-01:00, Fri-Sat: 24 hours. The correct format is: Mon-Wed: 00:00-01:00, 08:00-23:59 (or until 00:00), Thu: 08:00-23:59 (or until 00:00), Fri-Sat: 00:00-23:59 (or until 00:00). |
| Yandex: E-mail | For example, yandex@yandex.com. |
|
The language code is indicated in parentheses. |
You can add additional company names in various languages for each of the main directories. To specify names in other languages, supplement the file with the necessary fields and include the corresponding language code in parentheses. These additional fields can be placed at the end of the file. |
| Special schedule | You can send a temporary (special) working schedule to Google, Yandex and 2GIS (URBI). Instructions for registering a special schedule on Google, Yandex and 2GIS (URBI) can be found here. For each date with a modified schedule, you need to add a column of a Special Schedule type 2019-12-31 (the date of the special schedule is indicated). |