Question
How can I export all the macros of my account into a file?
Answer
There isn't an out-of-the-box feature that allows you to pull a list of all your macros. However, you can use the API end-point List Macros to retrieve all shared and personal macros available to the current user. Admins can retrieve any macro on the account regardless of who created it.
To retrieve personal and active macros, use the following code snippet:
api/v2/macros.json?access=personal&active=true
To append the code snippet to a URL
- Log in to the Zendesk account, this can be done by both agents and admins.
- Open the link mycompany.zendesk.com (replace mycompany with the account subdomain).
- To the end of mycompany.zendesk.com, add
api/v2/macros.json?access=personal&active=true
- Click return to populate a list of active personal macros available to the user.
Tip: Vladan Jovic, one of our Community Moderators, created the following tutorial on how to export Zendesk macros into a spreadsheet that uses the API referred to above.
11 comments
Nick Kassebaum
hey there! I made a tool to convert your zendesk .json file to CSV while excluding unwanted columns. It's currently in development and should be up soon. Sign up for the waitlist to get notified!
www.zendeskmacrosconverter.com
-3
Riley
hi, can I import the macros in bulk?
1
Mandy
The article on exporting macros is no longer available.
0
Brett Bowser
Check out this User Tip on exporting macros to a spreadsheet: How to export Zendesk macros into a spreadsheet
I hope this helps!
1
Support team
Hey! we have over 300 macros in different languages which we periodically update. Is there an easy way to import / export macros with all content and not create all the macros manually?
0
Support team
Brett Bowser also link above doesn't exist anymore
0
Afabio Junior
>> To export your macros, you can perform the following steps to get them via API:
1. you need to be logged in 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. The second file is on this URL https://XYZ.zendesk.com/api/v2/macros.json?per_page=99&page=2 (replace XYZ with 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 for a little
7. Click on the Download button.
You will be able to export all of your macros and have them as CSV.
>> To import Macros to Zendesk, they can be re-imported via the API using a POST to the Create Macro endpoint.
There is also an app available at our marketplace: Macro CSV Importer
>> Related to the link that you are not able to open, an error occurred last week resulting in the deletion of many community posts. Restoration efforts are underway, but posts could be missing for several days. For more information, please read this announcement.
I hope this helps.
1
Roman Sheydvasser
You can also use the per_page parameter to list out all of your macros if you have more than 100:
2
Luke Aleo
Drilling into this feature a little further - I'm able to pull the list of all my personal macros, but is there a way I can pull query for a specific user? I want to see all the personal macros of a single agent, and then be able to duplicate/copy them to another agent.
0
James G
You can access the personal macros created by your agents by navigating to your macros list in the Admin Center and applying the filter for "Available for Individual agents". This will display a list of personal macros created by your agents. However, please note that filtering for a specific user is not currently an option.
Additionally, you have the ability to clone those personal macros and make them accessible to either only to you, all agents, or to agents within a specific ticket group. Duplicating a personal macro from a single agent to another specific agent is not possible at the moment.
For more information, please refer to the following links:
Filtering the list of macros
Can I view the personal macros of other users on my Zendesk account?
0
Emily Carman
Hi - we have multiple brands within our Zendesk account. Is there a way to do this for just one of our brands? When I currently pull the list it pulls from both brands.
0