ViewTube

ViewTube
Sign inSign up
Skip

Recommended videos

Kevin Stratvert
How to use Microsoft Power Query
16:35
How to use Microsoft Power Query

1,789,347 views

3 years ago

Web Dev Simplified
Learn JSON in 10 Minutes
12:00
Learn JSON in 10 Minutes

3,103,176 views

5 years ago

Wursta
Wursta Webinar - Beyond the AI Hype: Building an AI Playbook
27:40
Wursta Webinar - Beyond the AI Hype: Building an AI Playbook

106 views

4 hours ago

Learn Google Sheets & Excel Spreadsheets
Excel JSON to Table - Import Data JSON from Web URL using Power Query - Part 2
19:40
Excel JSON to Table - Import Data JSON from Web URL using Power Query - Part 2

29,786 views

4 years ago

Show more

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

370,494 views

0

Channel image

SyntaxByte

9.88K subscribers

Sat, 18 Mar 2017 00:00:00 GMT
Share

Tags

excel

excel2016

office365

json

powerquery

getandtransform

Connecting Excel 2016 with JSON data is easy. Using Get & Transform (formerly PowerQuery) allows you to write a query to create a table from your JSON data. Written Tutorial: https://syntaxbytetutorials.com/import-json-data-in-excel-2016-or-2019-or-office-365-using-a-get-transform-query/

149 Comments