2

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.

  • Here is the filtering app: googlesystem.blogspot.mx/2007/07/… – Palmer Del Campo Feb 22 '13 at 14:52
  • did you find any suitable solution? The suggested app does not really work for me... – Daniele B May 8 '13 at 14:39
  • 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. – Palmer Del Campo May 8 '13 at 18:36
  • Excel Online supports this functionality. – W1M0R Jun 10 '16 at 9:13
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, privacy policy and cookie policy

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