Form Submissions Batch (CSV)
Twelve fictional submissions in one export, including values with commas, embedded quotation marks, an embedded newline, an empty cell and non-ASCII text. Sized for testing an importer rather than a database.
submission_id,form,submitted_at,full_name,email,topic,urgency,consent,message
SUB-0001,labelling-explicit-for,2026-08-01T09:14:00Z,Sample Person One,one@example.com,support,normal,true,A fictional first message.
SUB-0002,labelling-explicit-for,2026-08-01T10:02:11Z,Sample Person Two,two@example.com,sales,low,false,"A fictional second message, with a comma in it."
SUB-0003,labelling-explicit-for,2026-08-01T11:37:45Z,Sample Person Three,three@example.com,press,high,true,"A message containing ""quoted"" words."
SUB-0004,appointment-slot-booking,2026-08-02T08:00:00Z,Sample Person Four,four@example.com,support,normal,true,"Line one.
Line two inside one field."
SUB-0005,appointment-slot-booking,2026-08-02T08:45:19Z,Sample Person Five,five@example.com,support,urgent,true,A fictional fifth message.
SUB-0006,warranty-registration,2026-08-03T14:22:03Z,Sample Person Six,six@example.com,sales,low,false,
SUB-0007,warranty-registration,2026-08-03T15:10:59Z,Sample Person Seven,seven@example.com,sales,normal,true,Semi-colons; and pipes | stay literal in a quoted field.
SUB-0008,granular-consent-form,2026-08-04T07:05:30Z,Sample Person Eight,eight@example.com,press,normal,false,A fictional eighth message.
SUB-0009,granular-consent-form,2026-08-04T09:41:12Z,Sample Person Nine,nine@example.com,support,high,true,A fictional ninth message.
SUB-0010,likert-survey-matrix,2026-08-05T12:00:00Z,Sample Person Ten,ten@example.com,support,low,true,"Unicode: Ελληνικά, 日本語, العربية."
SUB-0011,likert-survey-matrix,2026-08-05T13:26:41Z,Sample Person Eleven,eleven@example.com,sales,normal,false,A fictional eleventh message.
SUB-0012,time-off-request,2026-08-06T16:48:07Z,Sample Person Twelve,twelve@example.com,support,normal,true,A fictional twelfth message.
Specifications
- Rows
- 12
- Columns
- 9
- Header
- true
- Encoding
- UTF-8
Testing contract
Expected to pass- Scenario
- Exercise Form Submissions Batch (CSV) in its form data workflow. Twelve fictional submissions in one export, including values with commas, embedded quotation marks, an embedded newline, an empty cell and non-ASCII text.
- Expected result
- 12 data records using ',' delimiters and UTF-8; header fields are submission_id, form, submitted_at, full_name, email, topic, urgency, consent, message; data-record widths (columns:count) are {"9":12}. Declared feature checks: columns=9; header=True.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Form Submissions Batch (CSV)” is a deterministic Testaroo fixture for Form parsing, Form testing, CSV parsing. PDF AcroForms with documented fields and live HTML forms for testing form parsers and fillers.
Documented properties for this file: 12 rows · 9 columns · UTF-8. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
This form is fictional SAMPLE content for tooling tests (autofill, scrapers, PDF fillers). It is not an official government, bank, or clinic form. Open the HTML offline or fill the PDF in any viewer; the demo submit path never stores data.
Code examples
import pandas as pd
df = pd.read_csv("form-submissions-batch.csv")
print(df.head())
print(df.dtypes)Related files
- csv10,000-Row CSVA CSV with 10,000 data rows, for testing streaming parsers, memory handling, and import performance.
- csvAlder Books Reconciliation: Trade credit referencesTrade credit references for Alder Books Reconciliation. 3 trade references with credit limits, highest balance reached and average days to pay. Every highest_balance_usd is below its own credit_limit_usd, so a utilisation check passes on all three, and the two supplier names are the suppliers the inventory-manufacturing model actually buys from.
- csvAlder Table Bistro: Allergen matrixAllergen matrix for Alder Table Bistro. 4 menu items across 18 columns: the fourteen listed allergens plus a count and a sources column naming the ingredient behind every Y. Derived from the recipe lines, so a dish whose recipe contains a dairy ingredient reads Y under milk. 2 of 4 dishes declare at least one allergen.
- csvAlder Table Bistro: Allergen matrix missing a menu itemAllergen matrix missing a menu item for Alder Table Bistro. Intentionally incomplete. 3 rows where the recipes cost 4 menu items. MENU-04 (Potato gratin) has no row, although it has costed recipe lines in plate-costs.csv and sales in sales-mix-pmix.csv. Its correct row would declare: milk: Cream.
- csvAlder Table Bistro: Allergen menu as dataAllergen menu as data for Alder Table Bistro. 4 rows and 21 columns: the menu item id, the printed section, the menu price, the 14 allergen columns, the declared count and the ingredient sources. 2 of 4 dishes declare at least one allergen. Joins to printed-menu.pdf and to plate-costs.csv on menu_item_id.
- csvAlder Table Bistro: Allergen menu missing a dish on the menuAllergen menu missing a dish on the menu for Alder Table Bistro. Intentionally incomplete. 3 rows where allergen-menu.csv has 4. MENU-02 Tomato soup is printed on printed-menu.pdf at 11.50 CAD and declares 1 allergen in the costing folder, and it has no row here. The remaining rows are correct.
Generated by generation/forms_p7.py. Free for any use, no attribution required, license.