ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
IMPORTJSON● LIVE
2
Make a copy →
3
Turn JSON APIs into clean Google Sheets tables — with standard JSONPath, JSON Pointer and shared HTTP caching.
4
JSONPath · JSON Pointer · 1h HTTP cache · MIT · tested releases
5
6
01 Repository JSON → a clean table
7
LIVE RESULTFORMULA
8
/full_name/stargazers_count/forks_count/open_issues_count/license/spdx_id=IMPORTJSON(H12,"$",H13:L13)
9
rektosaure/ImportJSON106MIT
10
11
One fetch can feed multiple transformations. The raw JSON response is shared through the HTTP cache.INPUT · API URL
12
https://api.github.com/repos/rektosaure/ImportJSON
13
/full_name/stargazers_count/forks_count/open_issues_count/license/spdx_id
14
15
16
02 JSONPath selects records · JSON Pointer selects fields
17
LIVE RESULTFORMULA
18
/name/email/company/name/address/city=IMPORTJSON(H22,H24,H26:K26)
19
Leanne GrahamSincere@april.bizRomaguera-CronaGwenborough
20
Ervin HowellShanna@melissa.tvDeckow-CristWisokyburgh
21
Clementine BauchNathan@yesenia.netRomaguera-JacobsonMcKenziehavenINPUT · API URL
22
Patricia LebsackJulianne.OConner@kory.orgRobel-CorkerySouth Elvishttps://jsonplaceholder.typicode.com/users
23
Chelsey DietrichLucio_Hettinger@annie.caKeebler LLCRoscoeviewJSONPATH
24
Mrs. Dennis SchulistKarley_Dach@jasper.infoConsidine-LockmanSouth Christy$[*]
25
Kurtis WeissnatTelly.Hoeger@billy.bizJohns GroupHowemouthCOLUMNS
26
Nicholas Runolfsdottir VSherwood@rosamond.meAbernathy GroupAliyaview/name/email/company/name/address/city
27
Glenna ReichertChaim_McDermott@dana.ioYost and SonsBartholomebury
28
Clementina DuBuqueRey.Padberg@karina.bizHoeger LLCLebsackburyStandards-first: JSONPath chooses the records; JSON Pointer chooses the output columns. No proprietary query language.
29
30
31
32
03 Cache by default · refresh on demand
33
LIVE RESULTCACHE MODE
34
/completed/id/title/userIdRefreshFALSE = cached
35
FALSE1delectus aut autem1
36
Make a copy, then toggle TRUE to force a fresh GET and replace the cached entry. FALSE uses the cache normally.
37
Eligible responses are cached for up to 1 hour. Cache-Control directives from the server can shorten or disable that TTL.
38
FORMULA
39
=IMPORTJSON("https://jsonplaceholder.typicode.com/todos/1","$",,,J34)
40
41
42
43
04 Playground · paste your own public JSON API
44
INPUTSLIVE RESULT
45
API URLhttps://jsonplaceholder.typicode.com/users/name/email/company/name/address/city
46
JSONPath$[*]Leanne Grahamsincere@april.bizRomaguera-CronaGwenborough
47
Columns/name/email/company/name/address/cityErvin Howellshanna@melissa.tvDeckow-CristWisokyburgh
48
RefreshFALSE = cached · TRUE = fresh GET
49
50
FORMULA
51
=IMPORTJSON(C45,C46,C47:F47,,C48)
52
53
54
55
56
57
Make a copy to edit these green inputs. Current release supports public HTTP/HTTPS JSON endpoints; authentication is intentionally not part of this demo yet.
58
59
60
61
62
Open source · MIT · maintained · automated conformance tests
63
GitHub repository ↗Latest release ↗
64
65
66
67
68
69
70
71
72
73
Current version supports public HTTP/HTTPS JSON endpoints. Authentication is not part of this demo yet.
74
75
76
77
Open source · MIT · maintained and tested
78
GitHub repository ↗
Latest release ↗
79
Tip: some Google Sheets locales use semicolons instead of commas as formula argument separators.
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100