> For the complete documentation index, see [llms.txt](https://help.csvbox.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.csvbox.io/dashboard-settings/ai-bulk-transforms.md).

# AI Bulk Transforms

Let users modify column data using natural language prompts — directly in the importer.

{% hint style="info" %}
Currently in Beta
{% endhint %}

### How to Enable AI Transformations

To enable this feature for a sheet:

1. Go to your **Sheet Settings**
2. Click on the **Import Steps** tab
3. Navigate to the **Verify Data** tab
4. Set **"Enable AI Transformations?"** to **Yes**
5. Save your settings

Once enabled, a new **"Bulk Transform"** option will appear in the Verify step of the import flow for each column.

<figure><img src="https://1907234374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MN8YRAnfnCaoVVZflQz%2Fuploads%2F9Ki7BIQyjyQuyEeIsKQK%2Fsleekshot.png?alt=media&amp;token=c50e3534-63e0-4143-98f0-f9811fbcae65" alt=""><figcaption><p>Bulk Transform Button</p></figcaption></figure>

<figure><img src="https://1907234374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MN8YRAnfnCaoVVZflQz%2Fuploads%2FRBi0vqCxvVXd8ECZni69%2Fsleekshot.png?alt=media&amp;token=6076648c-b9b6-4ada-9f15-94daf75b0746" alt=""><figcaption><p>AI Bulk Transform Screen</p></figcaption></figure>

### What Can It Do?

The users can use this tool to clean, format, and enrich the data effortlessly using plain language. It  can:

* Capitalize or lowercase text in `'product_name'`
* Add a 10% markup to values in `'price'`
* Translate `'description'` to Spanish
* Format `'order_date'` to `YYYY-MM-DD`
* Extract the domain name from `'email'`
* Tag rows as `'Yes'` in `'priority'` if `'notes'` mention "urgent"

These are just a few examples — the feature is flexible and can handle a wide range of transformations across different languages.

### Key Features

* Transform entire columns using simple AI prompts.
* User data never leaves the browser — values are *not* sent to any external AI models.
* Fix validation issues quickly by modifying problematic fields in bulk.
* Users can modify or delete rows, but cannot add new rows using AI.
* Supports prompts in all languages available in the importer.
* Users can preview the data before applying changes.