Skip to content
AREM Labs

EN TR

Trendyol → Excel / CSV

Turns your Trendyol product export into a Excel / CSV bulk-upload file, column for column.

1Drop your file here

Excel (.xlsx, .xls) or CSV

Tips

  • Download your product list as Excel from Trendyol Seller Center › Products › Product List
  • Leave no barcode or stock-code cell empty; rows that miss one land in the warning list.
  • Category names are not mapped automatically — check the category column in the file you download.

How to use it

  1. 1 Open Products › Product List in Trendyol Seller Center. Trendyol is the largest marketplace in Turkey.
  2. 2 Use "Download as Excel" at the top right; the file arrives as .xlsx.
  3. 3 Drop the file on this page; the source format is detected and a mapping preview appears.
  4. 4 Check the warning list: missing barcodes, empty prices and duplicated variants are collected there.
  5. 5 Download the XLSX file for Excel / CSV.
  6. 6 Open the downloaded .xlsx in Excel, Google Sheets or LibreOffice.
  7. 7 The columns are clean and plainly named, so you can paste them into accounting software, an ERP or another panel.

What you should know

Reshaping a Trendyol, the largest marketplace in Turkey product list into the Excel / CSV format by hand costs hours: column names differ, prices switch between tax-inclusive and tax-exclusive, variants are grouped by a different rule, and a barcode’s leading zero disappears the moment a spreadsheet opens the file. This converter reads the file you exported from Trendyol, maps every field onto the Excel / CSV template, and reports the rows you should check before uploading.

The file never leaves your computer: reading, mapping and writing the new file all happen in the browser tab, with no account and no upload. The result downloads as Excel (.xlsx) and can be handed straight to the Excel / CSV import screen.

What to know about a Trendyol export: Price columns include VAT ("Trendyol sale price" and "market sale price"). Variants are separate rows under the same model code; the colour and size columns are read as options. Images arrive as URLs in the "Image 1-8" columns.

Worked example: a Trendyol file turned into a Excel / CSV file

Our Trendyol sample file (trendyol.xlsx) holds 4 rows and 19 columns. The tool recognized 19 of those columns on its own. No column was left out. The rows were grouped into 2 products with 4 variants, and 4 image URLs were carried over. The Excel / CSV file that downloads has 4 rows and 15 columns; 15 of those columns arrive filled and the rest stay empty because the sample has no data for them.

First row of the output (under Excel / CSV column names)

Excel / CSV columnValue written
Ürün Adı Çiçekli Yazlık Elbise
Barkod 8680001000011
Stok Kodu ELB-001-KIR-S
Fiyat 899.9
Liste Fiyatı 1299.9
Stok 12
KDV 10
Marka Nuve
Kategori Elbise
Açıklama <p>Pamuklu, rahat kesim.</p>
Görsel 1 https://cdn.example.com/img/elb1-kirmizi-1.jpg
Görsel 2 https://cdn.example.com/img/elb1-kirmizi-2.jpg
Görsel 3 https://cdn.example.com/img/elb1-lacivert-1.jpg
Seçenek 1 Kırmızı

Notes the tool gave for this file

  • A clean product table with canonical columns; it is not a specific marketplace template.
  • Each row is one variant; variants of the same product are written consecutively.
  • "Fiyat" is the sale price and "Liste Fiyatı" the pre-discount price; it stays empty when there is no discount.
  • Option columns were written in the source order (e.g. Option 1 = Color).

Field mapping: Trendyol → Excel / CSV

Which target column each source column is written to. You can fix unmatched fields in the preview before downloading.

Field Source column Target column
Product name Ürün Adı Product Name
Model / group code Model Kodu — No counterpart in the target; skipped
SKU Stok Kodu Stock Code
Barcode Barkod Barcode
Sale price Trendyol'da Satılacak Fiyat (KDV Dahil) Price
List / compare-at price Piyasa Satış Fiyatı (KDV Dahil) List Price
Stock Ürün Stok Adedi Stock
Tax rate KDV Oranı VAT
Volumetric weight (desi) Desi — No counterpart in the target; skipped
Image columns Görsel Linki / Görsel 1-8 Image 1..n
Option 1 Renk Option 1
Option 2 Beden Option 2
Description Ürün Açıklaması Description
Brand Marka Brand
Category Kategori Category

Frequently asked questions

Which fields does Excel / CSV require?

Product name, Barcode, Stock code, Price, Stock. When one of them is empty the row lands in the warning list; fill it in the source file before uploading.

Are category and brand mapped automatically?

The brand is carried over untouched. Category names never match one to one across platforms, so you still have to fit them into the Excel / CSV category tree yourself; the tool writes the source category into the "Category" column.

Are prices carried over with or without tax?

The price in the Trendyol file is carried over exactly as it is; the spreadsheet keeps the tax rate in its own column.

Are images transferred too?

Image URLs are carried over and Excel / CSV downloads the files from those addresses during import, so every URL has to stay publicly reachable. Marketplace CDN addresses usually stay open; if access is blocked, host the images yourself and update the URLs first.

How many products can I convert at once?

There is no cap. The conversion runs on a background thread, so the page stays responsive even with files of 10,000 to 20,000 rows; the time it takes depends on your machine.

Share

Guides

Articles and format references related to this tool.

Guides →

Related tools

An independent tool. Not affiliated with Trendyol or Excel / CSV, and not an official product of either.