How to extract Input Table Data to Excel using Zapier

Hi, I want to extract the data from the form to excel using Zapier.

The issue I have is with the drop-down box or the input table. It won't extract the selection of the dropbox box and also the number from the input table.

How do I extract those data in Zapier?

Hi cmcnztreasurer,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Regarding your issue with extracting data from drop-down boxes and input tables to Excel using Zapier, these fields sometimes require specific handling in Zapier to capture their values correctly.

Let me show you how:

1. In Zapier, ensure you select the correct field from the Jotform trigger that corresponds to your drop-down or input table.
2. For input tables, the data may come as a JSON or text string; you might need to use Zapier's Formatter tool to parse and extract the numbers.
3. For drop-down selections, verify that the field is mapped correctly and that the form submission includes the selected value.

If you continue to face issues, checking the exact data output in Zapier's test step can help identify how the data is received.

Give it a try and let us know how it goes.

no

Hi cmcnztreasurer,

To extract drop-down and input table data in Zapier, ensure you select the correct fields from the Jotform trigger. Input table data may appear as JSON or text, so use Zapier's Formatter to parse it if needed. Also, verify the drop-down field is properly mapped and included in the submission data.

Check the test output in Zapier to see how the data is received and adjust accordingly.

Not solved

Hi cmcnztreasurer,

If the data extraction issue persists, try these steps:

1. Recheck your Zap setup: Ensure the Jotform trigger is correctly connected and pulling the latest submissions.
2. Use Zapier Formatter: For input tables, parse the data using Formatter to extract numbers properly.
3. Test with new submissions: Sometimes Zapier fetches old data; submit a new form entry and retest.
4. Consider downloading submissions directly: You can download your form submissions as Excel files from Jotform Tables as an alternative.

These steps often resolve common extraction issues with drop-downs and input tables in Zapier.

No

Hi cmcnztreasurer,

If the issue continues, please double-check your Zapier field mappings and try submitting a new form entry to test. Also, consider downloading your submissions directly from Jotform Tables as an Excel file.

I need live agent help please

Hi cmcnztreasurer,

One of our Support Team members will take it from here to follow up shortly.

Hi cmcnztreasurer,

Thanks for reaching out to Jotform Support. I understand what you’d like to do, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

Thanks for your patience, we appreciate it.

Hi cmcnztreasurer,

From what I tested, only the Input Table shows complex values when mapped to Excel. The dropdown field values came through just fine. Check out the screenshot below to see what I mean:

Now, if you're looking to add each row in the Input Table to be passed onto a column in Excel, you can use Code by Zapier. Using this tool, you can extract the data from the value you get from the form submission. It's easy to set up. Let me show you how:

1. In Zapier editor, add a step after the trigger by clicking on the Plus icon.

2. In the window that opens, choose look for and click on Code under Popular Built-in Tools category.

3. In the menu on the right, choose Run Javascript from the Action Event dropdown, then click on Continue.

4. Copy the Javascript code below.

const rawData = inputData.inputString;

const rows = rawData.split('|');

let result = [];

rows.forEach(row => {

 const parsed = JSON.parse(row);

 result = result.concat(parsed);

});

//change numValues depending on the number of rows to extract

const numValues = 4; 

const sliced = result.slice(0, numValues);

let outputObj = {};

sliced.forEach((val, i) => {

 outputObj[`value${i + 1}`] = val || '';

});

return outputObj;

5. In the next screen, enter inputString in the Input Data field.

6. Click the Add icon on the right, then find and select the dynamic content that matches your form’s Input Table.

7. Now, paste the code you copied into the Code box and click Continue. You can change the number in the numValues variable to match how many rows you want to extract. In this example, I used 4 since my Input Table has 4 rows.

8. Click on Test Step on the next screen, then if all went well, you should see the values now separated into different variables named Value 1, Value 2, and more.

9. Next, assuming that you've already connected your Excel file to the next step, map the extracted values to the intended column in Excel.

10. You can find the extracted values under Run Javascript in Code by Zapier step. As mentioned, first row is Values 1, second row is Value 2, and so on.

11. Click on Continue after mapping the fields, then click on Test Step, and that's it.

Check out the screenshot below to see how the extracted data looks like in my Excel file:

Give it a try and let us know if you need any more help.