Creating Excel database in clouds with sync

Good Day Excel Professionals,

I want to consult with You, my boss wants me to create a database which is saved in clouds(Google Sheets), 3 input ways PC, mobile phones, tablets. So there the should be 3 tables, with ability of boss daily to see overall picture, like combining 3 tables, and pivot. I wonder is there any free way to create such Excel Database?

What was done? Created 3 tables in Google Sheets, appended them all and made Pivot table Report. My problem was syncing Google Sheets with PC. Google drive isn't syncing Excel and Google Sheets because they are different. Requiring G Suite but it isn't free...

Any ideas, Solutions, Clues?

Sincerely,
Akmal

You can go to the Data tab > New Query > Then chose from a database. Works for me at work with no issues. Hope this helps.

Best regards,

MLV

Thank You, but i think that is not what i want...

Sandy You caught my point, Onedrive and Google Drive cost some money for two-way syncing plus i have 4 users (onedrive.live.com/about/en-gb/plans/) . Any other platform or maybe it is better studying creating cloud databases? or other?

Maybe it will looks like a joke but it isn't. Build your own server and do there what you want. eg. xampp

Thank you, but now my brain cats Are walking

You're welcome.
Hope they will go to sleep soon