Exporting submissions

CSV from the dashboard

Open Submissions, or a form's own submissions tab, set the filters you want and choose Export CSV. The file follows the filters on screen.

• Columns are id, created_at, form, status, then one column per field. For a single form, its defined fields come first, followed by any other field names found in the exported rows.
• Arrays of plain values are joined with a comma and a space. Objects are written as JSON.
• Values that start with =, +, -, @, a tab or a carriage return get a leading ', so spreadsheet apps don't run them as formulas.
• The file is UTF-8 with a byte order mark, so Excel opens accents correctly.
• One export holds up to 100,000 rows and 500 field columns. Narrow the filters for larger workspaces, or use the API.

Everything with the REST API

For a full backup, a scheduled sync or more than 100,000 rows, page through the REST API with a secret key that has submissions:read. Lists are newest first and stable while new submissions arrive.

import { createWriteStream } from "node:fs";
import { createClient } from "@ikiform/sdk";

const ikiform = createClient({ apiKey: process.env.IKIFORM_SECRET_KEY! });
const out = createWriteStream("submissions.jsonl");

for await (const submission of ikiform.submissions.iterate({
  formId: "frm_xxxxxxxxxxxxxxxx",
  status: "received",
  limit: 100,
})) {
  out.write(`${JSON.stringify(submission)}\n`);
}

out.end();