cancel
Showing results for 
Search instead for 
Did you mean: 

Excel to json pipeline

munish
New Contributor

I am trying to convert from Excel to json. The excel file do have multiple sheets. And I want to create same number of json files equals to sheet in excel. And the Json files name should be respective excel file sheet.

1 REPLY 1

dimitri_hristov
Contributor

Hi @munish,

Do you know the number of sheets in the Excel file, and their respective names, in advance?

If you do know this information in advance, it could be relatively easy to accomplish this by using a child pipeline in which you can implement you logic for reading from the Excel file and writing the data to a JSON file.

Cheers,
Dimitri