Skip to main content

​
Supported formats

Qwoty supports CSV files for data import:
Excel .xlsx and .xls files are not currently accepted. Convert your spreadsheet to CSV before importing.

​
File requirements

​
CSV best practices

  • Delimiter: Use comma , — Qwoty’s standard separator
  • Text qualifier: Use double quotes " for cells containing commas, line breaks, or quotes — for example, "france,partner_pricing" for a multi-catalog cell
  • Line endings: Windows (CRLF) or Unix (LF) both supported
  • Empty values: Leave cells empty, don’t use NULL or N/A

​
Excel best practices

When exporting from Excel:
  • Remove formulas (export values only)
  • Delete empty rows at the end
  • Ensure no merged cells
  • Use the first sheet only
  • Save explicitly as CSV UTF-8 (Comma delimited) to preserve special characters

​
Large datasets

The CSV importer is designed for migrations and bulk updates of moderate size. For very large datasets or recurring syncs:
  • Split your data into multiple smaller files (a few thousand rows each)
  • Or use the Qwoty REST API for unlimited records and continuous sync from your CRM, ERP, or accounting tool
For very large migrations (100,000+ records), the API is significantly faster and more reliable than CSV imports.

Field mapping

How Qwoty matches your CSV columns to its fields.

Prepare your CSV

Step-by-step formatting guide.