Pivotly
Download
Help center

How can we help?

Guides and answers for every step in Pivotly.

Getting started

Pivotly reshapes tables in two directions – and remembers how, so you can repeat it with one click.

The two directions

Long → Wide (pivot)
A list with one column for the attribute name (key) and one for its content (value) becomes a table where every attribute is a column.
Wide → Long (unpivot)
The opposite: many columns become rows with a key and a value column.
ProductAttributeValue
A-100ColorRed
A-100SizeXL
B-200ColorBlue
B-200SizeM
ProductColorSize
A-100RedXL
B-200BlueM

Three ways to start

  • Click Long → Wide or Wide → Long on the home screen.
  • Drag a CSV, XLSX or ODS file anywhere into the window.
  • Press Ctrl + N.

The wizard

  1. Source – choose the file and check the preview.
  2. Direction – long → wide or wide → long.
  3. Columns – assign the columns; the live preview shows the result immediately.
  4. Target – format, folder and file name.
  5. Finish – save as a task and run.

Not sure which direction you need? If your file has one column with attribute names and one with values, it is “Long → Wide”.