Excel to JSON obj

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:

I’ve tried with iteration that gives me a collection of cols of the raws.

After I’ve used transform to JSON

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.

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, and 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 are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the 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:

For more information, see the “Mapping with arrays” link below. You should also do the Make Academy, which also covers the use of Iterators & Aggregators.

Getting Started

Help Centre Basics

Articles & Videos

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

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.