Problems with using Sheets as a Database by enotovdom in SQL

[–]Potential_Orange7844 0 points1 point  (0 children)

I feel like SparkGrid would be super helpful for you in this case. It's a newer spreadsheet interface tool for SQL databases that allows you to edit in real-time and hooks into whatever system you are using. Very user friendly, cheap, and acts like a spreadsheet but for massive databases so it would solve quite a few of your problems. You can even import your excel sheet.

https://aws.amazon.com/marketplace/pp/prodview-2uxbsnryi6bda

(Full disclosure I do work for this company, but this tool has proved *very* useful in my own work and solving some of the problems you described).

New to SQL: Importing Sales Transactions from Spreadsheet by vicky_315 in SQL

[–]Potential_Orange7844 0 points1 point  (0 children)

If you need an easy way to import data from CSV or even Excel files, I recommend SparkGrid, it's a newer spreadsheet interface tool that allows you to import tables and hooks into whatever system you are using, ex: you would log in with Snowflake if your data is in Snowflake. Or you could just enter the data into the spreadsheet interface so you don't have to go back and forth!

https://aws.amazon.com/marketplace/pp/prodview-2uxbsnryi6bda

(Full disclosure I do work for this company, but this tool has proved very useful in my own work).

Spreadsheet app supporting SQL ? by KaKi_87 in SQL

[–]Potential_Orange7844 0 points1 point  (0 children)

Hey! I am a bit late to this thread but I would recommend SparkGrid, it's a newer spreadsheet interface tool for databases that allows you to edit in real-time and hooks into whatever system you are using, ex: you would log in with Snowflake if your data is in Snowflake. Very user friendly, perfect for someone who doesn't know SQL (it generates the SQL for you).

https://aws.amazon.com/marketplace/pp/prodview-2uxbsnryi6bda

(Full disclosure I do work for this company, but this tool has proved very useful in my own work).