> ## Documentation Index
> Fetch the complete documentation index at: https://docs.brewit.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# CSV

<Card title="Strong Security" icon="shield-check" iconType="sharp-solid" color="#49DE80">
  CSV files are securely stored in the **Brewit-hosted Postgres database**. Each
  file will be stored as a table in the database.
</Card>

## Import your CSV file

<Steps>
  <Step title="Create">
    Choose **CSV** or **Brewit Workbook**
    [here](https://app.brewit.ai/resources/new)
  </Step>

  <Step title="Configure">
    Edit the table name. Default: the file name

    <Warning>
      Only letters, numbers, and underscores, must start with a letter, max
      length 63, all lowercase
    </Warning>
  </Step>

  <Step title="Check Preview">
    Click **Test Connection** button to verify that Brewit can successfully
    connect to BigQuery. If the test fails, check the data source settings and
    try again.
  </Step>

  <Step title="Save the resource">
    Click **Save** button to complete the setup. Now you can start chatting with
    Brewit's BI agent to analyze your data.
  </Step>
</Steps>

## Data Formatting Guidelines

### ❌ Improper data formatting

Composite spreadsheets or irregularly formatted data may not be able to be analyzed or transformed by Brewit. Below are several common issues to avoid:

* **Multiple sections**. Your spreadsheet cannot have multiple sections.
* **Multiple tables**. Similar to the point above, there should not be multiple tables in your uploaded sheet.
* **Empty rows**. Make sure there are no empty rows (or columns).

<img src="https://mintcdn.com/brewit-84/pyjAYulKSUrvhjf5/images/screenshots/improper-data-formatting.webp?fit=max&auto=format&n=pyjAYulKSUrvhjf5&q=85&s=9c81c05ef3114bcf8726c282c55fb98c" width="979" height="859" data-path="images/screenshots/improper-data-formatting.webp" />

### ✅ Proper data formatting

Well-cleaned and structured data enables Brewit to perform accurate and error-free data analysis and visualization. Below are best practices to follow:

* **Column headers**. Descriptive column headers must be in the first row.
* **Tabulation**. Your data should be in the form of rows of records below the headers.
* **Universality**. Plain, generally understandable language for column names is recommended rather than industry- or company-specific jargon.

<img src="https://mintcdn.com/brewit-84/pyjAYulKSUrvhjf5/images/screenshots/proper-data-formatting.webp?fit=max&auto=format&n=pyjAYulKSUrvhjf5&q=85&s=e926b21835d9516f463634f862b5081e" width="820" height="343" data-path="images/screenshots/proper-data-formatting.webp" />