JSON into Excel

[@DiesUndDasOderDasDa]

Concise, clear, no-nonsense explanation! Thanks!

[@Alex-xh9kv]

Excellent tutorial. No assumptions made other than asking the viewer if they have the right version of Excel.
Concise, clear, & short.

[@AlexaSteiger]

Amazing!! I am a semi-proficient Excel user and these instructions completely made my day!!!

[@bobboyle3118]

Brilliant. That's all I needed. Short, concise, to the point! I don't know jack about JSON files. I exported ADO Project Sprint Goals, and now I've got everything I needed. Thank you.

[@siddhantkulshrestha6344]

Thanks, I had to show a nested JSON in excel format to business within 30 min, this video really helped

[@Yuhmz]

Thanks for making such a straightforward easy to understand tutorial for this!

[@legendUandMe]

Your video was amazing! Very precise, concise, clear, no-nonsense explanation about your cats, your whatever... Thank you so much. Sound was very clear which I appreciate and I could see your display.

[@dammtmitch]

Not many tutorials are this great. Thank you.

[@DavinchioNZ]

Thank you for this - very refreshing to see such a high quality and easy to follow video! Love it - please keep it up (liked and subscribed after watching this)

[@JoaoRoseiraBorges]

This is what I call a well prepared and succint tutorial. Thank you

[@smoothoperator6818]

Worked like a dream!! Thanks a ton
I used the same procedure; but on a Web Query API call which returns in JSON format

[@xarzu]

You have done a great thing by making this.

[@NarelleHobbs-f8x]

Great video, easy to follow, clear instructions. Thanks for sharing.

[@ProminentMedia]

Brilliant video - exactly what I needed. That 'expand' button is well hidden!

[@kenostrovsky5473]

Just what i was looking for!

[@ATHRJH]

Just what I needed!!! Thank you so much!

[@ADCUHCL2011]

Thank you! Very helpful video and fixed my excel problem.

[@thulsa_doom]

Excellent tutorial, thanks a lot!

[@LucyConnelly-r4z]

Thank you SPJeff, I never would have seen that tiny "expand record column" button...

[@irmaputtonen359]

Excellent clear advice. Thank you!

[@ionturea6678]

Saved my day. Much appreciated.

[@smartmiran]

Thank you very much , you helped me solve a problem

[@OleksiiH]

Many thanks for the instruction!

[@gauravkhapekar]

Helped me a lot !!

[@mariamm.8400]

Very great and helpful video, thank you so much.

[@mahoneg]

thanks got me what I needed fast -

[@aaronconnolly3060]

Much thanks for this!! Saved me so much time.

[@MrEdaguiar]

Hi man, your video helped me. Thanks!

[@larrybud]

I think at 1:48 you glossed over the dialog box and the options presented. TLDR: choose the default options. (no delimiter).

[@klso14567]

I am not seeing Json option in excel

[@sveli1978]

Excellent tutorial

[@karthik.karunanithi]

Saved my day

[@viveksoni3978]

Thank you Jeff, Life make easy

[@dr_volberg]

2:00 the "Expand" button is so well hidden, if you are trying to do this on your own for the first time.

[@indiefold]

Excellent Video I just needed some data in an api so I can organize it worked great

[@vanessasmith7703]

OMG! Exactly what I need to do

[@nunosilva1162]

Thank you, very clear explanation!

[@asutrevi]

thank you. thank you a million times for this. i was ready to throw my laptop on the ground.

[@RakshithSarvotham]

This is amazing! Thanks a lot.

[@armansuparman]

Terima kasih atas tutrorialnya. Bermanfaat

[@erfarkrasnobay]

you my savior

[@Alp____D.Carpediem]

What are you using to get These red rectangles and arrows onto the screen ?

[@diegodtainha]

u are the guy

[@samerhanoudi396]

Good job, Thanks

[@TheYellowshuttle]

Very useful. Thanks a lot! ❤️👍

[@chetanchavan9798]

Thanks Jeff

[@makhalil4]

i have a question: how can i convert the xlsx back to JSON - like i edited or applied the additions i was to apply on xlsx i want to change it back to json so i can push this new json by api to add the targeted object

[@Akki-bhau]

Can you help how to import directly to Excel from a website, which has dynamic tables and output in JSON format

[@chandrasep15]

Very useful, thank you!

[@vgalino]

Thanks for the tip . very useful

[@PascalFriedrich-tv3gq]

Hello, how do you make those red rectangulars in your video? Nice video!

[@feverpa]

I'm having real trouble. I lose you at 1:17. My results don't show "root" and I have nothing that I can expand or drill down into. When I get to that step, I'm shown Report Name, Description, etc. I have about 12 rows, but none of the important data that was below that "header" type information from the JSON. It's as if the data conversion is only grabbing the overview data at the top of the JSON, then stopping before importing the actual data. HELP!

[@amsc4b275]

fantastic, thanks

[@nicopostigo123]

Thanks man!

[@dustinm2009]

THANK YOU.

[@RichardHellier74]

Thanks @spjeff - helped with an Etsy Reviews task!!

[@samueldrd4819]

I have no expand button. What might be wrong?

[@user-wg7nw3mh2e]

I don't have an expand button, all i can do is create table of one item from the list.

[@Stephen-wh7vl]

this guy gets me

[@sundreamoracle1284]

thANK YOU!!!!!

[@pokeyellow9660]

Thanks!

[@fumiot]

Thank you very much Jeff. Hope you name is Jeff. Yell me if not.

[@jameslizaldop]

can we import in excel 2013?

[@jean-francoisleblanc5202]

Thank you kindly

[@carbajal4508]

what version of office. in 2016 it does not appear

[@mariobetancourtglez]

Thank you!

[@9t4j]

many thanks :D

[@keerthanaunnikrishnan8499]

Thank you

[@wiktorgrabowski3659]

thanks

[@hevenmontalvo]

great

[@14zrobot]

OMG, I was ignoring that pesky button for so long

[@TheLaopi]

Can you share the data ?

[@mugunthanmukund355]

I want the records with drop-down values. Can you help me out? Waiting for your reply

[@poorbarz]

cheers

[@manuel3537]

DO CODE

[@manuel3537]

WTF

[@darkcnotion]

[@syedarsalan5809]

Very useful. Thanks a lot!

[@mateuslima9429]

Thanks!

[@Manas_nannvatte]

Thank you

[@khanyisagura4377]

Thank you ☺️

[@EdwardSun1]

Very helpful, thanks!

[@Mar-mn5tj]

Thank you