A Comma Separated Values (CSV) file allows you to exchange data between different applications. A common use case is turning an Excel Document into a CSV, and then uploading it into a database.
Arctype can be used to import data from a CSV file into your database. In this document, we will show you how to do just that. We will also provide some tips on how to choose the right file and define the correct rows and columns. Finally, we will show you how to view your imported data in Arctype.
How to import a CSV file into your database
Importing data from a CSV into Arctype involves three steps. First, you’ll choose the file you want to import. Next, you’ll ensure that the rows and columns are configured correctly. Lastly, you’ll import the file. Let’s look at each step in more detail.
Choose the file you want to import
First, we need to tell Arctype which CSV file we’d like to import. To do this, navigate to the “Tables” view and click on the three dots next to the table search field, as shown below. Then, select “Import CSV.”
Choose the "Import CSV to table" option
Next, we can use the file selection window that appears to select our CSV file for import. Select your file and choose “Open.”
Selecting the file we want.
Define the rows and columns
Once you select the file you want to import, Arctype will display the first ten rows of your data as a preview. Use this as an opportunity to make sure you have the correct file and that everything looks as expected.
Viewing the first 10 rows
If everything looks correct, click “Accept.” Arctype will then take you to a configuration screen, as shown below.
Configure the schema
This screen allows you to determine where you want the data to be stored (in a new table or existing table) and to select the schema you’d like to use. You can also name the table and set the column names, types, and default values. Additionally, the importer allows you to add columns or remove them. Configure these settings as you wish.
Import your file
When everything looks good, click “Import CSV.” You will see a success message in the bottom right of your screen when the import succeeds.
Important note: You may need to refresh your table using the “Refresh” icon in the top right corner once your import is complete in order to view your data.
Viewing your data in Arctype
Now that you have your CSV data imported, you can use Arctype to interact with it. For example, Arctype allows you to directly edit cells in your tables just like you can in tools like Excel or Google Sheets. Furthermore, Archetype has powerful sharing and charting capabilities. You can follow the documentation for creating and running queries, filtering and sorting tables, or creating dashboards to learn more.