Well here’s something I never knew until today…I was watching one of Mike ExcelIsFun Girvin’s great YouTube videos from his great Slaying Excel Dragons series – the one on Excel 2010 Keyboard Shortcuts – when he showed how to do the equivalent of a mouse right click using a key on the keyboard that I’d never noticed before…the Menu key.
The menu key is located to the right of the space-bar, tucked in between the Windows key and the right Ctrl key.
I wonder if even Dick Kusleika knows that one. (Legend has it that the only time that Dick’s fingers leave the keyboard is when he “salutes” Excel when it crashes.)
Hui pointed me to a recent post right here called Replace formulas with values using this shortcut that covers this very tip, but somehow I missed it.
Did you know about that key? Be honest now, in the comments below.
—Update—
Both Sam and Marton have reminded me that if you don’t have the menu key, you can instead use Shift+F10 to do the same thing. Thanks, chaps…without you, I’m half-baked!
One Response to “Easily Convert JSON to Excel – Step by Step Tutorial”
Great guide! You mentioned that "Power Query in Excel offers a quick, easy and straightforward way to convert JSON to Excel." This is very true for simple structures. For those dealing with deeply nested JSON that Power Query struggles with, I've found a few tips helpful: 1) Flatten the JSON structure before importing if possible, 2) Use Python for more complex transformations as you suggested.