There are a few ways you can import your data into bit.io.

On the Web

There are multiple ways to upload data though the web UI. You can:

Drag and drop a file to the "quickly add data" box on your dashboard.

Click the "Upload Data" button at the top of your Dashboard page or any database page.

You can create a new database for the file, add a new table to an existing database, or append the data to an existing table (if the schema matches)

Note: if you're not logged in, you may only have one trial database.

Example datasets

If you'd like to try uploading some data but don't have any handy, try using one of our example datasets. Here are a few links in different formats to a dataset that contains sales data for over 16,000 video games:

Through a Client

Once you connect a database client to bit.io, you can upload data by making a SQL "INSERT INTO" or "COPY FROM" query.

Using the API

curl --request POST \
     --url https://api.bit.io/v2beta/db/<db_name>/import/ \
     --header "Authorization: Bearer ${API_KEY}" \
     --form "table_name=<table_name>" \
     --form "[email protected]<file_path>"

See the API reference here: /v2beta/db/{username}/{db_name}/import/