# Step 2: Load company profile data

Download [companylist.csv](https://s3.amazonaws.com/memsql-tutorial-files/companylist.csv) onto your local machine and then load it into the `company` table by either using a MySQL client (such as Sequel Pro, MySQLWorkbench) or by using the [LOAD DATA](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/load-data.md) command.

If you are using a MySQL client, open your MySQL client and navigate to the menu item for importing data from a file. Import companylist.csv into the `company` table.

If you are using a terminal, run the `LOAD DATA` command to load the data into the `company` table.

```sql
LOAD DATA INFILE '/tmp/companylist.csv'
INTO TABLE company
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

```

***

Modified at: April 29, 2025

Source: [/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-2-load-company-profile-data/](https://docs.singlestore.com/db/v9.1/query-data/advanced-query-topics/example-building-a-sample-stock-trade-database/step-2-load-company-profile-data/)

(An index of the documentation is available at /llms.txt)