Convert Headerless TSV/CSV Data
Handle data files that lack a header row. Learn how the converter treats all rows as data when the header toggle is off.
Detailed Explanation
Converting Data Without Headers
Not all tabular data files include a header row. Sensor readings, log entries, and raw data dumps often consist entirely of data rows with no column names. The TSV/CSV converter handles this by allowing you to toggle the header row setting.
Example: Sensor Readings (TSV)
1709136000 23.5 45.2
1709136060 23.6 45.0
1709136120 23.4 45.3
1709136180 23.7 44.8
Converted to CSV
1709136000,23.5,45.2
1709136060,23.6,45.0
1709136120,23.4,45.3
1709136180,23.7,44.8
Header Toggle Behavior
When the Header Row toggle is turned off:
- The data preview table displays all rows as data (no bold header row)
- The row count reflects all rows, not all-minus-one
- No special treatment is given to the first row during conversion
When the toggle is on (default):
- The first row appears as bold column headers in the preview
- The row count shows data rows separately from the header
- Conversion behavior is the same in both cases — this setting only affects the preview display
Detecting Headers Automatically
There is no universal way to detect whether a file has headers. Some heuristics include checking if the first row contains non-numeric values while subsequent rows are numeric, but these are unreliable. The converter lets you make this decision explicitly.
Use with Positional Data
Many scientific and engineering data formats use fixed column positions without headers. Converting these between TSV and CSV preserves the column order and values exactly.
Use Case
Processing raw sensor data, machine-generated logs, or scientific measurement files that do not include column headers, and converting them to a different delimiter format for import into analysis tools.