The Blog
Guides and deep dives for working with large CSV and Excel files.
GuideApril 18, 20266 min read
How to split a 10GB CSV file without crashing Excel
Excel has a hard row limit of 1,048,576 rows and collapses under memory pressure long before that. Here's how to split any CSV into manageable pieces — safely and instantly.
TutorialApril 18, 20267 min read
Merging CSVs with mismatched columns — a practical guide
When your files come from different systems, column names rarely match. Here's how to handle naming differences, extra columns, and missing fields without losing data.
Deep diveApril 18, 20268 min read
Why large file uploads fail and how CsvKit handles them
Network timeouts, browser memory limits, and single-request constraints are the main culprits. Here's how chunked uploads solve each problem and how CsvKit implements them.