Is there anyway through which the imported data from the excel can directly come as tables under Jestor?
We already have a topic related to your question, give a look there: Why can't I use CSV format to upload data?
I don’t mind using Google Sheets as well. But is there a way that the sheets in Google Sheets can come as different tables?
Sure, when you opens the Google Sheets importer you’ll see two methods to do it:
The first one is the migration importer which is the one to import your data and create a new table: Migration - Import your data and create a new Table
The second is the updater to import data and update a table: Update your table