Two CSVs ship per pack. The **schema CSV** describes the form so you can recreate it inside your HRIS. The **submissions CSV** is the running ledger of every hosted-form submission — bring it into your warehouse, your auditor's spreadsheet, or your monthly report.
STEPS- 01
Schema CSV — for your HRIS
From the dashboard, click `Download` under CSV. The file lists every field: section, label, type, required, options, regulator citation. Map these columns to your HRIS field model and import.
section_id,section_name,field_id,field_label,field_type,required,options,pathways,regulator,help
- 02
Submissions CSV — for reporting
Click the `Download submissions CSV` button below the format grid. One row per submission, one column per field, plus `audit_hash` and `submitted_at`. Open in Excel / Google Sheets / Power BI.
- 03
Import into Bamboo HR
Bamboo → Settings → Import Data → Custom CSV. Map `field_id` → Bamboo field name. Required columns: `field_label`, `field_type`. The schema CSV ships in the exact shape Bamboo expects.
- 04
Import into Workday
Workday accepts CSV through the Data Import wizard (Setup → Integrations → Data Import). Use the schema CSV as the field-config source. The submissions CSV maps onto Workday's standard `Worker_Profile` import shape.
- 05
Schedule weekly snapshots
If you want a weekly snapshot dropped into S3 / Drive, hit the `/api/export/[slug]/csv?kind=submissions` endpoint from your scheduler with your licence slug. The endpoint requires the licence to be active — no extra auth.
curl -O https://forms.thekapture.com/api/export/<licence-slug>/csv?kind=submissions
What's the encoding?
UTF-8 with comma delimiters. Excel on Windows sometimes mis-detects this — open via `Data → From Text/CSV` and pick UTF-8 explicitly.
Can I get JSON instead?
The Google Forms export returns JSON. For the wider 'submissions as JSON' use case, contact us — the API supports it but the dashboard UI is CSV-only today.
Does the submissions CSV include payroll-sensitive fields?
Yes — bank and pension fields are present. Treat the file as confidential and store in a controlled-access location.