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

# Bulk Import Data Using a CSV

Alternatively, you can easily use an existing CSV that you have locally to populate the table in Registry. To do so, you can click on the “Import” button and choose “Import CSV”.

<img src="https://mintcdn.com/latchbio/LdV6VvwVO8ylN7Bn/images/bulk-import-1.png?fit=max&auto=format&n=LdV6VvwVO8ylN7Bn&q=85&s=6dc85e5e20ff34e3d9f0e9bbf370fc1f" alt="" width="840" height="140" data-path="images/bulk-import-1.png" />

As an exercise, we will use the [metadata sheet](https://docs.google.com/spreadsheets/d/1i3HdGhWC4P7RYlmswxnE6LjcfAroSx61PQR20q6mCZM/edit?usp=sharing) from Yost et. al (2019) here.

<Steps>
  <Step title="Download the Google Sheet to your local computer.">
    <Note>
      Note that Registry CSV import only supports **.csv** at the moment. If you
      have an Excel file (.xls, .xlsx) or text file (.txt), please make sure to save
      them as a CSV first.
    </Note>
  </Step>

  <Step title="Once you have clicked “Import CSV”, a new modal will pop up with a view of your Latch Data.">
    Select “Upload Files” to upload the metadata sheet downloaded in the previous step.

    <img src="https://mintcdn.com/latchbio/LdV6VvwVO8ylN7Bn/images/bulk-import-2.png?fit=max&auto=format&n=LdV6VvwVO8ylN7Bn&q=85&s=2ad59f2e83ae961eacd7bd940d38716b" alt="" width="832" height="456" data-path="images/bulk-import-2.png" />
  </Step>

  <Step title="Once the file finishes uploading, choose the CSV and click “Select”.">
    <img src="https://mintcdn.com/latchbio/LdV6VvwVO8ylN7Bn/images/bulk-import-3.png?fit=max&auto=format&n=LdV6VvwVO8ylN7Bn&q=85&s=d1bb3bd30d3fa69d1c413d25b4fff527" alt="" width="834" height="446" data-path="images/bulk-import-3.png" />
  </Step>

  <Step title="Once you choose the CSV file, a pop-up window will show up, which lets you map the columns from the CSV to the registry table columns.">
    <img src="https://mintcdn.com/latchbio/LdV6VvwVO8ylN7Bn/images/bulk-import-4.png?fit=max&auto=format&n=LdV6VvwVO8ylN7Bn&q=85&s=16d31d4707ec0aaaa90cdb3203515ac9" alt="" width="836" height="450" data-path="images/bulk-import-4.png" />
  </Step>

  <Step title="You can choose to create new columns for Registry or select existing columns to map the data to.">
    New tables only have one default existing column, which is “Name”. Let’s change the mapped column for the “Sample Name” (in the original CSV) to “Name” (in the Registry).

    <img src="https://mintcdn.com/latchbio/LdV6VvwVO8ylN7Bn/images/bulk-import-5.png?fit=max&auto=format&n=LdV6VvwVO8ylN7Bn&q=85&s=62ad6d1fce941507b0c1df373316e391" alt="" width="836" height="232" data-path="images/bulk-import-5.png" />
  </Step>

  <Step title="You can also change the types of the column to be imported.">
    As an exercise, we can change the type of the columns “organism\_name” and “Strandedness” to “Select”.

    Once the import finishes, you will see your Registry table populated like so.

    <Tip>
      **Pro-tip:** If you want to import a CSV with new columns and one of the
      columns contains values that match record names in the Registry, the columns
      and their values will be linked with those records automatically.
    </Tip>

    <img src="https://mintcdn.com/latchbio/LdV6VvwVO8ylN7Bn/images/bulk-import-6.png?fit=max&auto=format&n=LdV6VvwVO8ylN7Bn&q=85&s=a3de804ec9b2e53d245291658c739779" alt="" width="832" height="458" data-path="images/bulk-import-6.png" />
  </Step>
</Steps>
