HTTP Get returns an Excel file, what are the steps to upload the records to Supabase?

Questions
1

Hey! I would be really thankful if you helped me out with the following:

Via a HTTP Get a file request I can succesfully obtain an Excel file (.xslx), but how do I parse it to a JSON file that I can then upsert all the rows to my supabase table? I’d love any pointers on the best Make.com approach (modules, mapping tricks, or even “don’t-do-that” advice).

Thanks,
Mate

1 Like
2

Hey Mate,

here are some options on how to convert an xlsx file to JSON.

4

@digiPanda_Automation thank you for your kind help! I managed to complete the automtation until the parse CSV which returns the following:

image
image445×874 29.7 KB

However even if I use the custom structure of the array aggregator like this:

aa1
aa1448×586 30.7 KB

It returns the following output with the incorrect variable names:

image
image442×1095 28.8 KB

Which does not match my headers in the supabase table. Do you have any other suggestion how to solve this?

Thanks,
Mate

5

Hey @Mate_Szilcz :waving_hand:

Thanks for implementing our solution — love seeing it in action!

We noticed you’re trying to get your .xlsx data into a parsed JSON format. Instead of using the “Aggregate Array” module, we’d recommend going with the “Aggregate to JSON” module directly. It allows you to define your desired JSON structure and map values from the earlier “Parse CSV” module with precision.

image (2)
image (2)1679×595 103 KB

This approach gives you a clean, ready-to-use JSON output — perfect for upserting into your Supabase table.

Let us know once you’ve implemented it — happy to review or assist further.

Best regards,
Digipanda Consulting Pvt. Ltd
@digiPanda_Automation