Recent searches
No recent searches
How to export Zendesk macros into a spreadsheet
Posted Apr 20, 2017
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!
15
71 comments
Brett Bowser
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 :)
0
Mary Paez
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?
0
Brett Bowser
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!
0
Kelly Scarbrough
Thank you so much for this. You probably just saved me HOURS of typing!
0
Sydra Stoner
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?
0
ZZ Graeme Carmichael
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:
0
Sydra Stoner
Thank you so much Graeme! Worked like a charm.
0
Mugeni Mukanga
Worked perfectly first time.
Thank you!
0
Rebekah McKinney-Perry
Super helpful, thanks a mil! :)
0
Vlad
Thanks for the feedback, Rebekah. Very glad to hear that!
I just spotted this post is created precisely 3 years ago :O
The days are long and the years are short. :)
0
Matthew Watts
Thanks to OP.
I am just not clear on point 2a and 2b
"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)
My understanding is that point 2 is for less than 100 macros?
We have over 200, so I used point 2a, but I did not understand the logic behind "the 2nd file?" What is a 2nd file?
I used both points, and both times it extracted over 200 macros, so I am not sure what the "more than 100 macros" has to do with anything?
Thanks to clarify.
0
Vlad
Hey Matthew, the key is that number of macros per an API call/request is limited to max 99 macros.
So, if you have eg 250 macros, you will have to do the call 3x.
How to do that? Just replacing the last part of the URL "page=2". So you should call it with: page=1, page=2, page=3. Let me know if anything still isn't clear. Best.
0
Pradeep Pillai
These links are not working. I changed the Domain name
XYZ.zendesk.com/api/v2/macros.json?per_page=99
https://XYZ.zendesk.com/api/v2/macros.json?per_page=99&page=2
0
Vlad
Hey Pradeep, I just checked and they seem to work. Please note you should remove XYZ from the links and put there your ZD subdomain. Sure, you need to be logged in as admin in your ZD.
0
Juan Espinosa
Hi There,
What is the best way to export by usage in the last 30 days;
I tried
https://(MyCompany).zendesk.com/api/v2/macros.json?per_page=99&sort_by=usage=30d
but was unable to do so
0
Matteo Genesio Stara
Hello Juan,
You can try using sideload instead (if your plan is Enterprise)
/api/v2/macros.json?include=usage_30d&sort_order=asc
Or the standard usage for macros:
/api/v2/macros.json?sort_by=usage_30d&sort_order=asc
You can change asc to desc.
Hope this helps!
0
Jed Bonilla Ephan
Is this link, http://xyz.zendesk.com/api/v2/macros.json?per_page=99, still functional? I tried it but it does not work. I'm getting the error message below.
0
Nicole Saunders
Hi Jed - Yes, that API call should still work. However, I clicked through to your account and it looks like you have a different subdomain listed there from the one you indicated in your comment above.
0
Mateusz Pietrzak
Hi, thanks for the tip how to export macros, it's very useful.
Is there a way to export the JSON file back to Zendesk with some changes? I want to add descriptions to macros and it would be very convenient if I could do it this way.
0
Brett Bowser
Hey Mateusz,
You would need to use the api to bulk import macros and make changes to the descriptions. The link I attached should provide some additional information for you.
Cheers!
0
Beth R
This works beautifully! It also helps if you want to find a specific word occurring in more than one Macro that needs to be changed. I recently had to change voice and tone for a specific term throughout our 500+ macro library and this saved me so much time.
0
Nicole Saunders
Glad you found this so useful, Beth! Thanks for sharing. :)
0
Christian Torres
Hi ZD team,
Thanks for your information, but, how can I to get personal macros?
Regards.
0
Jason Schaeffer
Hi Christian!
You can find your Personal Macros by going to Admin>Manage>Macros from there you can change the dropdown to Personal Macros. There is more information on tin this article:
Organizing and managing your macros
Have a great day!
0
Magda
Hi, is there a way to upload the macros again after making some changes??
0
Juraj Jarmek
Hello Magda,
We would have to convert the CSV file back to a .json file and import it back to the Zendesk account.
For more info:
Community post: How to re-Import Macros in CSV to Zendesk
API create macro
Hope that helps!
0
Joshua Bentley
Why are the columns in a different order between files? I've been working on writing macros for two days in Excel to do formatting and get rid of information I don't need only to discover that they won't work on every sheet because the columns are in a different order!
Here is an image of the rows copied and pasted from two different files with the different column titles highlighted. I'm only including the last few columns so as not to break the page width here. :)
1
Peter Hochstrasser
I just discovered that Powershell, while being a great platform for quickly creating little helpers, has some rough edges, i.e.
ConvertTo-Json commandlet:
So, if you use PowerShell, switch to PS7 to avoid problems.
0
Lateesha Clark
This was so helpful and REALLY easy to use. THANK YOU THANK YOU THANK YOU
0
Φάνης Τ.
Hello,
really nice workaround, any thoughts of how to export the Agents instead of all Users in a list?
ty
0