Skip to main content
People Splitter groups rows by household and generates multiple output CSV files for safer downstream import handling.

​
What It Does

  • Reads your uploaded file and finds the household column.
  • Groups rows by household ID.
  • Splits output into multiple files based on max cell limits.
  • Produces per-file CSV downloads and a zip download.

​
Current Defaults

  • Household column name: Household ID
  • Max cell count: 100000
The handler supports overrides through query parameters, but the current UI flow uses defaults.

​
Input and Output

  • Upload accepts .csv, .xls, .xlsx (max 50 MB).
  • Excel files are converted from first worksheet to CSV in-browser before upload.
  • Output files are named from the base filename (for example: people_1.csv, people_2.csv, …).
  • You can download each file individually or all files as a zip.

​
Split Behavior Details

  • Household IDs are matched by column name case-insensitively.
  • Households stay together whenever possible.
  • If a single household exceeds the max-cell threshold, that household is split across files.

​
Common Failures

  • Missing household column (Household ID by default)
  • Row column count mismatches
  • Invalid UTF-8 row content