I have a Google Spreadsheet that is published to the web and embedded in a website. This spreadsheet has data about hotel rooms, such as hotel name, number of rooms, date in and out, etc.

I would like to know if there is a way to allow the user to sort the data by any of the columns (sort by hotel name OR number of stars OR minimum nights, etc.).

I found an app that will pull the data and allow the user to filter it, hiding the data that doesn't match their query. I need to achieve something similar but with sorting, not filtering.

  • No, I switched to a completely different approach. Now I have the data in a local database and display it in the frontend as a table. Then I use a script called tablesort.js that makes any html table sortable. May 8, 2013 at 18:36
  • Excel Online supports this functionality.
    – W1M0R
    Jun 10, 2016 at 9:13

1 Answer 1


To date, this is still not possible with Google Spreadsheets.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.