How to export Zendesk macros into a spreadsheet

The Wise One - 2022Community Moderator

投稿日時：2017年4月20日

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!

71件のコメント

日付

新しい順

Eric Nelson

2021年11月01日

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!

Φάνης Τ.

2021年11月01日

Hello,

really nice workaround, any thoughts of how to export the Agents instead of all Users in a list?

Lateesha Clark

2021年9月08日

This was so helpful and REALLY easy to use. THANK YOU THANK YOU THANK YOU

Peter Hochstrasser

2021年7月02日

I just discovered that Powershell, while being a great platform for quickly creating little helpers, has some rough edges, i.e.

ConvertTo-Json commandlet:

if you use Windows Powershell version 5.1 as delivered with Windows 10 or earlier, PS does not reliably serialize deep objects - if your object goes beyond 2 levels, it actually does not serialize the deeper parts. The Problem is that there is no error message, just incomplete objects.
if you use PS 7, it gives you a warning message that serialization is not correct because of the greater depth of your objects. In addition, it allows you to specify parameter -Depth, which then allows you to write complete serialized objects.

So, if you use PowerShell, switch to PS7 to avoid problems.

Joshua Bentley

2021年3月11日

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. :)

Juraj Jarmek

2021年3月04日

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!

Magda

2021年3月01日

Hi, is there a way to upload the macros again after making some changes??

Jason Schaeffer

2021年2月19日

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!