Survey answers as Excel rows
Add a row to an Excel table or worksheet for each survey answer through a Zap that runs as soon as someone answers, so the workbook stays up to date.
From an answer in Usertick to Microsoft Excel
A Zap adds a row with the survey, the score, the answer and the date to the table or worksheet you choose, so the numbers you build on Excel stay current.
The Zap starts in Usertick. It can run on every new answer, once the AI has read one, when one turns urgent or when its status changes, and a workflow can hand over only the answers its conditions pick.
Pick a survey in the trigger, and each question arrives as its own field, so the score and the comment land in the Microsoft Excel fields you choose. The answer's email, page, country, device and AI reading come with it.
- Plan
- Every plan in Usertick, 1 Zap on Free
- Connects through
- The Usertick app on Zapier
- Zapier plan
- Zapier's free plan runs this two-step Zap
- Starts when
- An answer arrives, the AI reads it, it turns urgent, its status changes or a workflow reaches its Zapier step
What the Zap can do in Microsoft Excel
Choose the action in Usertick, and Zapier opens with the trigger and the action already in place.
- 01Add a row to a table
- 02Add a row to a worksheet
Zapier's page for Microsoft Excel listed 20 actions and searches on November 1, 2026. These fit survey answers best.
- Add Row to Table
- Add Row
- Update Row
- Find Row
- Find or Create Row
- Find or Create Worksheet
Three Zaps to build with Microsoft Excel
Each one starts on a Usertick trigger and uses an action from Zapier's page for Microsoft Excel.
Feed an Excel table behind a PivotTable
Answers to the NPS survey arrive through New Response, and Add Row to Table adds Q1, Country and Source to a table in your workbook, so a PivotTable built on that table includes the row after a refresh.
Microsoft Excel action: Add Row to Table
Update the Excel row when an answer's status changes
Response Status Changed looks up the Response link column through Find Row, and Update Row writes New status and Changed by to that row, so the workbook shows where each answer stands.
Microsoft Excel action: Update Row
Keep each AI category on its own Excel worksheet
After Response Analyzed, Find or Create Worksheet returns a worksheet named after the AI category, creating it for a new category, and a row step then adds the Answers to that worksheet.
Microsoft Excel action: Find or Create Worksheet
Zapier's free plan runs a Zap with one action. A Zap with a search step or a filter has more steps and takes a paid Zapier plan.
What Usertick sends to Zapier
Every trigger carries these fields, ready to map into Microsoft Excel.
Attachments such as screenshots stay in Usertick, because a Zap can't open their links. The Response link opens the answer with its files in the inbox.
Connect Microsoft Excel in three steps
Settings opens Zapier with the trigger and the action already in place.
- 1
Pick the action in Usertick
Open Settings, then Integrations, select Microsoft Excel and choose what the Zap does there.
- 2
Sign in on Zapier
Sign in to Usertick from the Zap and choose the organization when you allow access.
- 3
Map the fields and turn it on
Pick the survey to watch, map the answer's fields to Microsoft Excel and turn the Zap on.
To send only some answers, add a Zapier step for Microsoft Excel to a workflow instead. The workflow's conditions decide which answers reach the Zap, and the workflow can be published once its Zap is on.
Read the setup guideFrequently asked questions
Zapier works with files on OneDrive for Business, so a workbook kept on a computer or in a personal Microsoft account isn't available to the Zap. The first row of the worksheet has to hold the column headers that the Zap maps to.
Add Row to Table extends a named table, so the formulas, filters and PivotTables built on it take in the new row. Add Row writes to the end of the worksheet, which suits a plain log of answers.
Zapier comes with every plan in Usertick, and Free runs 1 Zap. On Zapier, a two-step Zap like this one runs on the free plan.
No. The Zap signs in with your Usertick account, and you choose the organization when you allow access. API keys are for Usertick's REST API.
Yes. Response Analyzed filters by type and urgency, Urgent Feedback runs once for each answer that turns urgent, and a workflow's Zapier step hands over only the answers its conditions pick.
Pick the survey in the trigger. Each question then arrives as its own field, such as Q1 with the score, ready to map into Microsoft Excel.
A Zap that starts in Microsoft Excel can use Usertick's actions. Update Response sets an answer's status, type or urgency, Add Comment adds a note your team sees in the inbox, and Find Response looks up an answer by email or ID first.
No. Attachments stay in Usertick, because a Zap can't open their links. The Response link field opens the answer, with its files, in the inbox.
More integrations
Listen better, act faster, and build what truly matters.
Start free, see what your customers mean, and get each answer to the person who can act on it.
- 150 responses a month on Free
- Every channel and AI analysis
- No card needed