Import Article Translations in Salesforce Knowledge

Step 1 — Set Up Your Multilingual Knowledge Base
Before importing translations, configure your org to support multiple languages. Follow the steps in Support a Multilingual Knowledge Base.
Step 2 — Create a Translation Queue
A Translation Queue is a Salesforce queue used to hold articles pending translation. To create one:

1. Go to Setup.
2. Enter "Queues" in the Quick Find box, then select Queues.
3. Click New.
4. Enter a label and queue name (for example, "French Translations").
5. Choose a user to notify when new records are added to the queue.
6. Add Knowledge Article Version as the object included in the queue.
7. Add queue members (the translators or team responsible).
8. Click Save.

Step 3 — Submit Articles for Translation

1. Go to the Knowledge tab.
2. Click the drop-down next to the article you want to translate.
3. Click Submit for Translation.
4. Note: In Lightning Experience (LEX), articles must be submitted one at a time. To submit multiple articles at once, switch to Salesforce Classic and use the Article Management tab. Once done, return to LEX.
5. Select the target language and due date.
6. Click OK.

Step 4 — Export Articles for Translation

1. Go to Setup.
2. Search for "Export Articles" in the Quick Find box, then select Export Articles for Translation.
3. Select the Translation Queue created in Step 2.
4. Select the articles to include.
5. Click Continue.
6. Assign translations to a user.
7. Select Unicode UTF-8 as the file encoding (recommended to preserve special characters).
8. Set Delimiter to Comma.
9. Click Export Now.
10. Navigate to Article Imports and Exports and download the exported file from the Article Exports section.
11. Extract the downloaded ZIP file to a separate folder.

Step 5 — Prepare the Translation Import File

1. Open the Knowledge__kav CSV file from the export.
2. Edit the translated field values directly in the CSV. For Rich-Text Area fields (HTML, images, etc.), edit the files directly. You do not need to translate URL fields.
3. Save the CSV with a new name (for example, "articletranslations.csv").
4. Create a new folder and place both the CSV and the export.properties file inside it.
5. Rename export.properties to import.properties.
6. Create a subfolder named with the target language code (for example, fr for French).
7. Inside the fr folder, create another subfolder named Knowledge__kav (note: two underscores).
8. Place the CSV and any supporting files (HTML, images) inside the Knowledge__kav subfolder.
9. Select the fr folder and import.properties file, right-click, and compress them into a ZIP file (for example, "ImportTranslatedArticles.zip").

The expected ZIP structure is:

ImportTranslatedArticles.zip
  - import.properties
  - fr/
    - Knowledge__kav/
      - articletranslations.csv
      - [images, html, etc.]

Step 6 — Import Article Translations

1. Go to Setup.
2. Search "Import Articles" in the Quick Find box, then select Import Article Translations.
3. Select the language, assign translations to a user or queue, and choose the ZIP file.
4. Click Import Now.
5. Select how to handle imported translations.
6. Click Finish.