---
schema_version: "1"
id: b0308645d7c5babb7b728d218005c39c78835002130f0844146749f31e726de5
title: Create a .csv File for Article Import
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/service/264-0-0/knowledge_article_importer_02csv.md
canonical_url: https://help.salesforce.com/s/articleView?id=service.knowledge_article_importer_02csv.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 4e76bec18b6e68afb524f0ba4391dd67c68830400cd83abd2e5bc569daa97419
description: The import file maps the article contents to Knowledge article fields. For example, map a Title column in your .csv file with the standard Title field to import each article's title.
products:
  - Service Cloud
release: "264"
---
# Create a .csv File for Article Import

The import file maps the article contents to Knowledge article fields. For example, map a Title column in your .csv file with the standard Title field to import each article's title.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in Salesforce Classic and Lightning Experience. <a href="https://help.salesforce.com/s/articleView?id=service.service_editions_reference.htm&amp;language=en_US" target="_blank">View supported editions</a>.</td></tr></tbody></table>

![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-service-support-264-0-0-production-enus/dd14551c-a772-4db6-9a1d-d84df8df2980/images/icon_important.png)

Important Where possible, we changed noninclusive terms to align with our company value of Equality. We maintained certain terms to avoid any effect on customer implementations.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d173749e61">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e61 ">To import articles:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e61 ">
              <p>Manage Salesforce Knowledge </p>
              <p>AND</p>
              <p>Manage Articles</p>
              <p>AND</p>
              <p>Manage
                Knowledge Article Import/Export</p>
              <p>AND</p>
              <p style="margin-bottom:0;">Read, Create, Edit, and Delete on
                the article type</p>
            </td>

          </tr>
        </tbody>
      </table>

1. Create a .csv file to import articles.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-service-support-264-0-0-production-enus/dd14551c-a772-4db6-9a1d-d84df8df2980/images/icon_note.png)
    
    Note In Salesforce Classic, you import each article type separately, so you create a .csv file for each article type. In Lightning Knowledge, you can import articles of different types in one .csv file and set the record type during import.
    
    - There can only be one .csv file and one .properties file.
    - The .csv file and the .properties file must be in the root directory.
    - The compression process must preserve the folder and subfolder structure.
    - The .zip file name can’t contain special characters.
    - The .zip file can't exceed 20 MB and the individual, uncompressed, files within the zip file can't exceed 10 MB.
    - .csv files can't have more than 10,000 rows, including the header row. Therefore, you can have a maximum of 9,999 articles and translations.
    - .csv file rows can't exceed 400,000 characters.
    - .csv file cells can't exceed 32 KB.
    - Each article in the .csv file can't have more than 49 translations.
2. In the first row, specify the article's fields and metadata, such as title, language, data categories, and channels.
    
    Enter one item in each column. You can use the following fields and metadata to import content.
    
     
    | Field or data | Description |
    | --- | --- |
    | isMasterLanguage | Identifies the article as a primary (1) or translation (0). Required to import articles with translations, however, isMasterLanguage can’t be in a .csv file to import articles without translations. A translation must follow its primary article so that it’s associated with the primary article preceding it. |
    | Title | The article or translation's title. Required for all imports. |
    | Record Type | Indicates an article’s record type, for example, FAQ. Article import requires the 15-character, case-sensitive ID format. |
    | Standard and custom fields | Refer to an article type's standard fields using field names and refer to custom fields using API names. If the related article type field is mandatory, leaving a row cell empty can cause your articles to be skipped. |
    | Rich text area field | Use the rich text area custom fields to import .html files or images. Refer to an article type's rich text area field using its API name. |
    | File field | Use the file custom fields to import any file type (.doc, .pdf, .txt). Refer to an article type's file field using its API name. |
    | Data category groups | To categorize the imported articles, use category groups. Refer to a category group using its unique name prefixed with `datacategorygroup.`. For example, use `datacategorygroup.Products` to specify the category group Products. |
    | Channel | To specify where the imported articles are available, use the keyword `Channels`. |
    | Language | Specify the articles' language. Required to import articles with translations. Optional to import articles without translations. If you don't include this column, the articles automatically belong to the default knowledge base language and you can't import translations along with the primary articles. |
