Zoho Survey: Bulk Exporting Raw Data (CSV/Excel) from 100+ Individual Survey Projects

Zoho Survey: Bulk Exporting Raw Data (CSV/Excel) from 100+ Individual Survey Projects

Hi Zoho Community,

I am currently managing a 360-degree evaluation process that involves 100+ individual survey projects (one separate survey for each employee being evaluated).

I need to download the raw response data (CSV or Excel) for all 100 surveys. Currently, the only way I see to do this is by entering each survey manually, going to Reports, and clicking Export. Doing this 100 times is not feasible.

My Requirements:

1.      I need the "Flat" format (where one row equals one respondent and answers are in columns), not the "normalized/relational" format found in the bulk Zoho Analytics sync.

2.      I am looking for a way to bulk download these 100 files at once or a way to consolidate them into one master "Flat" spreadsheet automatically.

I am not a developer, so any "low-code" suggestions or clear script examples would be greatly appreciated!

Attached is a screenshot of My Surveys Page and the outcomes of what I need.

Best regards,
Ake