📋 Data Format Guide

Overview

This tool is designed to be flexible and work with various CSV data formats. Below are the supported formats and requirements.

Format 1: With Test Limits

Best for: Manufacturing data with specifications

UnitID Measurement1 Measurement2 Result
Upper Limit 100.5 200.3 ATTR
Lower Limit 90.2 180.1 ATTR
Unit mm mm -
UNIT001 95.3 195.2 PASS
UNIT001 96.1 194.8 PASS
Format 2: Simple Data

Best for: General measurement data

PartNumber Length Width Height
PART_A01 25.4 12.7 5.2
PART_A01 25.3 12.8 5.1
PART_A02 25.5 12.6 5.3
Requirements
Required Elements
  • Unit/Part Column: First column with unit/part identifiers
  • Measurement Columns: Columns with numeric measurement data
  • Multiple Measurements: At least 3 measurements per unit for GRR analysis
Optional Elements
  • Test Limits: Upper/lower limits in first 2 rows
  • Units Row: Measurement units in 3rd row
  • Result Column: PASS/FAIL results (will be auto-detected)
  • Operator/Tester Column: For appraiser information
Auto-Detection Features
Column Detection

Automatically identifies unit column and measurement columns

Format Recognition

Detects if data has test limits or is simple measurement data

Data Filtering

Automatically filters PASS results if available

Accepted Column Names
Unit/Part Identifiers
  • SerialNumber
  • UnitID
  • PartNumber
  • SampleID
  • Any non-numeric column
Result Columns
  • Overall Result
  • Result
  • Pass/Fail
  • Status
  • Any column with "result"
Operator/Tester
  • TesterID
  • Operator
  • Appraiser
  • Inspector
  • Any column with "tester"
Measurement Data
  • Any numeric column
  • Length, Width, Height
  • Dimension_X, Dimension_Y
  • Measurement1, Measurement2
  • Custom measurement names
Tips for Best Results
  • Clean Data: Remove empty rows and columns
  • Consistent Units: Use the same unit identifier format throughout
  • Mixed Data Types: Non-numeric values (like 'PASS', 'FAIL', text) are automatically ignored
  • Multiple Trials: Include multiple measurements per unit for better GRR analysis
  • File Size: Keep files under 16MB for optimal performance
  • Flexible Format: The tool adapts to your data structure automatically
Try the Demo

Want to see how it works? Try our interactive demo with example data:

Start Demo

Load example data and run analysis

Download Example CSV

Get the sample input data file

Download Excel Template

Get the GRR template file

Note: Demo files are examples only. You can upload your own files following the same format structure.
Back to Upload