# Excel to JSON obj **URL:** \ **Category:** Questions\ **Tags:** excel\ **Created:** [April 20, 2025, 3:05pm UTC](https://community.make.com/t/excel-to-json-obj/79397 "2025-04-20T15:05:59Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![pavolve](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/pavolve/32/69754_2.png) [@pavolve](https://community.make.com/u/pavolve)\ **Post date:** [April 20, 2025, 3:05pm UTC](https://community.make.com/t/excel-to-json-obj/79397/1 "2025-04-20T15:05:59Z")
Hey guys, I’m trying to get cells from excel and convert it to something that I can send to ChatGPT e.g. JSON object. I’ve got the excel data: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/d/8dc2415e48953449955cba38e2ca021927f65997.jpeg) I’ve tried with iteration that gives me a collection of cols of the raws. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/9/09e9bb79b0eed737a820dcfa8559fa696b698344.jpeg) After I’ve used transform to JSON ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/6/56dc9f6399acbf9b9e9723f5ed9ba634edce31e4.jpeg) On this step I stuck. As an OUTPUT I need to have the one JSON with the only Text value and for each cell. So I need to have {“Bundle1”: {“a”: “Email name”, “b”: “TEASER”, …}, “Bundle2”: {“a”: “Subject line”, “b”: “Ready for an EVO-lution?”, …}, …} The cols (a,b,c…) number is not fixed all the time, so I want to use this flow with different excels. ---
**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:** [April 21, 2025, 4:13pm UTC](https://community.make.com/t/excel-to-json-obj/79397/2 "2025-04-21T16:13:00Z")
Welcome to the Make community! To do this, you can try using the JSON “ **Aggregate to JSON** ” module. For more information, see [https://www.make.com/en/integrations/json](https://www.make.com/en/integrations/json), and [https://www.make.com/en/help/app/json](https://www.make.com/en/help/app/json) in the help centre. ## 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_ For more information, see the “ **Mapping with arrays** ” link below. You should also do the [Make Academy](https://academy.make.com), which also covers the use of [Iterators & Aggregators](https://academy.make.com/courses/IntermediateC01). ### Getting Started - [Help Centre](https://www.make.com/en/help) | [Tutorials](https://help.make.com/create-your-first-scenario) – Make “Manual” - search for help here first - [Make Academy](https://academy.make.com) – Basics 101: Learn Make properly to get your money’s worth ### Help Centre Basics - [Mapping](https://help.make.com/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://help.make.com/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://help.make.com/flow-control#VhcUm) - **Date Format** : [tokens for `parseDate`](https://help.make.com/tokens-for-datetime-parsing) | [tokens for `formatDate`](https://help.make.com/tokens-for-datetime-formatting) - [HTTP modules](https://apps.make.com/http) – Make a request, Get (download) a file - [Webhooks](https://help.make.com/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 - [Text Parser module](https://help.make.com/text-parser) - 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. ---
**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:** [July 20, 2025, 4:27pm UTC](https://community.make.com/t/excel-to-json-obj/79397/3 "2025-07-20T16:27:32Z")