Huge Json file in to excel

Learning Hub Academy Feedback
1

i have a huge json file and i need to convert into excel file how can i do it
New Text Document.txt (32.6 KB)

2

Hi @arjun_27,

To convert Json to Excel, you can follow below steps:

  1. Convert Json to DataTable, to achieve this you can use JSON / JArray Conversion Activities - RPA Component | UiPath Marketplace
    Or
    JSON Utilities - RPA Component | UiPath Marketplace
    custom activities
  2. Write convert activity to excel file using Write Range.

Thank you… Happy Coding!!!

2 Likes
3

Hi @arjun_27,

Can you refer below links:

Thanks,
Neelima.