ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Import JSON to Excel

    Scheduled Pinned Locked Moved IT Discussion
    6 Posts 3 Posters 1.4k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • gjacobseG
      gjacobse
      last edited by

      I have a JSON database file that I need to import into Excel

      Not having dealt with JSON before,... has anyone else encountered this?

      thwrT 1 Reply Last reply Reply Quote 2
      • DustinB3403D
        DustinB3403
        last edited by

        http://konklone.io/json/

        gjacobseG 1 Reply Last reply Reply Quote 0
        • thwrT
          thwr @gjacobse
          last edited by thwr

          @gjacobse multiple possible approaches. Write a COM+-wrapper for JSON.NET to use that component directly in Excel, write a JSON-parser in VBA (would be PITA) or write a small app in a language of your choice with a JSON library of your choice.

          gjacobseG 1 Reply Last reply Reply Quote 0
          • gjacobseG
            gjacobse @thwr
            last edited by

            @thwr said in Import JSON to Excel:

            @gjacobse multiple possible approaches. Write a COM+-wrapper for JSON.NET to use that component directly in Excel, write a JSON-parser in VBA (would be PITA) or write a small app in a language of your choice with a JSON library of your choice.

            Yea,.. about that. I don't code.

            1 Reply Last reply Reply Quote 0
            • gjacobseG
              gjacobse @DustinB3403
              last edited by

              @DustinB3403 said in Import JSON to Excel:

              http://konklone.io/json/

              Data I have is about 3MB, to much for the browser conversion.

              1 Reply Last reply Reply Quote 0
              • thwrT
                thwr
                last edited by

                Mh, would be a 15 minute job. Anyway, can't you split the file into multiple chunks?

                1 Reply Last reply Reply Quote 0
                • 1 / 1
                • First post
                  Last post