Split by rows, by file count or by column
Marketplaces, email tools and import screens often limit how many rows a file may have, and spreadsheet programs slow down with very long files. Rows per file cuts the table into pieces of a fixed size, for example 5,000 products per file. Number of files divides it into equal parts when you need exactly four files for four colleagues.
Column value creates one file per distinct value of the column you choose. Split an order export by city, a product list by brand or a customer list by sales rep, and each file is named after its value, such as orders_Berlin.csv. Up to 1,000 different values are supported.
Merge files with different column orders
Monthly exports rarely line up perfectly. With Match columns set to By name, columns are matched by their header text, ignoring upper and lower case and extra spaces, so a file that has Price before Stock still lands in the right columns. Columns that exist in only some files are kept, with empty cells where a file has no value.
You can add a column with the source file name to see where each row came from, and remove duplicate rows when the same records appear in several exports. Excel workbooks can be merged sheet by sheet, so several sheets of one workbook become a single table.
Built for large files
A CSV file is read in small pieces in a background worker, so a 100 MB export with hundreds of thousands of rows is split without the page freezing, and a progress bar shows how far it has got. The separator is detected automatically, quoted values with commas or line breaks inside stay in one cell, and files saved by older Excel versions in a regional encoding are recognized.
Barcodes, postal codes and IDs with leading zeros are kept as text, also when you save the parts as Excel, and numbers longer than 15 digits are never rounded. CSV parts are saved as UTF-8 with a marker that tells Excel how to read accented letters.