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.
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.
8 Comments
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
hi, can I import the macros in bulk?
The article on exporting macros is no longer available.
Check out this User Tip on exporting macros to a spreadsheet: How to export Zendesk macros into a spreadsheet
I hope this helps!
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?
Brett Bowser also link above doesn't exist anymore
>> 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.
You can also use the per_page parameter to list out all of your macros if you have more than 100:
Please sign in to leave a comment.