Exporting and importing dynamic content

Return to top


  • Mateusz Pietrzak


    I would like to export our DCs, make some slight changes to language versions (I need to delete some lines from text) and import the file back to Zendesk. Would it be possible? 

    I tried to do this without success. The email I received states

    "Malformed CSV input.

     The error was:

    Illegal quoting, line 1."

    Would you have any advice? 

  • Brett Bowser
    Zendesk Community Manager

    Hey Mateusz,

    I'm going to create a ticket for you so we can take a look at the CSV file you're trying to import.

    You'll receive an email shortly stating your ticket has been created.


  • Omar

    I was struggling a bit for a while with the format for importing, until I realised i couldn't import dynamic content that hadn't been created yet, I think it would be a really useful tool to be able to import a csv file with the needed values to create new items in dynamic content and that they automatically are bulk created after import with the given values, also giving feedback about the process through email instead of directly through the app is a bit cumbersome when you are trying to figure out what's going on wrong.

  • Anne-Flore Caire


    I also need to know if there is a way to change the default language of each record by import, without having to do it manually? I have done several tests by changing the "Default language" in the file to the default language or the target one, but it does not work.

  • Gizem Candemir


    I agree with Omar that the need for creating dynamic content before importing is not practical at all. I would love to be able to export DC from Help Center to its Sandbox without needing to create the DC items one by one in Sandbox :/

    I hope it will be possible to bulk create DC in Sandbox while importing a csv file that is exported from Help Center.

  • Riah Lao


    How do you import the en version? I copied the columns from the exported en-US csv and use that to import but I got an error:

    Malformed CSV input.

    Expected column missing: Language text

  • Dane
    Zendesk Engineering
    Hi Riah,
    Your CSV should be similar to the one below. You also need to make sure that you have the values for "Title" and "en-US text".

    Hope this helps!
  • Jeffrey | Customer service

    Hi All,
    The system for importing excels within Zendesk is really hopeless. I work on an a Apple computer, but I can't get it done under Windows either.

    When you download the file from your Zendesk environment, the delimiter is:

    "Title","Default language","Default text","fr text","Variant status","Placeholder"

    If I export to a UTF-8 format from Excel (mac or Windows) I get the following string

    Title;Default language;Default text;fr-be text;Variant status;Placeholder

    Zendesk recognizes the ; not. Why can't you just import an xlx or an xls file?

    I am now always get the error: Column Title is missing.


  • Anne-Flore Caire


    for information (and because I had a lot of trouble before I got there), when I was working on the imports, living in France, I had to change : 
    - the Country Format of the PC in the "region" settings via the control panel (select "English (US)" )
    - the Excel separators in Options / Advanced Options / Editing Options (Uncheck "Use system separators" and change the "Decimal Separator" to ".") 

    All this makes that when I saved my excel files in separator ";", they saved in separator "," expected by Zendesk. And combined with the choice of the UTF-8 Format, it was good. 

    Note: don't forget to change theses parameters when the Zendesk work is finished

  • Riah Lao

    Is there a limit of rows for Dynamic Content import?

  • Christine
    Zendesk Engineering
    Hi Riah,

    You can create up to 2000 rows, but not exceeding 2MB file size.

    If you will need to import more than 2000 rows, please split your files and wait for the ‘import_ready’ mail confirmation before submitting the next file. Remember to keep the headers in the different files to preserve the format.

    Hope this helps!
  • Max


    Quick question : if I export my csv, change some titles, and import back the csv, what would happen ? I guess it wouldn't modify the lines because the title is the identifier. Will it create a new line ?

    Any workaround to modify titles in bulk action ?

    Thank you

  • Salim Cheurfi
    Zendesk Customer Care
    Hi Maxime, 
    If you export the CSV file then import it again with a new title for your Dynamic content, you will get an error "Tittle not found" 
    I'm afraid we don't have a native way to edit titles in bulk I'm sorry, you can use the API to update titles PUT /api/v2/dynamic_content/items/{dynamic_content_item_id} but it's not meant for bulk editing. 
    Don't hesitate to post a feature request in our feedback forum 
    Have a great one !

Please sign in to leave a comment.

Powered by Zendesk