# CSV

Nimbalyst includes a built-in spreadsheet editor for CSV and TSV files. Open any `.csv` or `.tsv` file and it automatically displays in a familiar spreadsheet interface.

<figure><img src="/files/nn2bskasQ7rf3Y6R9O6u" alt=""><figcaption></figcaption></figure>

### CSV Spreadsheet Editor

The editor works like Excel or Google Sheets. You can:<br>

* Edit cells, rows, and columns manually
* Cut, copy, and paste

Click **View Source** in the toolbar to toggle between the spreadsheet view and raw CSV text.

### Using Coding Agents with CSV Files

Your coding agent can read and modify your CSV files directly. This is powerful for data tasks that would be tedious to do manually.

**Data Cleaning**

* "Remove all duplicate rows from data.csv"
* "Fix the date format in the 'created\_at' column to YYYY-MM-DD"
* "Trim whitespace from all cells in customers.csv"

**Data Transformation**

* "Add a new column that calculates the total from price and quantity"
* "Split the 'full\_name' column into 'first\_name' and 'last\_name'"
* "Convert all country codes to full country names"

**Analysis & Filtering**

* "Remove all rows where status is 'cancelled'"
* "Sort by revenue descending and keep only the top 100"
* "Find and flag any rows with missing email addresses"

**Bulk Operations**

* "Add 'USD' prefix to all values in the currency column"
* "Replace all instances of 'N/A' with empty cells"
* "Normalize phone numbers to +1-XXX-XXX-XXXX format"

**Generating Data**

* "Create a CSV with 50 sample customer records for testing"
* "Add a header row with appropriate column names"

#### How It Works

When you ask your coding agent to modify a CSV file, it reads the file, makes the changes programmatically, and writes the updated content back. The spreadsheet editor will automatically refresh to show your changes.

#### AI Changes as Red / Green Diff

* Additions will be shown in green
* Deletions will be shown in red


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.nimbalyst.com/visual-editors-powered-by-ai/csv.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.