3. In subsequent rows, specify the articles you want to import.
    
    Use one row per article, and enter the appropriate information in each field or metadata column. You can leave a column blank to skip importing data. For example, if some fields only appear in certain record types, enter values only for the appropriate articles of those types.
    
    ![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-service-support-264-0-0-production-enus/dd14551c-a772-4db6-9a1d-d84df8df2980/images/icon_important.png)
    
    Important All file names are case-sensitive and must exactly match what is in the .csv file.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
            <colgroup>
              <col style="width:50%">
              <col style="width:50%">
            </colgroup>
            <thead class="slds-text-title_caps ">
              <tr class="">
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d173749e212">Consideration</th>
                <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d173749e214">Notes</th>
              </tr>
            </thead>
            <tbody>
              <tr class="">
                <td data-label="Consideration" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e212 ">Standard or custom fields</td>
                <td data-label="Notes" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e214 ">
                  <p>Enter the articles' data for each field, except for rich text area fields
                    where you must enter the relative path to the corresponding .html file in your
                    .zip file.</p>
                  <p style="margin-bottom:0;">The article importer does not support subfields. If you have
                    fields within fields, adjust your structure and content before importing into
                    Salesforce Knowledge.</p>
                </td>
              </tr>
              <tr class="">
                <td data-label="Consideration" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e212 ">Rich text area field</td>
                <td data-label="Notes" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e214 ">
                  <p>Always enter the .html file path relative to the location of the .csv file.
                    Never enter raw text. <span id="knowledge_article_importer_02csv__limit_html_path"><a name="knowledge_article_importer_02csv__limit_html_path"><!-- --></a>If the specified path doesn't
                      exist, the related article isn't imported.</span> Note the following information
                    about importing HTML and images.</p>
                  <ul>
                    <li>We recommend that you create one folder for the .html files (for example,
                      <samp class="filepath">/data</samp>) and another for images (for example,
                      <samp class="filepath">/data/images</samp>).
                    </li>
                    <li>To import images, include the images in an .html file using the <code>&lt;img&gt;</code> tag and <code>src</code> attribute. Ensure that the <code>src</code> value is a relative path from the .html file to the image
                      folder.</li>
                    <li>Images must be <samp class="filepath">.png</samp>, <samp class="filepath">.gif</samp>, or
                      <samp class="filepath">.jpeg</samp> files.
                    </li>
                    <li>Each image file can't exceed 1 MB.</li>
                    <li>If you have multiple rich text area fields, create a separate .html file
                      for the contents of each field.</li>
                    <li>.html file contents can't exceed the maximum size for its
                      field.</li>
                    <li>If a date doesn't match the date format specified in the property file,
                      the related article isn't imported.</li>
                    <li>If an .html file references a file that isn't allowed, the related article
                      isn't imported.</li>
                    <li>If an .html file references an image that's missing, the related article
                      is imported without the image.</li>
                  </ul>
                </td>
              </tr>
              <tr class="">
                <td data-label="Consideration" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e212 ">File field</td>
                <td data-label="Notes" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e214 ">
                  <p>In Lightning Knowledge, custom file fields are replaced with
                    Salesforce Files.</p>
                  <p>Enter the path relative to the file's location. If the
                    specified path doesn't exist, the related article isn't imported. Note the
                    following information about importing files.</p>
                  <ul>
                    <li>We recommend that you create a folder for your files (for example,
                      <samp class="filepath">/files</samp>).
                    </li>
                    <li>Each file must not exceed 5 MB.</li>
                  </ul>
                </td>
              </tr>
              <tr class="">
                <td data-label="Consideration" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e212 ">Category groups</td>
                <td data-label="Notes" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e214 ">
                  <p>Use unique category names to categorize articles. Use the plus symbol
                    (<code>+</code>) to specify more than one category.
                    For example, <code>Laptop+Desktop</code>. Note the
                    following information about data category groups.</p>
                  <ul>
                    <li>Leaving the cell row empty causes your article to be set to No
                      Categories.</li>
                    <li>If you specify a category and its parent (for example, Europe+France) the
                      import process skips the child category France and keeps the parent category
                      Europe, because application of a parent category implicitly includes the
                      category's children.</li>
                    <li>When importing articles with translations and associated data categories,
                      only the primary article retains the data categories. The article
                      translations have no associated data category upon import.</li>
                  </ul>
                </td>
              </tr>
              <tr class="">
                <td data-label="Consideration" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e212 ">Channels</td>
                <td data-label="Notes" class="slds-cell-wrap" style="vertical-align:top;" headers="d173749e214 ">
                  <p>Specify articles' channels using the keywords.</p>
                  <ul>
                    <li><code>application</code> for Internal App. If you
                      don't specify a channel, <code>application</code>
                      is the default.</li>
                    <li><code>sites</code> for Public Knowledge
                      Base.</li>
                    <li><code>csp</code> for Customer.</li>
                    <li><code>prm</code> for Partner.</li>
                  </ul>
                  <p>Use the plus (<code>+</code>) symbol to specify
                    more than one channel (for example, <code>application+sites+csp</code> to make an article available in all
                    channels).</p>
                  <p style="margin-bottom:0;">When importing articles with translations and associated
                    channels, only the primary article retains the channels. The article
                    translations have no associated channels upon import.</p>
                </td>
              </tr>
            </tbody>
          </table>

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-service-support-264-0-0-production-enus/dd14551c-a772-4db6-9a1d-d84df8df2980/images/icon_example.png)

