There may be occasions when exporting content and downloading it as a CSV file is useful, such as:
- To run spellcheck in another tool
- To view content in an internal tool. (This is often the case with some agencies.)
- To easily sort and view content in a spreadsheet format
- To export content matching a specific filter, e.g. Excluded strings
You cannot re-import the exported CSV back into Smartling. If you want to export content and re-import, see Exporting/Importing Content for Offline Translation
Export Content to CSV
- In a project, click the Strings View.
- Using the filters on the left, find the strings you want to export
- Do not select Show source language only, as this filter will now allow you to export strings. This does not mean that all strings will have a translation in the exported file. The exported file will contain selected strings as seen in the Strings View
- Select the checkboxes for the strings you want to export
- Alternatively, select all and choose all matching current filter
- Go to Actions > Export
- Click Download and Close
- A CSV will download to your local drive. Here is an example exported file
It's best to open your CSV file via Google Sheets or Open Office. If you're using Excel, please follow steps outlined in our CSV documentation.
Your spreadsheet will show the following columns:
- String ID number
- Source text
- Variant
- File/URL
- String Order (the order of a string inside a file or URL, which can be used to sort strings in the file similar to Strings View UI view)
- Locale
- Translation Text
Export Content to CSV (Classic)
- Go to Projects (select a project) > Content > Translations.
- Select the status of the content (ex: In Progress, Completed, etc.) that you wish to export, and set your filters.
- Select Actions > Export All.
- From the Export All dialog box, click Download.
It's best to open your CSV file via Google Sheets or Open Office. If you're using Excel, please follow steps outlined in our CSV documentation.
Your spreadsheet will show the following columns:
- String ID number
- Source text
- Locale
- Translation text
- Plural type: The type of plural that the translation is, such as: one, many, other.