Excel Transpose

Swaps rows and columns of Excel/CSV tables. Turns a vertical list into a horizontal summary or vice versa.

What it does

Use this when a long vertical list needs to fit horizontally on one page, or when you need to flip a wide summary into a vertical report. The bulk version of Excel's "Paste Special > Transpose".

How to use

1. Drag files into the list.
2. Pick a Processing Scope: just the first sheet or every sheet.
3. Tick Promote first column to header if you need that.
4. Click Run.

You get one transposed copy per input file.

Options

• Processing Scope: Transpose only the first sheet (default) or every sheet in the file.
• Promote first column to header: After the flip, treat the new first column as the header row. Useful for lists.
• Reset row indexing: Wipes old row numbers, the new table starts at 1.

Examples

Flip a 100-row product list into horizontal: Add the Excel, run with defaults. Products become columns instead of rows.

Flip monthly sales: A table with cities as rows and months as columns gets flipped so months become rows and cities become columns.

Survey results into a vertical report: If your questions are columns and answers are rows, transpose puts each question on its own row.

Flip a multi-sheet report end-to-end: Add the Excel, pick "All Sheets". Every sheet in the file is transposed.

Watch out

• After transposing, the old column headers become the first column of the new table. If you do not want that, delete the header row first.
• Very large tables flip into huge widths. Excel caps columns at 16,384, so a 50K-row file does not transpose cleanly.
• Merged cells do not survive cleanly.
• Encrypted Excel files are not handled.
• In batch mode the same settings apply to every file.

License

Free tier has a monthly transpose cap. Office plan removes it.