List to Columns
Fill Direction Explained:
1, 2, 3 → 4, 5, 6 → 7, 8, 91, 4, 7 → 2, 5, 8 → 3, 6, 9Related Tools
What is List to Columns?
List to Columns is a formatting tool that converts a single-column list into a multi-column layout. This is useful for creating tabular data, printing lists more compactly, or preparing data for spreadsheets.
You can customize the number of columns, choose how items are filled (rows first or columns first), and select different separators like tabs, commas, or pipes. The tool also supports converting multi-column data back to a single column.
All processing happens locally in your browser, ensuring your data remains private and secure.
Fill Direction Options
Rows First
Items fill horizontally across each row before moving to the next row. For 3 columns with items 1-9: Row 1 gets 1,2,3 | Row 2 gets 4,5,6 | Row 3 gets 7,8,9.
Columns First
Items fill vertically down each column before moving to the next column. For 3 columns with items 1-9: Column 1 gets 1,2,3 | Column 2 gets 4,5,6 | Column 3 gets 7,8,9.
Frequently Asked Questions
How do I choose the number of columns?
Use the "Number of Columns" input field. You can enter any value from 1 to 20. The tool will automatically calculate how many rows are needed based on your list size.
What separators can I use between columns?
Choose from Tab, Space, Comma, Pipe (|), or enter a custom separator. Tabs work well for spreadsheets, while commas are good for CSV files.
Can I convert multi-column data back to a single list?
Yes! Click the "Back to Single Column" button. The tool will detect common separators (tabs, commas, pipes) and split each line back into individual items.
What happens with uneven lists?
If your list doesn't divide evenly into columns, the last row will simply have fewer items. Empty cells are not added.