# Shopify Translate & Adapt CSV

> Translate Shopify "Translate & Adapt" CSV exports in Crowdin

URL: https://store.crowdin.com/shopify-translate-adapt
Category: File Formats
Type: App
Author: Awesome Crowdin

Translate the CSV that Shopify gives you from **Settings → Languages → Export**, directly in Crowdin.



## What it does



Shopify's "Translate & Adapt" export is a single CSV where every row is one resource field in one locale (`Type,Identification,Field,Locale,Market,Status,Default content,Translated content`). This app reads that file as a Crowdin source: `Default content` becomes the source string, existing `Translated content` is imported as translations, and on download the file is rebuilt for your target language with everything else — ids, markets, extra columns — preserved.



## When to use it



This app works from the **exported CSV** — export from Shopify, translate in Crowdin, import the file back. Use it instead of a live store connection when:



- **You can't or don't want to connect the store directly.** Crowdin already has a native [Shopify Store Localization](https://store.crowdin.com/shopify-store-localization) integration that syncs with a live store — use this file-based app when connecting the store isn't an option and you'd rather move one file each way.

- **You need JSON metafields translated.** The app splits JSON metafield values into per-sentence segments. A live store connection that only maps Shopify's own translatable fields leaves generic JSON metafields untranslated.

- **You want every exported column round-tripped** — market-scoped rows, handles, and any extra columns — exactly as Shopify wrote them.



## User flow



1. In Shopify admin: **Settings → Languages → Export** the languages you want.

2. Upload the CSV to Crowdin. The app extracts every translatable field as strings.

3. Translate in Crowdin (existing translations from the export are already there).

4. Download the file for a target language and **import it back into Shopify** (Settings → Languages → Import).



## JSON metafields



Many Shopify metafields hold a JSON blob (rich text, app/theme data). This app walks the JSON and turns each translatable text leaf into its own segment, so translators see real sentences instead of raw JSON. Structural values (numbers, URLs, colors, ids) are skipped. On download each leaf is patched back at its exact position, so the JSON structure stays intact. Shopify's own Translate & Adapt does not translate JSON metafields — this app does.



## Handles messy Shopify exports



Not every Shopify export looks the same — depending on your store and locale settings, the CSV can use different separators or contain tricky text (like a measurement written as `15"`). The app handles all of these, so your file uploads cleanly instead of breaking or producing garbled strings, and the file you download back always imports into Shopify without a hitch.



## Settings



After you install the app, it adds its own settings under **Project → Settings → Parser configuration → Shopify Translate & Adapt CSV**. It's best to set these **before you upload your files**, since they change how each file is parsed.



**Segmentation vs. preview** — the main choice, and the two are mutually exclusive:



- **Segmentation on** (the default) — long descriptions are split into individual sentences. This gives better translation-memory re-use and is easier for linguists to work through. Best when the content in your export is long.

- **Segmentation off** — turns on a **WYSIWYG preview**: linguists see the rendered text (formatting and all) instead of raw markup, which gives them context and improves quality. Best when the content is short. To use it, turn segmentation off and enable *"Generate an HTML preview for translators"*.



**Which JSON keys to translate** — for JSON metafields you can control exactly what gets picked up: keep the default deny-list (structural keys like ids, URLs and colors are skipped), or switch to an allow-list to translate only specific keys (e.g. `value`, `title`).



## File Format Details

| Attribute | Value |
| --------- | ----- |
| File Extension | .csv |
| [API Type](https://developer.crowdin.com/api/v2/#operation/api.projects.files.post) | shopify-translate-adapt-csv |
| Source can be edited in Crowdin | No |
| Generating translated files via [Bundles](https://support.crowdin.com/bundles/) | [Search Crowdin Store](https://store.crowdin.com/tags/string-exporter) |
| Supports pluralization | No |
| WYSIWYG Preview in the editor | Yes |
| Supported types of contextual information | WYSIWYG/Text comments, Screenshots |
| Custom attributes | No |
| Existing translations import possibility | None |

## Sample File

```csv
Type,Identification,Field,Locale,Market,Status,Default content,Translated content
PRODUCT,'8001,title,fr,,,"Trail Backpack 30L","Sac à dos de randonnée 30 L"
METAFIELD,'39357902028843,value,fr,,,"{""type"":""root"",""children"":[{""type"":""heading"",""level"":2,""children"":[{""type"":""text"",""value"":""Care Instructions"",""bold"":true}]},{""type"":""paragraph"",""children"":[{""type"":""text"",""value"":""Machine wash cold.""}]}]}","{""type"":""root"",""children"":[{""type"":""heading"",""level"":2,""children"":[{""type"":""text"",""value"":""Instructions d'entretien"",""bold"":true}]},{""type"":""paragraph"",""children"":[{""type"":""text"",""value"":""Lavage en machine à froid.""}]}]}"
```