A Next.js application for processing CSV files with comma-separated values in cells through row expansion and metric aggregation.
Row expansion transforms data where multiple values are stored in a single cell (comma-separated) into separate rows. This is particularly valuable when working with analytics data where events or content might belong to multiple categories.
Here's a simple example:
| Content group | Page views | Time on page |
|---|---|---|
| Sports,Tech | 1500 | 120 |
| News | 750 | 90 |
| Content group | Page views_sum | Time on page_average |
|---|---|---|
| Sports | 1500 | 120 |
| Tech | 1500 | 120 |
| News | 750 | 90 |
- Row expansion for comma-separated values
- Configurable metric aggregations (sum, average, max, min, count)
- Interactive data preview
- Processed file download
- Clean, intuitive interface