# Parsing a CSV file

CSV files are a popular data source for ETL applications since numerous database systems import and export data in this format.

To parse a CSV file, you can follow these steps:

1. From the home page, click on Soma. This will lead you to the Soma Connection page.
2. On the Soma Connection page, select the CSV file you want to upload. Your CSV file will appear on the Data page within the Soma workspace.
3. Now, you need to parse the raw CSV data to view it in a spreadsheet format that segregates it into rows and columns. To do this, click on the dropdown menu next to the 'body' column.
4. Choose 'Parse > CSV' from the menu.
5. Select the type of delimiter in the file, and then choose 'Set first row as header'. The dataset will now appear in a spreadsheet format. Soma will add the 'parse-as-csv' directive to the recipe.
6. If you don't need the 'body' column for data cleansing and analysis, you can delete it. From the dropdown menu, choose 'Delete column'. Soma will add the 'drop' directive to the recipe.

You are now ready to parse your dataset!

***


---

# 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.turium.ai/home/algoreus/turium-connector-documentation/turium-fabriq-overview/how-to-guides/soma-transformation-user-guide/parsing-a-csv-file.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.