# XLSX Column Mapper Rename, reorder, and drop Excel columns with alias matching and case/whitespace normalization > Canonical page: https://elysiatools.com/en/tools/xlsx-column-mapper - **Category:** Format Conversion - **Keywords:** xlsx, excel, column, rename, reorder, delete, alias, mapping ## Overview Map table columns by rules. - Rename columns by mapping or alias dictionary - Reorder columns in a target sequence - Remove columns safely - Match headers with optional case-insensitive and space-insensitive normalization ## Inputs - **Excel File** (file) - **Sheet Name** (text): Sheet1 - **Header Row** (number) - **Rename Map JSON** (textarea): {"First Name":"first_name","Last Name":"last_name"} - **Alias Map JSON** (textarea): {"first_name":\["First Name","first name","FIRST_NAME"\]} - **Reorder Columns** (text): id,first_name,last_name,email - **Remove Columns** (text): notes,temp_col - **Ignore Header Case** (checkbox) - **Ignore Header Spaces** (checkbox) - **Keep Unmapped Columns** (checkbox) ## When to use - Standardizing inconsistent column headers across multiple Excel files from different sources. - Preparing raw data for database imports by renaming and reordering columns to match specific schemas. - Removing sensitive or unnecessary columns from large spreadsheets to streamline data analysis. ## How it works - Upload your Excel file and specify the target sheet and header row index. - Define your renaming or alias rules using JSON to map existing headers to your desired output names. - Configure the column order and specify any columns you wish to remove from the final file. - Apply normalization settings to handle case sensitivity and whitespace variations in your headers automatically. ## Use cases - Merging disparate sales reports into a single, unified format for business intelligence dashboards. - Cleaning exported CRM data by mapping non-standard field names to internal system requirements. - Removing temporary calculation columns or PII data from spreadsheets before sharing them with external stakeholders. ## Frequently asked questions ### Can I rename multiple columns at once? Yes, you can provide a JSON object in the Rename Map field to define multiple column renames simultaneously. ### Does the tool support case-insensitive header matching? Yes, by enabling 'Ignore Header Case', the tool will match headers regardless of capitalization. ### What happens to columns that are not included in my mapping rules? If 'Keep Unmapped Columns' is enabled, they will remain in the file; otherwise, they will be excluded. ### Can I reorder columns using this tool? Yes, use the 'Reorder Columns' field to list your desired column sequence separated by commas. ### Is there a limit to the file size I can upload? The tool supports files up to 100MB. ## Related tools - [XLSX Formula Injector](https://elysiatools.com/en/tools/xlsx-formula-injector): Fill formulas down worksheet columns and optionally lock formula cells for protected, template-friendly Excel workbooks - [XLSX Freeze Pane Manager](https://elysiatools.com/en/tools/xlsx-freeze-pane-manager): Freeze top rows/left columns automatically and apply row or column outline groups for easier spreadsheet reading - [XLSX JSON Transformer](https://elysiatools.com/en/tools/xlsx-json-transformer): Bidirectional conversion between JSON arrays and Excel sheets, with nested object flattening and restoration - [XLSX Template Filler](https://elysiatools.com/en/tools/xlsx-template-filler): Fill existing styled/formula Excel templates by replacing {{variable}} placeholders only - [XLSX Conditional Formatting Rule](https://elysiatools.com/en/tools/xlsx-conditional-formatting-rule): Batch-apply conditional formatting rules such as threshold highlights, data bars, and color scales to Excel worksheets - [XLSX Data Validation Dropdown](https://elysiatools.com/en/tools/xlsx-data-validation-dropdown): Batch-create dropdowns, dependent cascading dropdowns, and input prompts in Excel workbooks using data validation rules - [XLSX Named Range Injector](https://elysiatools.com/en/tools/xlsx-named-range-injector): Create or update workbook-level named ranges so formulas, validations, and reusable templates can reference stable Excel names - [XLSX Print Setup Pack](https://elysiatools.com/en/tools/xlsx-print-setup-pack): Apply paper, margins, scaling, repeating titles, and header/footer print settings to Excel workbooks in one pass ## Samples - [XLSX Samples](https://elysiatools.com/en/samples/xlsx-samples): Sample XLSX spreadsheets for worksheet parsing and data extraction testing - [XLS Samples](https://elysiatools.com/en/samples/xls-samples): Sample legacy Excel (XLS) files for binary spreadsheet parsing and import tests - [Android Serialization Java Samples](https://elysiatools.com/en/samples/android-serialization-java): Android Java serialization examples including JSON serialization, deserialization, and XML parsing - [Android Serialization Kotlin Samples](https://elysiatools.com/en/samples/android-serialization-kotlin): Android Kotlin serialization examples including JSON serialization, deserialization, and XML parsing ## Related content - [Single-Workbook XLSX Cleaning and Field Mapping](https://elysiatools.com/en/hubs/xlsx-single-workbook-cleaning-and-mapping): A focused workflow for one workbook or one worksheet: select a range, map headers, convert the cleaned table to JSON, and review source, type, null, and duplicate behavior without expanding into batch ingestion or warehouse delivery. - [XLSX ETL Ingestion and Warehouse Handoff](https://elysiatools.com/en/hubs/xlsx-etl-ingestion-workflows): Turn mixed workbook and CSV sources into traceable, schema-aware outputs for SQL loading, Parquet pipelines, and object-storage batch handoff.