How to export Zendesk macros into a spreadsheet

Vlad

• April 20, 2017 16:26

Community Moderator

Regarding to this post I decide to make this short tutorial.

1. you need to be logedin as Admin or Agent of your ZD account.
2. open this link XYZ.zendesk.com/api/v2/macros.json?per_page=99 (but change XYZ to your zendesk account name)
2a. If you have more than 100 macros, you should export one more JSON file cause it's up to 100 macros per export. Second file is on this url https://XYZ.zendesk.com/api/v2/macros.json?per_page=99&page=2  (replace XYZ to your ZD name)
3. When json file is loaded, save it on your computer (CTRL+S or CMD+S)
4. Open site: https://json-csv.com/
5. Upload your JSON file
6. Wait a little
7. Click on Download button.

Ta-Da, you have your macros exported in CSV file format.

Hope this helps!

• Eric Nelson

  • November 01, 2021 17:16

  Zendesk Developer Advocacy

  Hey Φάνης,
  
  You can do this by using the roles parameter in the url: https://{subdomain}.zendesk.com/api/v2/users.json?role[]=agent . 
  
  Hope this helps!
  
• Steve W

  • February 05, 2022 17:49

  How sad is it that the ability to Export macros had to be developed by an extremely helpful USER and not by Zendesk Dev? Although this way is helpful (Thanks Vlad!), my organization uses close to 900 macros, across multiple departments, this way is extremely cumbersome and way too time consuming, especially since we add and remove macros weekly.  
  
  An Export button is ESSENTIAL and takes minimal development time!
  
  Come on Zen Desk, do better!!!

• Pablo Gonzalez

  • July 11, 2022 13:59

  Hi everyone,

  We have a free and open-source app that allows you to export all your Zendesk macros into simple text files. You don't need any scripts or knowledge about the Zendesk API.

  You can then make changes to those text files (such as fine and replace) and then bulk import the configuration with a simple command.

  This supports macros, triggers, views, fields, and anything in between.

  You can check it out here How to export Zendesk macros and bulk import them with Salto’s free app

  And here's a video as well on how to do it https://youtu.be/smiolaVsIJU

• Lais

  • May 10, 2023 17:27

  Oh my god! Perfect, thank you so much

• Ricardo

  • August 25, 2023 21:11

  Is there a way UPLOAD a .json file with macros? (instead of downloading)

• Peter Hochstrasser

  • August 26, 2023 14:20

  @ricardo:
  Using the API, yes.

• Ricardo

  • August 30, 2023 16:55

  Peter Hochstrasser how exactly I can do that?

• Noly Maron Unson

  • September 07, 2023 10:13

  Zendesk Customer Care

  Hi Ricardo,

  You can utilize the Create Macro endpoint. This way, you can use a JSON format to create your macro.

  Hope this helps.

Please sign in to leave a comment.