Cognito form with check box options mapped to an excel table's respective columns based on the checkbox selected

I have a cognito form with questions that allows the user to vote (select) for all the checkboxes that apply to them. I need to map those answers to the respective column in excel so I can track how many votes each option gets.

For example, if they form submitted was for this:

Then I need to add a row that looks like this:

I know I need to use formatter but I’m not sure where to start with this one. If I can get the #’s, that’s fine, I can work with the actual option such as “Ancillary products” in the cell but must be in the correct column.

Page 1 / 1

Hi @Kim_M

Help link for how Excel spreadsheets need to be configured to work in Zaps: https://help.zapier.com/hc/en-us/articles/8496044256909-How-to-Setup-Your-Microsoft-Excel-sheet-to-Work-With-Zapier

I’ve got excel table set up properly but how do I take the outputs of the trigger from cognito forms, and add them to the matching columns. If this is the input of the trigger: