> For the complete documentation index, see [llms.txt](https://docs.exploratory.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.exploratory.io/data-wrangling/clean_names.md).

# Clean Column Names

Clean up all column names on the data frame.

## How to Access This Feature

### From + (plus) Button

![](/files/-M4oN7qxadXr1X3x0lgk)

* Click "+" button and select "Others..." -> "Clean Up All Column Names".

## Clean Column Names

![](/files/-M4oN7qzRPIg_cnAn7jT)

1. Case - Case of the Resulting Column Names. Supported options are:

* parsed
* snake\_case
* lowerCamel
* UpperCamel
* ALL\_CAPS
* lowerUpper
* UPPERlower
* multibyte

### parsed

A column name is created with multiple words that are joined together with an underscore (\_) as the separator and current case is preserved.

For example, "Product Name" becomes "Product\_Name".

### snake\_case

A column name is created with multiple words that are joined together with an underscore (\_) as the separator and each word is lowercased.

For example, "Product Name" becomes "product\_name".

### lowerCamel

A column name is created with multiple words that are joined together as a single word with the first letter of each word (except the first one) uppercased.

For example, "Product Name" becomes "productName".

### UpperCamel

A column name is created with multiple words that are joined together as a single word with the first letter of each word uppercased.

For example, "Product Name" becomes "ProductName".

### ALL\_CAPS

A column name is created with multiple words that are joined together with an underscore (\_) as the separator and each word is uppercased.

For example, "Product Name" becomes "PRODUCT\_NAME".

### lowerUpper

A column name is created with multiple words that are joined together as a single word with each word alternating with lowercased and uppercased.

For example, "Product Detail Description" becomes "productDETAILdescription".

### UPPERlower

A column name is created with multiple words that are joined together as a single word with each word alternating with uppercased and lowercased.

For example, "Product Detail Description" becomes "PRODUCTdetailDESCRIPTION".

### multibyte

Same as parsed. If your column name contains multibyte characters and separated unexpected way with "parsed" option, try this multibyte option.

For example, "製品 名称" becomes "製品\_名称".