> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wisdom.ai/llms.txt
> Use this file to discover all available pages before exploring further.
# Work with CSV Files
With WisdomAI, you can integrate and analyze data stored in **CSV**, **TSV**, or **Excel** files. Depending on your goals and permissions, there are three distinct ways to work with these files:
1. [Add Data to a Domain (Admins)](#1-add-data-to-a-domain-admins)
2. [Create a Private Domain (Admins)](#2-create-a-private-domain-admins)
3. [Attach CSV as a Chat File (Admins/Explorers)](#3-attach-csv-as-a-chat-file-admins%2Fexplorers)
## 1. Add data to a Domain (Admins)
Admins can add new CSV files as tables or replace existing tables within a shared domain. This change affects the domain-level schema, meaning every Explorer assigned to that domain can query this data. Use this option to make a dataset available to your entire team.
Follow the steps below to add data to a domain:
1. Navigate to **Domains** and select your target domain.
2. Click the **Data Sources** tab.
3. Click **Add Table** > **from CSV file**.
4. The domain will come set by default, while you will be able to select the **Table Operation**:
* **Add as a new CSV Table**: Creates a fresh table within the selected domain.
* **Replace an existing CSV Table**: Updates the data of a specific table while preserving settings.
5. If replacing data, select the specific table to be replaced from the **Select table to replace** dropdown.
6. Drag and drop your file into the upload area or click to browse.
7. Click **Continue**.
8. **Configure Columns**: Review the detected column types (e.g., String, Integer). You can unmark the checkboxes to exclude specific columns from the upload.
9. Click **Preview**.
10. Ensure the data in the preview grid maps correctly. Click **Create table** (or **Replace table** if updating an existing one).
**Data Replacement Behavior**
When you replace an existing CSV table, the system updates only the raw data. All existing column descriptions, settings, and domain configurations remain intact, only the table data itself is replaced.
## 2. Create a private Domain (Admins)
Admins can create their own domains by uploading a file. These domains are private by default, and no other user can see them unless the creator explicitly shares them. This method is great for one-off analysis or testing a dataset before sharing it.
Follow the steps below to create a domain from the domain switcher:
1. Navigate to the **homepage**.
2. Click the **domain switcher**.
3. Select the **Upload CSV file...** option.
4. In the **Upload CSV or TSV file** modal that opens, leave the default option **+ Create a New Domain with this CSV** selected.
5. Upload your files and click **Continue**.
6. The **Preview CSV file** modal window opens. Click **Configure columns** to continue.
7. The **Configure CSV file** modal opens, displaying a preview of all columns detected in your CSV file.
By default, basic configuration options are shown. To access additional controls, switch the **Show advanced options** toggle **ON** (top-right corner of the modal).
Check the expandable section below to review all available advanced options and their descriptions.
Advanced options let you control identifiers, ordering, allowed values, and lookup behavior used during analysis.
* **Primary key**: Marks a column as uniquely identifying each row.
* **User identifier**: Identifies columns that represent individual users or customers.
* **Allowed values**: Restricts the column to a defined set of values.
* **Order allowed values**: Defines a logical order for categorical values.
* **Default order**: Sets the default sort order for the column.
* **Enable lookups**: Allows the column to be used for grouping, filtering, and comparisons.
Review and adjust the column settings as needed.
8. When you’re done configuring the file, click **Start asking questions**. A chat opens where you can immediately begin querying your data.
## 3. Attach CSV as a chat file (Admins/Explorers)
You can upload a file directly into a chat session. While the chat still uses your active domain for general context, the AI will prioritize the data in your uploaded file for that specific conversation. This upload method allows you to ask quick questions about a specific file without creating a new domain.
Follow the steps below to attach a file to a chat:
1. Open any Chat.
2. Click the **Attachment (paperclip)** icon in the message bar.
3. Upload your file.
You can add multiple files and compare them.
4. Ask questions immediately (e.g., "Summarize the trends in this file").
See [Supported File Types](/improve-wisdom-ai-responses/attach-files-to-chat#supported-file-types) for a complete list.
## Next steps
Define relationships and context in your data to enable more powerful analysis.
Understand the methods for verifying the correctness and reliability of generated answers.
Improve analysis by providing custom business definitions, synonyms, and other contextual information.