> ## Documentation Index
> Fetch the complete documentation index at: https://docs.qwoty.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Supported file formats

> File formats supported for data import in Qwoty.

## Supported formats

Qwoty supports CSV files for data import:

| Format  | Extension | Notes                                                                    |
| ------- | --------- | ------------------------------------------------------------------------ |
| **CSV** | `.csv`    | The only format supported today. Most compatible with spreadsheet tools. |

<Note>
  Excel `.xlsx` and `.xls` files are not currently accepted. Convert your
  spreadsheet to CSV before importing.
</Note>

## File requirements

| Requirement           | Value                                                           |
| --------------------- | --------------------------------------------------------------- |
| **Encoding**          | UTF-8 (recommended)                                             |
| **Field separator**   | Comma `,`                                                       |
| **Decimal separator** | Period `.`                                                      |
| **Structure**         | First row must contain column headers                           |
| **Content**           | One object type per file (Master products, Products, or Prices) |

## 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](https://docs.qwoty.io) 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.

## Related

<CardGroup cols={2}>
  <Card title="Field mapping" icon="arrow-right-arrow-left" href="/user-guide/data-migration/reference/field-mapping">
    How Qwoty matches your CSV columns to its fields.
  </Card>

  <Card title="Prepare your CSV" icon="file-spreadsheet" href="/user-guide/data-migration/how-tos/prepare-csv-files">
    Step-by-step formatting guide.
  </Card>
</CardGroup>