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 a comma ,
  • 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
  • Empty rows: Ignored

​
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 accepts up to 10,000 rows per file. For larger datasets or recurring syncs:
  • Split your data into several files
  • Or use the Qwoty API for continuous sync from your CRM, ERP, or accounting tool
Large files take time to process: keep the window open until the Result step appears.

Field mapping

How Qwoty matches your CSV columns to its fields.

Prepare your CSV

Step-by-step formatting guide.
Last modified on October 27, 2026