|
|
|
|
|
|
by fulldecent2
2535 days ago
|
|
|
At our company, we use an ETL script to suck all our Google sheets into MySQL then we run queries for reporting. It's pretty nice, we'll probably open source it. The worst part is that as a database, Sheets is not one-tenth as good as MS Access was. You can't enforce constraints or even disable certain people from editing the format of a cell. There's lots of things you can try but you are just one inadvertent copy-paste away from losing formatting/validation rules you had set. |
|
|