Import Excel data into multiple tables

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
Suppose I'have the following Excel file:

How can I import this information into multiple tables (Projects, Employees, Membership)? I did take a look at the documentation
here, here as well as this question. However, from my understanding this would be better suited for an initial import of data so that the database is set for further use on the database itself.

It is important to note that, per business requirements, this is not a one-off operation as the Excel file must be continually imported to reflect changes. Any ideas would be greatly appreciated as the real file contains 55+ columns and doing things by hand would be time-consuming.

Photo of Omar Segura

Omar Segura

  • 70 Points

Posted 5 months ago

  • 0
  • 1
Photo of Jake Rattner

Jake Rattner

  • 710 Points 500 badge 2x thumb
It sounds like you want to run three separate csv imports to bring records into the three tables.  If yes, have you thought about importing CSVs using the sync tool?  Check out this article if you need more info: (only updates hourly)

You could also setup table-to-table imports and schedule the import using Google Scripts. This could update more frequently than csv sync.  

There are some other ways to go about this, but those are good low-code options.  Let me know if you're interested in more detail.  Thanks.

Jake Rattner | Solutions Architect
(847) 927-1427 |
Quandary Knowledge Base