I am looking for a MySQL UI with some spreadsheet-like features.
- Copy & paste functionality
- Conditional formatting
I have tested a lot of tools and have not found exactly what we need.
Table Plus is great. It's the closest thing I've found. It allows you to copy and paste rows, then click save to run the insert queries.
I've also tried AppSheets and Retool. They are powerful and can connect directly to MySQL. You can add conditional formatting and other automations which are nice. But the copy & paste functionality is missing.
On Retool's forum someone requested this copy & paste feature. Unfortunately, Retool just suggested a work around.
We need a single central database that multiple people can work on at once. So local Excel does not work.
We currently use Excel with collaborative co-authoring. Then we import the spreadsheet into a MySQL database. This partially works, but our data is getting too large for hosted Excel and we need strong typing and other features that a relational database provides.