Auto import an excel file

  • 0
  • 1
  • Question
  • Updated 3 weeks ago
  • In Progress
It there a way to have Quick Base point to a folder on a computer or server and recognize when there is a new or updated excel file and automatically import it into a specific table in my app?

Then can Quick Base create a summary report based on that new data and upload it to a different table in the same app?
Photo of Stephanie

Stephanie

  • 596 Points 500 badge 2x thumb

Posted 3 weeks ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
Natively, there is Quick Base Sync which can upload CSV files (not Excel) every hour and add to the existing table.   

But note, you cannot retroactively change a table to be a sync table and also be aware that once you go Sync, then you cannot add records manually, only by Sync.

As for making a summary report and copying to another table alas, there is not a native way to automate that.