I’m just playing with using a Softr database table instead of an existing Airtable (table). I have created a table using a CSV import, but I’d now like to add records from a 2nd CSV.
Is this possible at the moment? I’d do it with an extension in Airtable. Could I possibly import into a new table and then copy the records across?
1 Like
Hi @Bitstreams. My understanding is this feature is not currently available, but is on the roadmap. It’s a feature I’m waiting for myself.
1 Like
@artur do you know if this will be rolled out soon? I have an existing table in SD which I’d like to import additional records to (from CSV or Excel) but can’t see anyway of doing this?
Import from Airtable to Softr Databases is available. Just tried it. A blessing!
Unfortunately still no way to import to existing tables
1 Like
Work in progress, gang! Hang tight 
1 Like
I have an immediate need to update some data tables. Copy and paste seems like the only option, but there seems to be a limit of what Softr can handle. Do you know what that limit is? If I know what it is I can plan accordingly, chunking my data to get everything in the database.
You can also explore using some automations to transfer this data over into an existing table with our API + zapier / Make connectors.
Following up on the Make suggestion. I got it to work. The challenge is the volume of data I need to add to an existing Softr database table and then link to the related record to another table. Our first effort was act of all of our data - 140,000 records to import and link them up to the core company table. It worked but we had to stop it because of the cost and the inefficiency.
So yes, it is a solution - in my opinion mainly for smaller data sets.
Ah, yes. Thanks for reporting back!
CSV import into existing table is something I can do when back from vacation should not take too long I think… and the linking can be done by changing field type we link automatically
4 Likes
@artur Any update on the timing of Softr DB CSV Import. I’m working on a client project and we are getting to the point where we’ll need to input data. They have thousands of records. I’m hoping I won’t have to tell my client they’ll have to manually enter them.
We’re still working on this. Some work arounds:
-
Import to another table in SD, and then copy and paste into the right table? (Copy now includes “extend” table option!
-
Create an automation in Zapier / Make / N8n to transfer the data over via API?
Hey @Jjenglert - Thanks for the recommendations. I’ll try the copy and paste approach and see how I make out. Hopefully, native CSV Import is still on the way.
1 Like
@TobyMacLeod what’s deadline 
just need to see how to make it work for you…
Hi @artur - We’re aiming to launch my clients app the end of January. But I’ll need to have my clients data imported well before then to test everything and make sure it’s working (we have to integrate with third-party platforms such as Thinkific). I’ll be importing limited data this week and I’m aiming to import all data the first week or two of November. Thanks!
Someone mentioned zapier and I would mention n8n which can be triggered during the uploading if the file (you can make a table called import and it will show the status as well)
Then just have n8n listen for a new row and have it iterate over the csv and insert the data as needed. It is a nice combo for many of these type of more complex needs imo.
@Jjenglert @artur Importing a CSV file to a new table and then copying and pasting the data into another table does not work. Got a message that said I can only copy 1,000 records at a time. Tried copying fewer than 1,000 records and ended up with blank records being added. Tried ensuring all table fields match, but that’s not possible as I would have to recreate related fields, which would create duplicate fields in the related tables. Any suggestions? I really need to start getting some client data imported so I can start testing as we continue to develop. API is not an option as we are coming from a proprietary system.
I will get CSV import into existing table early next week
3 Likes
@artur Thank you!!! I’ll keep my eyes open for it.