Example

The following example shows .csv files to import product offer articles. The first file imports articles without translations. The second .csv file imports articles with translations. The .csv files contain titles, summaries, and descriptions. They also classify the articles in the category group Products and make them available for specific channels. The `description__c` field is a rich text area and only supports paths to .html files. The `summary__c` field is a text field and only supports raw text. The summary field is optional, and `summary__c` is left blank for some rows. The `RecordTypeId` sets the Product Offer record type for two of the articles, and the “Best Desktop Computer Deals” article is an FAQ. Example `articlesimport.csv` file:

`Title,summary__c,description__c,datacategorygroup.Products,Channels,RecordTypeId Free Digital Camera Offer, Get the new Digital Camera.,data/freecam.html,Consumer_Electronics,application+csp,012RM0000002Q5M Best Desktop Computer Deals,,data/bestdeals.html,Desktop,application+csp,012RM0000002Q5g Free Shipping on Laptop and Desktops,,data/freeship.html,Laptop+Desktops,application+csp,012RM0000002Q5M`

Example `articlestranslationsimport.csv` file:

```
isMasterLanguage,Title,summary__c,description__c,datacategorygroup.Products,Channels,Language,RecordTypeId
1,Free Digital Camera Offer,Get the new Digital Camera,data/freecam.html,Consumer_Electronics,application+csp,en,012RM0000002Q5M
0,Libérer l'Offre d'Appareil photo digital,Obtenir le nouvel Appareil photo digital.,data/freecam/fr.html,,,fr,012RM0000002Q5M
0,Liberte Oferta Digital de Cámara,Consiga la nueva Cámara Digital.,data/freecam/es.html,,,es,012RM0000002Q5M
1,Best Desktop Computer Deals,,data/bestdeals.html,Desktops,application+csp,en,012RM0000002Q5g
0,Meilleures Affaires d'ordinateurs de bureau,,data/bestdeals/fr.html,,,fr,012RM0000002Q5g
0,Mejores Tratos de ordenadores,,data/bestdeals/es.html,,,es,012RM0000002Q5g
1,Free Shipping on Laptop and Desktops,,data/freeship.html,Laptops+Desktops,application+csp,en,012RM0000002Q5M
0,Libérer Affranchissement sur Portables et Ordinateurs,,data/freeship/fr.html,,,fr,012RM0000002Q5M
0,Liberte Franqueo en Laptops y Ordenadores,,data/freeship/es.html,,,es,012RM0000002Q5M
```

     
| Title | summary\_\_c | description\_\_c | datacategorygroup .Products | Channels | RecordTypeID |
| --- | --- | --- | --- | --- | --- |
| Free Digital Camera Offer | Get the new Digital Camera. | data/freecam.html | Consumer\_ Electronics | application+csp | 012RM0000002Q5M |
| Best Desktop Computer Deals |   | data/bestdeals.html | Desktop | application+csp | 012RM0000002Q5g |
| Free Shipping on Laptop and Desktops |   | data/freeship.html | Laptop+Desktops | application+csp | 012RM0000002Q5M |

       
| isMasterLanguage | Title | summary\_\_c | description\_\_c | datacategorygroup .Products | Channels | Language | RecordTypeId |
| --- | --- | --- | --- | --- | --- | --- | --- |
| 1 | Free Digital Camera Offer | Get the new Digital Camera. | data/freecam.html | Consumer\_ Electronics | application +csp | en\_US | 012RM0000002Q5M |
| 0 | Libérer l'Offre d'Appareil photo digital | Obtenir le nouvel Appareil photo digital. | data/freecam/fr.html |   |   | fr | 012RM0000002Q5M |
| 0 | Liberte Oferta Digital de Cámara | Consiga la nueva Cámara Digital. | data/freecam/es.html |   |   | es | 012RM0000002Q5M |
| 1 | Best Desktop Computer Deals |   | data/bestdeals.html | Desktops | application +csp | en\_US | 012RM0000002Q5g |
| 0 | Meilleures Affaires d'ordinateurs de bureau |   | data/bestdeals/fr.html |   |   | fr | 012RM0000002Q5g |
| 0 | Mejores Tratos de ordenadores |   | data/bestdeals/es.html |   |   | es | 012RM0000002Q5g |
| 1 | Free Shipping on Laptops and Desktops |   | data/freeship.html | Laptops+ Desktops | application +csp | en\_US | 012RM0000002Q5M |
| 0 | Libérer Affranchissement sur Portables et Ordinateurs |   | data/freeship/fr.html |   |   | fr | 012RM0000002Q5M |
| 0 | Liberte Franqueo en Laptops y Ordenadores |   | data/freeship/es.html |   |   | es | 012RM0000002Q5M |

[Specify your import parameters](https://help.salesforce.com/s/articleView?id=service.knowledge_article_importer_03parameters.htm&release=264.0.0&type=5 "Specify import parameters in a property file using key names and corresponding values. For example, use the key DateFormat to specify that a date custom field appears in the DateFormat=dd/MM/YYYY format. Or, specify the character encoding and field separator used for the import file.") in a property file using key names and corresponding values.

#### See Also

- [Set Article Import Parameters](https://help.salesforce.com/s/articleView?id=service.knowledge_article_importer_03parameters.htm&release=264.0.0&type=5 "Specify import parameters in a property file using key names and corresponding values. For example, use the key DateFormat to specify that a date custom field appears in the DateFormat=dd/MM/YYYY format. Or, specify the character encoding and field separator used for the import file.")
- [Import External Content into Salesforce Knowledge](https://help.salesforce.com/s/articleView?id=service.knowledge_article_importer.htm&release=264.0.0&type=5 "Import external articles or an information database into Salesforce Knowledge. To move content from Classic to Lightning Knowledge, use the migration tool.")