Skip to main content
Question

convert Excel data to Json payload

  • March 15, 2023
  • 3 replies
  • 145 views
A

Hi,

i would like to convert excel data into json payload? Is this possible? 
if yes, could someone please help me?

i have three columns with multiple rows.

    3 replies

    Padmakumar
    Premier Pathfinder | Tier 7
    Forum|alt.badge.img+3
    • Padmakumar
    • Premier Pathfinder | Tier 7
    • March 15, 2023

    Hi @Anil 8113 ,

     

    Have you tried the Excel to JSON Package - Bot Store (automationanywhere.com) from Bot store?

    Padmakumar
      A
      • Anil 8113
      • Author
      • Cadet | Tier 2
      • March 17, 2023

      Hi @Padmakumar 

      thank you, it worked.

      A
      • Anil 8113
      • Author
      • Cadet | Tier 2
      • March 20, 2023

      Hi @Padmakumar 

      Output I saved in a text file and I see “Row 1”:, “Row 2”:, “Row 3”:, so on… how do I ignore/remove them from output?

       

      Terms & ConditionsCookie settingsAccessibility statement