Softr

Collect spreadsheets from users and push clean data to Softr database.

CSVBox allows you to send imported spreadsheet data directly into Softr Databases, enabling no-code workflows such as internal tools, portals, directories, and dashboards powered by Softr.

With this destination, every successful CSV import will insert rows into a selected Softr table.

---

When to use Softr as a Destination

Use the Softr destination when you want to:

• Import CSV / Excel data into Softr databases

• Power Softr apps with bulk uploads

• Allow non-technical users to upload structured data

• Replace manual Softr data entry with a guided importer

---

Configure Softr Destination in CSVBox

Follow the steps below to configure Softr as your data destination.

Step 1: Select Softr as Destination

1. Go to Sheet Settings → Destination

2. Click Select Destination

3. Choose Softr from the list

---

Step 2: Enter Softr Credentials

Fill in the following required fields:

API Key

• Your Softr API Key

• Used to authenticate requests from CSVBox to Softr

Database ID

• The ID of the Softr database where data should be inserted

• This identifies the parent database inside Softr

Table ID

• The specific table inside the database that will receive the data

• Each imported row becomes a new record in this table

💡 How to get Database ID and Table ID from Softr

1. log in to Softr

2. Go to Data → Databases

3. Click on the database you want

4. Click on the table inside that database

5. Look at the browser URL

You’ll see something like:

https://studio.softr.io/databases/ecc84771-ca85-48f2-abc3?table=ajZqlE5O9KOy1

Extract the IDs:

Database ID: ecc84771-ca85-48f2-abc3

Table ID: ajZqlE5O9KOy1

---

Step 3: Test Connection

Click Test Connection to verify:

• API key validity

• Access to the specified database

• Access to the selected table

A successful test confirms CSVBox can write data to Softr.

---

Step 4: Map Columns

Click Map Columns to:

• Map CSV / Excel columns to Softr table fields

• Ensure field types are compatible

• Control which columns are sent to Softr

Column mapping is mandatory before running an import.

---

Step 5: Save Configuration

Click Save to persist the Softr destination settings.

Your importer is now ready to send data directly into Softr.

---

How Data Is Sent to Softr

• Each successfully imported row becomes one record in the selected Softr table

• Data is sent after validation and after transforms

---

Troubleshooting

Connection test fails

• Verify API key permissions

• Double-check Database ID and Table ID

• Ensure the table exists and is accessible

Columns not appearing

• Revisit Map Columns

• Ensure Softr field names and types match incoming data

---

Notes & Limitations

• Softr destination currently supports row inserts

• Large imports may take longer depending on Softr API limits