Create CSV text from separate records in Make

Use Make's Create CSV module to combine two fictional records into CSV text. This exercise keeps the result inside Make.

1. Create two source records

1. In Scenarios, click Create scenario. Name it CSV export practice at the top left.
2. Add JSON > Parse JSON. Leave Data structure empty and paste the sample below into JSON string.
3. Save the module and scenario. For a warning that only says the output is unused, choose Save anyway.
4. Click Run once, then Run anyway for that warning. Inspect the JSON result: the top-level array produces two bundles.

Enlarge image

Full Make editor showing a JSON array with two fictional order records

×

Open full-size image

2. Choose the CSV columns

1. Close the result panel. Click the plus to the right of JSON, search for CSV and select Create CSV.
2. Set Source Module to JSON - Parse JSON [1].
3. Open Aggregated fields and select item and quantity.
4. Keep Include headers in the first row set to Yes. Use Other as Delimiter, a comma as Delimiter character, and LF as Newline.
5. Save the module and scenario.

Enlarge image

Full Make editor selecting item and quantity for CSV aggregation with headers enabled

×

Open full-size image

3. Check the single output

1. Click Run once. Handle the unused-output warning as above.
2. Open the result bubble above Create CSV.
3. Under Output, check that one bundle contains text with the header and both rows below.

Enlarge image

Full Make editor showing one CSV text output with a header and two quoted rows

×

Open full-size image

The comma inside the notebook name stays inside quotes. Check the header order and how your receiving app interprets each column before using a real export.

When you add fields, check their order in the generated header row. The order shown in Aggregated fields can differ. If you parse the CSV again, enter CSV headers (recommended) in the exported order. A successful run can still put values under the wrong names, so inspect each parsed record before mapping an action.

If a column is missing

Run the JSON source with representative data, then reopen Aggregated fields. Include every required field and choose the source that emits the records you intend to combine. For a different receiving app, match its documented headers, delimiter and newline requirements.

Using a spreadsheet may be simpler for a one-off export. Check the Free-plan limits before adding scheduled actions.

Sources: Make CSV modules (opens in a new tab); Make aggregator documentation (opens in a new tab). Screenshots show Make with fictional practice data.