CSV Format Guide
Basic Format
Your CSV file should have column headers in the first row, with data values in subsequent rows. Use commas to separate columns.
PartID,Operator,Diameter_mm
P0001,Alice,25.0034
P0002,Bob,25.0121
P0003,Alice,24.9856Column Roles
QC Dashboard automatically detects column roles based on header names. You can also assign them manually during the upload process.
| Role | Data Type | Examples |
|---|---|---|
measurement | Numeric | 25.003, 10.15, 62.1 |
operator | Text | Alice, Bob, Carlos |
machine | Text | CNC-01, CNC-02 |
shift | Text | Day, Night |
timestamp | Date/Time | 2025-01-15 08:30 |
defect_type | Text | Scratch, Dent, Burr |
spec_upper / spec_lower | Numeric | 25.15, 24.85 |
Tips for Best Results
- Use descriptive column headers (e.g., "Diameter_mm" instead of "Col1").
- Include at least 20 data points per group for meaningful SPC analysis.
- Use consistent formatting -- avoid mixing "Day" and "day" in categorical columns.
- Numeric values should use a period (.) as the decimal separator.
- Remove blank rows or summary rows at the bottom of your spreadsheet before exporting.