Your Google Sheet, sorted every time a row is added
KeepSorted is a Google Sheets add-on that re-sorts your real rows (not a SORT() copy) whenever someone types a new row or changes a value. Pick the columns once; no script to maintain. Prefer code? Our free Apps Script how-to is below.
KeepSorted is built and in testing; it is not in the Google Workspace Marketplace yet. One email when you can install it.
What KeepSorted does
Sorts the data itself
Rows move like a normal Data > Sort range: formatting and formulas travel with them, the header row stays on top, blanks go last. Nothing is written when the sheet is already in order.
Free that is really free
One auto-sort rule per tab with up to 2 sort columns, for as long as you like. No trial clock.
Pro for messy real sheets
Stacked tables on one tab sorted separately, custom order (High > Medium > Low), up to 5 columns, and rows from Google Forms or other editors sorted too.
Pricing
Free
- 1 auto-sort rule per tab, up to 2 sort columns, sorts on every edit made by people who have the add-on
- Header row kept on top, blanks last, Sort now button
Pro
- Up to 10 areas per tab, including stacked tables split at blank rows, and up to 5 sort columns
- Custom order (e.g. High > Medium > Low) for status and priority columns
- Sorts rows from Google Forms, other editors and imports (Forms/edit triggers plus an hourly check)
Rather paste a script?
For one sheet and one sort column, a short Apps Script onEdit function does the job for free. Our guide How to auto-sort a Google Sheet when a new row is added has the copy-paste script, the Google Forms version, and the catches to know about. More free guides: auto-sort by date, newest first (Google Forms too), auto-sort by multiple columns when data changes, and StaySorted alternative: an honest comparison.