Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 17, 2024 04:39 AM
Hello everyone!
Good day! I have a quick question.
Is there a way to upload a CSV or XLSX file in Airtable?
We want to be able to streamline sales data in Airtable. We would download the file from Bol, and upload it in Airtable, so it updates automatically the right values. Any help is appreciated!
Thank you!
-Aisha
Mar 17, 2024 05:30 AM - edited Mar 17, 2024 05:31 AM
Yes, Airtable offers you the ability to manually upload/import CSV files or manually upload/import Excel files into your existing bases and tables.
The most powerful way to do this is by using CSV files, and using Airtable’s CSV Import extension.
However, are you asking if you can automate the process of uploading CSV files into Airtable?
If you want to automate the process of importing CSV files into Airtable, you would need to turn to Make’s Airtable automations and Make’s CSV automations.
I give a full step-by-step training on how to automate the process of automatically importing CSV files into Airtable on this Airtable podcast episode: Automate the process of importing CSV files into Airtable.
If you’ve never used Make’s automations & integrations before, I offer even more training resources in this thread.
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld
Mar 17, 2024 08:27 AM
Yeap, there's a couple of ways! Check out Airtable's documentation on how to import CSVs: https://support.airtable.com/docs/google-sheets-importer#importing-csv-files-into-airtable
Their CSV Extension: https://support.airtable.com/docs/csv-import-extension
And the Sync API: https://support.airtable.com/docs/airtable-sync-integration-sync-api
Mar 17, 2024 08:34 AM
The Sync API is not a recommended approach because it creates "read-only tables" in Airtable where users are unable to edit the data in Airtable.
p.s. If your company has a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld