---
title: "iterate ~80x faster through spreadsheet using map function in apps script"
author: "Martin Hawksey"
date: 2020-01-14T09:35:00+00:00
modified: 2020-01-13T22:18:38+00:00
canonical_url: https://pulse.appsscript.info/p/2020/01/iterate-80x-faster-through-spreadsheet-using-map-function-in-apps-script/
markdown_url: https://pulse.appsscript.info/p/2020/01/iterate-80x-faster-through-spreadsheet-using-map-function-in-apps-script.md
categories:
  - "Sheets"
  - "Snippet"
tags:
  - "@schoraria911"
  - "script.gs"
featured_image: https://pulse.appsscript.info/files/2020/01/map-vs-for-loop.png
description: "use array map method instead of \"for\" loops to iterate faster through 2-dimensional spreadsheet data. Sourabh Choraria shares his experience of using Array.map to find values in a Google Sheet and the performance benefit of..."
---

# iterate ~80x faster through spreadsheet using map function in apps script

![iterate ~80x faster through spreadsheet using map function in apps script](https://pulse.appsscript.info/files/2020/01/map-vs-for-loop.png)

> [https://script.gs/iterate-80x-faster-through-spreadsheet-using-map-function-in-apps-script/](https://script.gs/iterate-80x-faster-through-spreadsheet-using-map-function-in-apps-script/)
> use array map method instead of “for” loops to iterate faster through 2-dimensional spreadsheet data.

Sourabh Choraria shares his experience of using `Array.map` to find values in a Google Sheet and the performance benefit of using this approach.

Source: *[iterate ~80x faster through spreadsheet using map function in apps script*](https://script.gs/iterate-80x-faster-through-spreadsheet-using-map-function-in-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/01/iterate-80x-faster-through-spreadsheet-using-map-function-in-apps-script/](https://pulse.appsscript.info/p/2020/01/iterate-80x-faster-through-spreadsheet-using-map-function-in-apps-script/)*