Google Sheet Search slow

**To_Huy** · March 25, 2019, 3:15am

I have 1k rows in google sheet.
When I search some thing, I very slow.
How do I do?
Thanks

**KarenBarker** · March 25, 2019, 10:53am

Hi there,

Is the search always slow regardless of the number of rows or does this get worse the more rows your Google sheet has?

**To_Huy** · March 25, 2019, 1:45pm

Hi @KarenBarker
It searches slowly with more rows (about 500 rows)

**DanielBeckett** · March 25, 2019, 4:27pm

Thanks for the info @To_Huy

How long are the searches taking on average? Does it vary or is it quite consistent?

**To_Huy** · March 26, 2019, 1:31am

Hi @DanielBeckett
bout 5s

**DanielBeckett** · March 26, 2019, 3:00pm

Hi @To_Huy

To search a sheet with thousands of rows that time actually seems about what we’d expect as an average at the moment.

There’s certainly room for improvement in how the Google Sheets service works and we’ll look into that for future updates but in the meantime I’m not sure there’s really much that could be done to help here other than to avoid having a large Google Sheet.