Split File

One big file in, a ZIP of smaller files out, three ways. Group rows by a column's values and Operelio creates one file per unique value (per region, per rep, per status). Chunk by row count for fixed-size files. Or split columns into separate files, sending groups of columns (like CRM fields and email fields) to their own files. Each output file gets its own copy of the header row, ready to hand off or import.

Use this when you need to distribute parts of a file to different people or systems. Common examples: splitting a contact list by region so each sales rep gets their own file, breaking a large file into chunks under a downstream system's row limit (like a CRM that caps imports at 5,000 rows), or sending different column sets to different destinations, like CRM fields to your CRM and email fields to your email platform.

Pick a column like "region" or "sales_rep". Operelio groups all rows by their value in that column and writes each group to its own file; every file keeps all your columns. File names are based on the column value: if your input is "contacts.csv" and you group by "region", you get files like "contacts_EMEA.csv", "contacts_APAC.csv".

Letters, numbers, spaces, hyphens, and underscores in the column value are kept as-is in the filename. Other characters (slashes, periods, quotes, ampersands) become underscores. Filenames are also trimmed to 100 characters, and leading and trailing spaces are removed.

If two different values would produce the same filename (for example "A/B" and "A_B" both reduce to "A_B"), Operelio appends "_2", "_3" and so on to keep them unique, and the results page lists a warning naming both files. Rows with a blank value in the split column go into a file named with the suffix "_empty"; a value that is only spaces counts as its own distinct value and gets its own "_empty"-family file.

Each output file includes the same header row.

Choose a number of rows per file. The default is 1,000. Operelio splits the file into sequential chunks: data_part1.csv, data_part2.csv, and so on. Each file gets the same header row and keeps all your columns. The last file may have fewer rows than the chunk size.

Numbers below 1 (or non-numeric input) fall back to the default of 1,000. The input is just a hint.

Build groups of columns, and each group becomes one file containing the picked columns (in the order you pick them) and every row. Name each group, or Operelio numbers them columns_1, columns_2. Useful when different destinations want different fields from the same list.

The "Include in every file" option puts the columns you pick there (usually an ID column) at the front of every output file, so the files stay joinable after the split.

A column can appear in more than one group. Columns that are in no group (and not included in every file) are left out of the output entirely; the preview and the results page both warn you which ones, so nothing vanishes silently.

The results page shows: total input rows, number of files created, the largest file's row count, a fourth figure matching your mode (rows per file, unique values, or column groups), settings pills for the split mode (and the column when applicable), and a list of output files with their row counts (the first 100 for very large splits; the full set is always in the ZIP). Row-grouped files also show the column value they contain; column-group files show the group name and column count. Anything noteworthy from the run, like blank values grouped into an "empty" file or a shortened filename, appears in a warnings panel below the table.

Pro: 50,000 rows and 25 MB per file, up to 500 output files per job. Team: 75,000 rows and 35 MB per file, up to 1,000 output files per job. Agency: 150,000 rows and 100 MB per file, up to 2,000 output files per job.

Row grouping uses one column per job. To group by a combination (region + year), use Column Manager to merge those columns first, then group by the merged column.

By default, output files are CSV regardless of whether the input is .csv, .xlsx, or .xls, packaged as a ZIP archive. When grouping rows by a column's values you can instead choose tabs output: one Excel workbook with a tab per group, each tab keeping only the columns that hold data for its rows.

If your file exceeds your plan's row limit, Operelio processes the first N rows and shows a banner with the total row count, the limit applied, and the rows processed.

Your file is uploaded to our servers, processed, and the output is held for download according to your plan's retention period: 24 hours on Free, 30 days on Pro, 30 days on Team, 90 days on Agency. Files are permanently deleted from storage after the retention window. You can also delete a file manually at any time from your job history.