Managing the Translation Process

Export Strings to CSV

There may be occasions, such as the following use cases, when exporting content and downloading it as a CSV file is useful: 

  • To be able 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

  1. In a project, click the Strings View.
  2. 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.
  3. Select the checkboxes for the strings you want to export.
    • Alternatively, select all and choose all matching current filter. 
  4. Go to Actions > Export.
  5. Click Download and Close.  
  6. 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)

  1. Go to Projects (select a project) > Content > Translations.
  2. Select the status of the content (ex: In Progress, Completed, etc.) that you wish to export, and set your filters.
  3. Select Actions > Export All.
  4. 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.

Was this article helpful?