XLS format

XLS format simplifies data transfer for stores that keep inventory information in Excel spreadsheets.

  1. Requirements for price lists that are submitted in XLS format
  2. File validation
  3. Examples of price lists
  4. Differences between XLS and YML formats

Requirements for price lists that are submitted in XLS format

  1. The first line in the spreadsheet must contain the names of elements used to describe the products.

  2. Each line in the file should contain a description of a single product.

  3. Tabs and line breaks are not allowed inside cells.

  4. The file should not contain empty columns.

  5. The file must consist of a single page.

File validation

The following conditions are checked when the file is read:

  • All element names are valid.

  • All mandatory elements are present.

  • Each element occurs only once.

If any of these conditions is not met, the file is rejected.

Differences between XLS and YML formats

  • XLS format does not allow you to send product characteristics used to filter Yandex.Market search results.

  • XLS also doesn't allow you to indicate your currency conversion conditions. Prices displayed in your local currency will be converted to rubles and back using the current exchange rate of the Central Bank of the Russian Federation.

  • In YML format, categories are uploaded as a tree, whereas in XLS format they are in a flat list.