1. Standardizing Database Exports
Data AnalystBackground
A database export provided a raw CSV file with 500 rows of user activity but no column names, making it impossible to import into a dashboard.
Problem
The file lacks headers, preventing automated ingestion into the reporting software.
How to use
Paste the CSV content, select 'Custom Headers' mode, and enter 'UserID,Timestamp,Action,Duration'.
headerMode: custom, customHeaders: 'UserID,Timestamp,Action,Duration'Outcome
The tool prepends the specified headers to the top of the file, allowing for immediate import into the BI dashboard.