Results 1 to 3 of 3

Thread: Missing JSON file option
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Missing JSON file option

    Hi, I've recently got the office 365 package as I have JSON files which I want to use within excel. When I select data > new query > get file > there is no option for JSON yet when I Google it the option should be there. Does anyone know how to fix this as I've checked the ribbon to make sure it's selected and all seems ok.

    Many thanks for any help.

    Dan

  2. #2
    MrExcel MVP VBA Geek's Avatar
    Join Date
    Dec 2013
    Location
    Kepler 438B
    Posts
    2,857
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Missing JSON file option

    Indeed you should have the JSON option in Power Query. Perhaps try to update the version of excel:


    https://support.microsoft.com/en-us/...onthly-channel

  3. #3
    New Member
    Join Date
    Aug 2018
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Missing JSON file option

    Thank you, this has worked a treat.

    Quote Originally Posted by VBA Geek View Post
    Indeed you should have the JSON option in Power Query. Perhaps try to update the version of excel:


    https://support.microsoft.com/en-us/...onthly-channel

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •