Export and Google Sheets

Sometimes the answer lives in a spreadsheet: the accountant wants totals, the owner likes a sheet, or you're pulling numbers into something else. ↓ Export gets your tickets out, the way you want them.

Download a CSV

1. Open a stack's list and click ↓ Export.
2. Tick the Columns you want. Your list's columns start ticked. Select all ticks every one: every field, plus the requester and where each request came from.
3. Pick which tickets:
   • Tickets in this view keeps the filters you had on the list.
   • Every open and closed ticket is the whole stack.
   • Archived tickets is the stack's Archive.
4. Click ↓ Download CSV. It opens in Excel, Numbers and Google Sheets. Money columns are plain numbers, so you can add them up.

Keep a Google Sheet up to date

Rather than downloading a new file every week, let Google Sheets read the stack on its own.

1. On the Export page, tick the columns you want.
2. Under Keep a Google Sheet up to date, click Make a Google Sheets link.
3. Copy the formula. It looks like =IMPORTDATA("https://app.ticketstacker.com/api/sheets/…").
4. In Google Sheets, click cell A1 and paste it.

The sheet fills in with every open and closed ticket and refreshes about every hour. Build charts or totals on another tab of the same sheet, and they'll stay current too.

Keep the link private. Anyone who has it can see those tickets, so only share the sheet with people who should. If it gets out, click Make a new link with these columns (the old link stops working right away) or Turn off the link. Only the stack's Owners and Managers can make or change the link.

Want different columns later? Tick them and click Make a new link with these columns, then paste the new formula into your sheet.

Moving from a spreadsheet? See Move from Google Sheets.