Split CSV by Date - Separate Files by Day/Month/Year

Split CSV files by date column. Create separate files for each day, month, or year. Free online splitter. 100% private.

Back to Tools

Split by Column

Automatically split one file into many based on a specific column.

How to Split by Column

  1. 1Upload your CSV file containing a date column
  2. 2Select the date column to split by
  3. 3Download a ZIP file with separate CSVs for each date

Why Use This Tool?

  • ✓Organize by Time - Perfect for daily or monthly reports
  • ✓Automatic Naming - Files named by date (e.g., 2023-01-01.csv)
  • ✓Batch Output - Get hundreds of files in one ZIP
  • ✓Preserves Data - Headers and row content kept intact
  • ✓Instant - Split 100,000 rows in seconds

Frequently Asked Questions

Can I split by Month instead of Day?

The tool splits by the exact value in the cell. To split by month, first use the "Standardize Dates" tool or edit your date column to be YYYY-MM format.

What date formats are supported?

Any text format works! The tool groups rows that have the exact same text in the selected column.

Is there a limit on the number of dates?

No limit. If you have 365 days of data, you will get 365 separate files.