How do I split a CSV into smaller files without breaking rows?
Turn on Record-aware parsing, then choose Lines per file and enter a row count such as 1000. Quoted fields containing commas or newlines stay inside one record, and Repeat header row copies the header into every output. Line ranges such as 1-1000, 1001-2000 are also supported.