# Microsoft Excel

**URL:** <https://community.make.com/t/microsoft-excel/72024>\
**Category:** Questions\
**Tags:** error, mapping\
**Created:** [March 2, 2025, 1:58pm UTC](https://community.make.com/t/microsoft-excel/72024 "2025-03-02T13:58:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adil\_Patel](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@Adil\_Patel](https://community.make.com/u/Adil_Patel)\
**Post date:** [March 2, 2025, 1:58pm UTC](https://community.make.com/t/microsoft-excel/72024/1 "2025-03-02T13:58:43Z")

</div>

### What are you trying to achieve?

My goal is for the scenario to retrieve a excel workbook from an attachment in an email i receive, download it and list worksheets (which its doing successfully as there are 3 separate tabs). But i can’t figure out how to get the data in the excel in a format which Open AI can analyse and provide inisights to me for as its not reading the data. also, i want the sheets all to be combined so its done in one operation and not 3. and i want it to send me 1 report in the end and not 3. HELP?!

### Steps taken so far

See above

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [March 2, 2025, 2:18pm UTC](https://community.make.com/t/microsoft-excel/72024/2 "2025-03-02T14:18:41Z")

</div>

Welcome to the Make community!

## Combining Bundles Using Aggregators

Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.

[Aggregators](https://www.make.com/en/help/modules/aggregator.html) are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the [**Array aggregator**](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) module. The next popular aggregator is the [**Text Aggregator**](https://www.make.com/en/help/tools/tools.html#text-aggregator) which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.

You can find out more about the other types of aggregator modules here:

- [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator)
- [Text aggregator](https://www.make.com/en/help/tools/tools.html#text-aggregator)
- [Numeric aggregator](https://www.make.com/en/help/tools/tools.html#numeric-aggregator)
- [Table aggregator](https://www.make.com/en/help/tools/tools.html#table-aggregator)
- [JSON aggregator](https://www.make.com/en/help/tools/json.html#aggregate-to-json)
- [CSV aggregator](https://www.make.com/en/help/apps/file-and-document-management/csv.html#create-csv)
- [Archive (ZIP) aggregator](https://www.make.com/en/help/apps/built-in-apps/archive.html#create-an-archive-973677)
- _other app-specific aggregators_

## Try something first

I would suggest completing the **Make Academy** before jumping into building a complete scenario. If you need **specific assistance** when you are **building a scenario** it’s easier to help you then. Otherwise, you can also **hire a professional** by posting a request in the #Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

### Getting Started

- [Help Centre](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual”
- [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified

### Help Centre Basics

- [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map?
- [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array
- [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output)
- **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting)
- [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file
- [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks

### Articles & Videos

- [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube
- [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist
- [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make
- [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want
- [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [May 31, 2025, 1:27pm UTC](https://community.make.com/t/microsoft-excel/72024/3 "2025-05-31T13:27:36Z")

</div>


