Import JSON Data Into Excel 2016 Using a Get & Transform Query

thanks

I don't see the JSON option on my MSO 16.

Thank you for this video, it helped me with a problem I had at work 🙂👍

Thank you so much. This is awesome. Lifesaver!

one dislike for stupid tonnes of useless ads

It's the first time i see a Json file Can you share ? Thks

Great Job... Very descriptive and easy to follow!

thanks! the video helped!

Very useful and clear. Thanks a lot it worked the first try ;)

5 years later and you still svaing people with this. Thank you broskie

thanks

Nice 👍

Thanks 🙏

Is there a we can automate this process using macro

how about showing the json file in Notepad first?!?! you spend 5 min on something that could have takes less than half. Please review the way you make these videos

I don't have the JSON option, only CSV and XML, how do I unlock it?

Great explanation, thank you. DeltaJSON is really useful for developers working with JSON, it does compare, merge and graft.

Thankyou so much Ryan! Amazing video.. Too helpful !! :)

Well Explained .Thanks a ton

Hey Thanks for video. I got an error during import the .json data [Details: "Duplicate name:'_field_name'] how to sove it?

Thanks a lot it's very useful to me. After converted to excel and sent to my boss. She is appreciated to me.

Am trying to convert last five days.
But, finally today simply converted to excel.
blessed because of you.


Thank you soooooo much. God bless you man.

Good job. That made my day

when I imported it and fix, how to transform excel to JSON?

I don't have icon with two arrows. What would you recommend then?

Very helpful thanks! I love the Windows 7!!!
Gaming and Excel unite!

10 Sep 2021
12:32pm NZST

Thanks too much

very helpful indeed, thank you. Im connected to the supervising banking authority here, after watching this I was able to convert the information we have access to into manageable excel data. once again I am greatly thankful

Thanks for the vid is it possible to import multiple files at once?

This is exactly what I needed to figure out! Thank you so much!!

Very useful, thanks

Thank you so much!!!

Thanks for this video... It helped a lot and was straight to the point! Great job!

Thxs a lot, very useful

Muito obrigado!!!

Great Tuturial, thanks a lot!!!

Thanks! Helped a Lot!

Hi. I'm trying to import a .json file on Excel 2016 by your method showed on video. The work is ok until i click into "Close and Load". Excel show me an error message "Initialization of the data source failed. Check database server or contact your database administrator....".

I searched for error on the web (re-install visualc++ for example) but i'm not found a solution. I believe that there is a error about renaming columns, because the step before are correct.

On video you rename columns by "Items" prefix. Is there a connection with the columns's name of file .json?

Thanks on advance.

Helpful, thanks

Descriptive, to the point and it worked. Thank you!

Helpful in 2020! Thank you.

Thanks for the nice video. After importing the data and modifying, does anyone know how to update the same json file?

Watching in 1,75x is perfect

meal-eh

finally someone explained it well , thank you so much

Спасибо, добрый человек. Твое видео-единственное, которое помогло моей соломенной голове )

nice clear and very useful

thanks man, very useful and very precise!

How can we deal with nested lists ?

Thank You!

Thanks for the tips