# Column Reorder

Reorder table columns without changing the data rows

> Canonical page: https://elysiatools.com/en/tools/column-reorder

- **Category:** Data Processing

- **Keywords:** column, reorder, rearrange, table, csv, columns, move, column reorder

## Overview

The Column Reorder tool allows you to quickly rearrange the structure of your CSV or table data by shifting column positions without altering the underlying row content.

## Inputs

- **Table Data** (textarea): Enter CSV or table data to reorder columns...
- **Delimiter** (select)
- **Column Order Mode** (select)
- **Custom Column Order** (textarea): Enter new column order (comma-separated): column3,column1,column2 or by numbers: 3,1,2
- **First Row is Header** (checkbox)
- **Include Preview (First 5 Rows)** (checkbox)
- **Output Format** (select)

## When to use

- Standardizing datasets from different sources that have mismatched column orders.
- Preparing data for specific software imports that require a strict column sequence.
- Cleaning up messy CSV files by grouping related data points together for better readability.

## How it works

- Paste your CSV or table data into the input area.
- Select your preferred ordering mode, such as alphabetical sorting or a custom sequence.
- Define your custom column order using names or index numbers if needed.
- Choose your desired output format, such as CSV, JSON, or Markdown, and generate the result.

## Use cases

- Reorganizing database exports to match a specific API schema.
- Formatting raw CSV data into a clean Markdown table for documentation.
- Alphabetizing a large number of columns to make manual data entry easier.

## Frequently asked questions

### Does this tool change my data rows?

No, the tool only changes the horizontal order of the columns; the row data remains intact and associated with the correct headers.

### Can I sort columns alphabetically?

Yes, you can select 'Sort Columns Ascending' or 'Descending' in the Column Order Mode settings.

### What formats can I export the reordered data into?

You can export your data as CSV, JSON, Markdown, or HTML tables.

### How do I specify a custom order?

Select 'Custom Order' and enter your column names or index numbers separated by commas in the Custom Column Order field.

### Does it support files with headers?

Yes, ensure the 'First Row is Header' checkbox is selected to maintain your column labels during the reordering process.

## Related tools

- [Column Remover](https://elysiatools.com/en/tools/column-remover): Remove specified columns from table data
- [CSV Column Reorderer](https://elysiatools.com/en/tools/csv-column-reorder): Reorder, remove, and rearrange CSV columns with customizable column positions
- [Column Calculator](https://elysiatools.com/en/tools/column-calculator): Perform calculations on columns and add new rows
- [Data Append Merger](https://elysiatools.com/en/tools/data-append-merger): Vertically append and merge multiple data tables with intelligent column matching
- [Row Calculator](https://elysiatools.com/en/tools/row-calculator): Perform calculations on each row and add new columns
- [CSV Column Selector](https://elysiatools.com/en/tools/csv-column-selector): Select specific columns from CSV data by column names or indices. Perfect for extracting relevant data from large CSV files with many columns.
- [Data Deduplicator](https://elysiatools.com/en/tools/data-deduplicator): Remove duplicate rows from CSV files based on multiple column combinations. Perfect for cleaning customer lists, survey responses, and database exports. Features: - Multi-column combination deduplication - Fuzzy matching for similar records - Custom deduplication strategies (keep first, last, or most complete record) - Case-insensitive matching option - Whitespace trimming - Detailed duplicate statistics Common Use Cases: - Remove duplicate customer records - Clean email marketing lists - Eliminate redundant survey responses - Prepare data for analysis
- [Duplicate Column Remover](https://elysiatools.com/en/tools/duplicate-column-remover): Remove duplicate columns from CSV data with flexible detection strategies. Perfect for cleaning datasets, removing redundant information, and optimizing data structure. Features: - Detect columns with identical headers - Find columns with identical data content - Support for case-sensitive/insensitive matching - Multiple removal strategies available - Preserve data integrity - Support for large datasets - Fast and efficient processing Common Use Cases: - Clean up merged datasets - Remove redundant data columns - Optimize data for analysis - Prepare data for machine learning - Reduce file size and complexity - Standardize data format

## Samples

- [CSV Samples](https://elysiatools.com/en/samples/csv-samples): Sample CSV files with various data types, sizes, and complexity levels
- [Python Samples](https://elysiatools.com/en/samples/python): Essential Python code examples and Hello World demonstrations
- [Windows String Processing - C# Samples](https://elysiatools.com/en/samples/windows-string-processing-csharp): Comprehensive C# string processing examples for Windows platform including string manipulation, splitting, joining, regex operations, and text analysis
- [MySQL Database Samples](https://elysiatools.com/en/samples/mysql-database-samples): Sample MySQL database scripts with various complexity levels from simple tables to enterprise ERP systems