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.
| Product | Attribute | Value |
|---|
| A-100 | Color | Red |
| A-100 | Size | XL |
| B-200 | Color | Blue |
| B-200 | Size | M |
→| Product | Color | Size |
|---|
| A-100 | Red | XL |
| B-200 | Blue | M |
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
- Source – choose the file and check the preview.
- Direction – long → wide or wide → long.
- Columns – assign the columns; the live preview shows the result immediately.
- Target – format, folder and file name.
- 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”.
Long → Wide (pivot)
Turn key/value rows into columns – several rows per record become one.
| Product | Attribute | Value |
|---|
| A-100 | Color | Red |
| A-100 | Size | XL |
| B-200 | Color | Blue |
| B-200 | Size | M |
→| Product | Color | Size |
|---|
| A-100 | Red | XL |
| B-200 | Blue | M |
1. Key column
The column whose values become the new column headings – here Attribute.
2. Value column
The column whose content goes into the new cells – here Value.
3. What belongs to one row?
All rows with identical values in the grouping columns are merged into one result row – here Product.
- All other columns (recommended): every column except key and value is used for grouping. New columns in future files are included automatically. Click a column to exclude it.
- Only selected: only the marked columns are used and kept in the result.
4. Duplicate keys
If the same key appears more than once for a row, a rule decides what happens. See Duplicate keys.
More options
- Order of new columns: as they appear in the file, or alphabetical.
- Ignore empty values: empty cells do not overwrite existing values.
The preview on the right is based on the first 3,000 rows. Watch the statistics: “10,000 rows → 1,000 rows” shows immediately whether the grouping is right.
Wide → Long (unpivot)
Turn many columns into key/value rows – the format databases and BI tools love.
| Product | Color | Size |
|---|
| A-100 | Red | XL |
| B-200 | Blue | M |
→| Product | Attribute | Value |
|---|
| A-100 | Color | Red |
| A-100 | Size | XL |
| B-200 | Color | Blue |
| B-200 | Size | M |
1. Columns to keep
Choose the columns that identify a record, e.g. a product number or customer name. They are repeated in every new row.
2. Everything else becomes key/value
All other columns are converted: the column heading goes into the key column, the cell content into the value column. New columns in future files are converted automatically.
Only want some of the columns? In step 2, choose Only selected, or click a column to leave it out. Columns that are neither kept nor converted do not appear in the result.
3. Names of the new columns
You can name the key and value columns freely, e.g. “Month” and “Revenue”.
Empty cells
With Skip empty cells (default), no rows are created for empty cells. This keeps the result compact.
Duplicate keys
What happens when a key appears more than once within the same group.
Example: product A-100 has two colors.
| Product | Attribute | Value |
|---|
| A-100 | Color | Red |
| A-100 | Color | Blue |
→| Rule | Result |
|---|
| Take first value | Color: Red |
| Take last value | Color: Blue |
| Join all | Color: Red; Blue |
| Separate columns | Color: Red · Color_2: Blue |
| Count | Color: 2 |
- Take first value
- Further values for the same key are ignored.
- Take last value
- The value that appears last wins.
- Join all
- All values are combined in one cell, separated by “; ”.
- Separate columns
- Repetitions get their own columns: Color, Color_2, Color_3 …
- Sum
- Numbers are added up. Text values are ignored.
- Count
- The number of values instead of the values themselves.
The preview shows a badge like “12× duplicate” when duplicates occur. If you did not expect any, check your grouping columns.
File formats & import settings
Pivotly reads CSV, Excel and LibreOffice files – and detects most settings automatically.
Supported formats
- CSV / TXT / TSV – any size.
- Excel .xlsx and .xlsm
- LibreOffice / OpenOffice .ods
The old Excel format .xls and .xlsb are not supported. Open the file in Excel and save it as .xlsx.
First row = headings
The first non-empty row is used as column headings. Empty headings are named after the column letter (A, B, C …); duplicate names get a number.
Worksheets
If a workbook has several sheets, choose the right one in step 1.
CSV settings
- Separator
- Detected automatically (semicolon, comma, tab, pipe). If the preview shows everything in one column, choose it manually.
- Encoding
- UTF-8 and Windows-1252 are detected automatically. If accented characters look wrong (e.g. “ü”), switch the encoding.
- Decimal separator
- Decides whether “1,5” or “1.5” is read as a number.
- Detect numbers
- Converts numeric text into real numbers. Values with leading zeros (e.g. “00123”) always stay text.
Saving: format, folder & file name
Choose where and how the result is saved – placeholders make tasks reusable.
Format
- Excel (.xlsx) – opens in Excel, Numbers, Google Sheets and LibreOffice. With frozen header row and filter.
- LibreOffice (.ods) – the open standard format.
- CSV – fastest and without a row limit. Choose separator, encoding and decimal separator to match the program that will read the file.
Location
Same folder as the source file is ideal for recurring tasks with changing files. Alternatively choose a fixed folder.
File name and placeholders
{name} – name of the source file{date} – today's date, e.g. 2026-11-11{time} – time, e.g. 14-30{task} – name of the task
Example: {name}_wide_{date} → sales_wide_2026-11-11.xlsx
If the file already exists
Add number creates “file (2).xlsx” and never overwrites anything. Overwrite replaces the old file – practical for reports that are always updated.
The result is first written to a temporary file and renamed only when complete. If you cancel, no half-finished file is left behind.
Saving & repeating tasks
Save a conversion once – repeat it as often as you like.
Save
In the last wizard step, keep Save as task checked and enter a name. All settings are saved: source, columns, rules and target.
Run again
- Run uses the same source file again – ideal if the file is updated regularly.
- Other file applies the task to a different file with the same structure, e.g. next month's export.
Tasks remember column names, not positions. A new file can therefore have its columns in a different order or contain additional columns.
Edit, duplicate, delete
Use the ⋯ menu on a task card. “Duplicate” is useful to create a variant, e.g. with a different output format.
Share with colleagues
Export saves the task as a .pivotly file. Your colleague opens it by double-click, via Import, or by dragging it into the window.
Large files & limits
Pivotly is built for big data – here is what to know.
How Pivotly handles large files
Files are read in chunks and processed in a separate background process. The window stays responsive, and you can cancel at any time. Millions of rows usually take only seconds.
Limits of the formats
- Excel and LibreOffice allow at most 1,048,576 rows and 16,384 columns per sheet. Larger results are automatically split across several sheets.
- CSV has no row limit – the best choice for very large data.
Memory
Unpivoting needs almost no memory. Pivoting must keep all groups in memory until the end. If memory runs short:
- use fewer grouping columns (“Only selected”),
- save as CSV,
- close other memory-hungry programs.
Fastest combination: CSV in, CSV out. XLSX and ODS files are compressed and take a bit longer to read and write.
License & free trial
Try everything for free – then activate with a license key.
Free trial
Pivotly can be used with all features for 14 days. After that you can still create and edit tasks, but running them requires a license.
Buy and activate
- Click Buy license on the License page.
- After purchase you receive the license key by email.
- Paste the key on the License page and click Activate.
Offline use
Activation needs an internet connection once. After that Pivotly also works offline. The license is confirmed briefly in the background every few days; without internet Pivotly keeps working for up to 60 days.
New computer
Click Deactivate on this computer on the old computer, then activate the key on the new one. If the old computer is no longer available, contact support.
Troubleshooting
Common messages and how to solve them.
- “Columns missing in the file”
- The file has a different structure than when the task was saved – a column was renamed or removed. Click Edit task and reassign the columns.
- “The output file is locked”
- The file is probably open in Excel. Close it and try again – or choose “Add number” as the overwrite rule.
- Everything is in one column
- The CSV separator was not detected correctly. Choose it manually in step 1.
- Strange characters such as “ü” or “�”
- Switch the encoding in step 1 between UTF-8 and Windows-1252.
- Numbers are wrong or stay text
- Check the decimal separator in step 1. Values with leading zeros intentionally stay text.
- Far too many new columns
- The key column is probably wrong – e.g. an ID column was chosen. Check step 3.
- Far more result rows than expected
- A grouping column contains values that differ per row (e.g. a timestamp). Exclude it or use “Only selected”.
- Not enough memory
- See Large files & limits.
- “.xls is not supported”
- Save the file in Excel as .xlsx.
Privacy & security
Your data never leaves your computer.
- All files are read and converted locally on your computer. Nothing is uploaded.
- Pivotly needs the internet only for the license: the license key and a device name (computer name and operating system) are sent to our payment provider Lemon Squeezy.
- Saved tasks contain settings and file paths – no table contents.
- Your source files are never changed. Results are always written to a new file (unless you choose “Overwrite” for the result).
Keyboard shortcuts
Work faster with the keyboard.
- Ctrl + N
- New task
- Ctrl + O
- Import task
- Ctrl + ,
- Settings
- F1
- Help
- Enter
- Next step in the wizard (in text fields)
- Esc
- Close dialog
- Ctrl + + / -
- Zoom in / out