Spreatsheets and search bar and click

Koded Apps
2

You could use RecyclerList extension to render such large data see [Guide] RecyclerList - Google Spreadsheet - Custom Search - How to Add/Delete/Update records