Long and Wide Data Format Converter

Tool

1. Upload Your Data

Not sure about data formats? Check out the examples in the Learn More section below

Learn More

Understanding Long and Wide Data Formats

Long Format (Tidy)

Each row is an observation, with variables in columns

ID,Year,Measurement,Value
1,2020,Temperature,18.5
1,2020,Humidity,30
1,2021,Temperature,19.0
1,2021,Humidity,32
2,2020,Temperature,17.0
2,2020,Humidity,40
2,2021,Temperature,16.5
2,2021,Humidity,42

Wide Format

Data spread across multiple columns with unique identifiers

ID,Year,Temperature,Humidity
1,2020,18.5,30
1,2021,19.0,32
2,2020,17.0,40
2,2021,16.5,42

Long to Wide Transformation

Original Data (Long Format)

ID	Year	Measurement	Value
1	2020	Temperature	18.5
1	2020	Humidity	30
1	2021	Temperature	19
1	2021	Humidity	32
2	2020	Temperature	17
2	2020	Humidity	40
2	2021	Temperature	16.5
2	2021	Humidity	42

Column Selection for Long to Wide

Select these columns:

ID Columns:

ID (identifies unique entries)
Year (identifies unique entries)

Value Columns:

Measurement (will become new column names)
Value (will fill the new columns)

Result (Wide Format)

ID	Year	Temperature	Humidity
1	2020	18.5	30
1	2021	19	32
2	2020	17	40
2	2021	16.5	42

Wide to Long Transformation

Original Data (Wide Format)

ID	Year	Temperature	Humidity
1	2020	18.5	30
1	2021	19	32
2	2020	17	40
2	2021	16.5	42

Column Selection for Wide to Long

Select these columns:

ID Columns:

ID (stays as is)
Year (stays as is)

Value Columns:

Temperature (will be stacked)
Humidity (will be stacked)

This will create two new columns: "Measurement" (containing "Temperature" or "Humidity") and "Value" (containing the corresponding numbers)

Result (Long Format)

ID	Year	Measurement	Value
1	2020	Temperature	18.5
1	2020	Humidity	30
1	2021	Temperature	19
1	2021	Humidity	32
2	2020	Temperature	17
2	2020	Humidity	40
2	2021	Temperature	16.5
2	2021	Humidity	42

Can't find what you need?

If you couldn't find what you're looking for, we'd love to hear from you!

Let us know what you need