- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 03, 2015 09:20 AM
Hello Team,
Is there any quick way to import mass data into an EXISTING TABLE? Importing a CSV file will generate a table, not append to the existing one. Copy and paste from excel or google sheet does not seem to work.
Karl
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 15, 2018 07:07 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 03, 2015 10:05 AM
I apologize! The copy & paste function seems to work.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 05, 2015 08:28 AM
Not only does the cop & paste function work for data, but you can also copy file attachments from one table to another, which I think is pretty cool.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 05, 2015 07:54 PM
Thanks Markus! I will try it.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 05, 2015 03:03 PM
Is there a way to mass import photos from, say, an old Bento database?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 02, 2016 05:17 AM
Hi Karl, I had the same question. So, by “copy and paste” function, do you mean that I’d do the following:
- Create a .csv for the new set of records that I want to add to my table.
- Select and copy all the rows of data in the .csv.
- Paste that into the Main View of the table I want to add new records to (and this presumes that I haven’t changed the Main View in any way since my original import, such as reordering, adding, or deleting columns.)
Thanks! I’m brand new to Airtable as of last night! Feeling my way around, and so far, I LOVE it!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 02, 2016 06:24 AM
I’ve wondered this as well. Copy and paste is a workable solution but there are a bunch of other reasons why Airtable needs the ability to import from a spreadsheet into an existing table. This additional import functionality would need to be able to set up data keys, driving an update for any existing records with the same key and creating new records for ones that don’t already exist in the table.
Airtable would be able to address more of my clients’ CRM use cases if it had this functionality. Lead management is an example. Over time a company gets batches of leads in a spreadsheet that they need to be able to import into a Leads app. Duplication detection and record updates are key features that ensure the lead qualification process ends up being as efficient as possible.
I’m going to add this into the feature request forum.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 02, 2016 08:37 PM
Thank you, Bill. Can I find your request and vote for it or support it in any other way there?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 03, 2016 08:33 AM
Here’s the link Import spreadsheet into existing table
I don’t see a voting option but you can “Like” it.
-Bill
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 05, 2016 07:44 AM
Thank you, Bill. Just found it and liked it.
Lisa