How to export Zendesk macros into a spreadsheet
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 (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?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!
-
Hi CSM Zendesk,
Could you clarify what sort of data you're looking to export in regards to macros?
Just want to make sure we're both on the same page here :)
-
WOW! This was fast and easy! Thank you for this post. It was very helpful.
Do you have something similar for exporting a report from the Zendesk Manage articles UI based on applying a filter?
-
Hey Mary,
There are are a couple of options for exporting Help Center content as mentioned here: Help Center data export
The most common method I've seen is through Kbackup integration that was developed in our App Marketplace: kBackup
If you have any questions regarding the integration you'll want to reach out to the developer directly.
Hope this helps!
-
Thank you so much for this. You probably just saved me HOURS of typing!
-
We've been using the https://XYZ.zendesk.com/api/v2/macros.json?group_id=XXXXX option to download macros based on the group, but cannot figure out how to get the next page of macros for that specific group. Does anyone know how to do that?
-
Syd S
Try this:
https://XYZ.zendesk.com/api/v2/macros.json?group_id=XXXXX&page=2
Or look for the 'next page:' url near the end of your output:
-
Thank you so much Graeme! Worked like a charm.
ログインしてコメントを残してください。
37 コメント