ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Step 1
Make changes to this document
2
Step 2File | Share | Public
3
Step 3
File | Publish To Web (Copy Special Code)
4
Step 4
Rebuild data in application (e.g. request a URL)
5
6
Notes
Tab order doesn't matter, though don't change during import
7
Underscores are some other symbols are removed from headers (by Google's API)
8
Capital letters are lowercased in headers
9
Colors, formatting, comments will not be made available in application
10
"id" is a special column for naming rows
11
"meta" is a special tab for describing data
12
Tabs which don't appear in "meta" will be ignored (like this one)
13
14
Data TypesignoreData in this column type will not be imported
15
integere.g. 1, -2, 99999
16
jsone.g. [1, 2, 3], {"a": "b"}
17
stringe.g. "Banana"
18
booleane.g. TRUE/FALSEGoogle Sheets defaults to uppercase, so we use that
19
floate.g. 1.2, 2
20
arraye.g. [1, true, "blah"]
21
array.integere.g. [1, 2, 3]
22
array.stringe.g. ["first", "second"]
23
array.booleane.g. [true, false]
24
array.floate.g. [1, 1.1, 1.2]
25
26
Meta Formatshashe.g. {"1": {"id": 1, "name": "Steve"}}Good for tables of data like an RDBMS
27
keyvaluee.g. ("title": "Cool Project"}Good for key value pairs
28
arraye.g. [["a", "b", "c"],["d", "e", "f"]]Good for matrix data
29
30
Proposed Formatsobjectse.g. [{"a":1,"b":2}, {"a":3,"b":4}]Array of objects (like HASH but no id)
31
liste.g. ["a","b","c"]Simple array of natives
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100