Skip to content
MSO CloudDocumentation

Upload CSV or Excel files

On this page

Load data from a file when no connector covers the source; how the file is read becomes a reusable mapping template.

Who can do this: an owner or admin, or a role with the connector capability.

Before you start#

  • The organization has a brand; in a multi-brand organization pick the receiving brand first.
  • A self-prepared file in one of the built-in column templates (orders, creators, inventory, creator costs, targets, products) needs no mapping template.
1 - Drop fileCSV or Excelexportfrom seller console2 - Preview & templatematch columns totarget fieldsfirst time only3 - Normalizecurrency, dates,encodingper template rules4 - Validatesample rows,rejected-row listbefore full upload5 - Warehouserows land inthe datasetready for dashboards
Upload flow: a file becomes warehouse rows through one reusable mapping template.
Tải lên dữ liệu · Upload CSV / Excel/connectors/uploadsSTEP 1 · What data are you uploading?Marketplace export (TikTok Shop / Shopee / Lazada file)Self-prepared fileSearch templates by name, source or streamShopee orders export v3Manage mapping templates →32STEP 2 · Shopee orders export v3 → stream: ordersData lands in brand:AcmeDrag & drop a file here · orders_2026-09.csvOr click to browse — .csv, .xlsx, .xls · max 8 MiB1Preview · first 5 rowsOrder IDOrder dateStatusAmountBuyer2609A12026-09-01Completed1,250,000N***2609A22026-09-01Cancelled0T***4Upload & queue5The template is applied to the file right after upload.Recent uploads · latest 50FileTypeStatusRowsorders_2026-09.csvOrdersSuccess1,240 readorders_2026-08.xlsxOrdersPartial success980 read · 3 droppedFirst failure reason shown under the row, e.g. missing_columns → re-upload through the template.6New mapping templatetemplates page1Source and target2Map columns3PreviewTemplate nameShopee orders export v3Sample file (.csv / .xlsx / .xls)orders_sample.csvMap each source column to a canonical field;the preview reports % valid rows before Save.Save templateBuilt-in column templatesOrders, Creators / KOC, Inventory,Creator costs, Targets / KPI,Products (SKU)A self-prepared file in thesecolumns needs no mapping template;download the column template first.
Tải lên dữ liệu ('Upload data'). Callout 2 points at the mapping-template wizard, used once per file format; the rest is the upload page itself.

Steps#

  1. Open the file in a plain text editor, not Excel, which re-encodes silently, and check the header, currency symbols, dates and encoding.
  2. Once per file format, create a mapping template at CSV / Excel mapping ("Ánh xạ cột CSV / Excel"): source and target, map columns, preview, save (field reference).
  3. At Upload data ("Tải lên dữ liệu") choose Marketplace export or Self-prepared file and the template.
  4. Drop the file (.csv, .xlsx, .xls, up to 8 MiB) and check the preview and the receiving brand.
  5. Select Upload & queue.
  6. In Recent uploads read the status, rows read and dropped and the first failure. Success with none dropped is the goal.
  7. Reconcile at Data validation ("Đối soát dữ liệu") against the original file for the same period.

If it fails#

Symptom Cause Fix
Row dropped, not a number A currency symbol is still in the column Turn on currency-symbol stripping in the template.
Row dropped, not a date A day-first date read as US-style Set the date format explicitly in the template.
Vietnamese text is garbled The file is in an older Windows encoding Set that encoding in the template.
File rejected as too large One long historical export above 8 MiB Split it and upload each part.
Re-upload doubles the numbers The template has no dedupe key Add a dedupe key, then re-upload.
Status says missing columns A raw marketplace file uploaded as self-prepared Re-upload through the Marketplace export mode and its template.
Money column is zero on every row The file no longer carries the mapped money column Check the column name, then update the template.