Auto import an excel file

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
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

  • 676 Points 500 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
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.