Coding the GD Editor in a Spreadsheet

I was bored™ so I streamed myself coding a spreadsheet that allows you to build Geometry Dash levels that can be uploaded to the servers. This is PART 1 and is heavily focused on the actual coding process, while part 2 will be more about layout building.
TRY OUT THE SPREADSHEET HERE!
gdcolon.com/gdsheet
(If you make anything cool, be sure to tag @TheRealGDColon on Twitter or use #GDSpreadsheet so I can find it!)
Part 2: • Building an Entire GD ...
Full stream(s): • [Streams] GD but it's ...
--------------------------------------
🎮 Second Channel - bit.ly/gdsemicolon
🐦 Twitter - / therealgdcolon
💻 Website - gdcolon.com
🤖 Discord Bot - robotop.xyz
💬 Discord Server - / discord
If you're reading this, make sure to add "btw typescript sucks" to the end of your comment.

[@GDColon]

Hey gamers, if you wanna try the spreadsheet for yourself you can grab a copy of it here! gdcolon.com/gdsheet Be sure to @ me on Twitter or post vids with #GDSpreadsheet so I can see the cool stuff you guys put together! Also, if you wanna try out the level I built with this sheet, the ID for it is *64528240* My next video will be highlights from building the level! (plus level uploading)

[@MatPlayz]

i might try

[@glato7]

The FitnessGram™ Pacer Test is a multistage aerobic capacity test that progressively gets more difficult as it continues. The 20 meter pacer test will begin in 30 seconds. Line up at the start. The running speed starts slowly, but gets faster each minute after you hear this signal. [beep] A single lap should be completed each time you hear this sound. [ding] Remember to run in a straight line, and run as long as possible. The second time you fail to complete a lap before the sound, your test is over. The test will begin on the word start. On your mark, get ready, start.

[@charlesmot54]

I would but I'm on mobile, not sure if I can, pretty lazy and dont feel like it either lmao

[@Cacaanimationsthesecodn]

5th comment on this

[@KloVe4k]

Pneumonoultramicroscopicsilicovolcanoconiosis Pseudopseudohypoparathyroidism Floccinaucinihilipilification Antidisestablishmentarianism supercalifragilisticexpialidocious Incomprehensibilities sesquipedalianism

[@ElectrifyXD]

alternative title: Colon being disappointed at his own code for 19 minutes

[@DxrkVoid]

Yes lol

[@Marcelelias11]

Relatable

[@m4rcyonstation93]

Isn’t that all of us

[@Matthew-is-Moving]

And 25 seconds

[@NarjaraSMagalhaes]

alternative title of the alternative title: pretty much me

[@DxrkVoid]

People: nice video colon Video: 19 minutes long 3 minutes ago ....

[@rudy7548]

Bruh

[@DJENEOfficial]

The intro reminds me of Dream xD

[@ShaadyMan]

@@DJENEOfficial bruh

[@Bigmosley07]

Hold up your comments says 6 minutes ago but the video says 5 minutes ago hold on a minute

[@DxrkVoid]

@@Bigmosley07 I didn’t watch the whole vid I didn’t comment nice video

[@mrlibrawastaken]

Can we just appreciate he took the time to make a parody of Dream’s intro

[@juicyguyzer]

you copied my comment and got a heart and 20 likes wtf

[@tmtom_8155]

He forgot the low saturation filter.

[@arplight7]

Yes

[@swifttt]

he even added the music too

[@accountdisbanded]

Ah, yes. Dram

[@Gostley]

I just realised 1 thing... *We can finally make megacollabs with ease*

[@bepil7178]

Oh my god yes

[@Reactive04.]

Oh yeah, this is big brain time

[@hiumegalodon2809]

YEAH ITS GREAT

[@iamebay5923]

YES

[@cr3epet277]

CAT ICON HAPPY

[@gbl148]

Noice Next up: Coding a Google Spreadsheet in GD

[@jaycubes]

i genuinely believe 2.2 would actually make that happen

[@Weezeler]

TYPESCRIPT SUCKS

[@AshPikachu9]

@@jaycubes so never happening

[@shardofglass]

@@Weezeler that’s what colon said. Literally. btw typescript sucks

[@Klaux]

Me: can't even use Excel to make a simple graph for college. Colon: _codes the whole GD editor in Excel_

[@miwiki6]

hello klaux

[@Klaux]

@@miwiki6 hi

[@GDColon]

hello klaux

[@Klaux]

@@GDColon hi Craig

[@gayfurry5287]

hi klaux

[@souljynx]

"me and the boys making a megacollab on google sheets" -me, during the stream

[@gmzynx]

i actually wanna know now, would that work

[@souljynx]

@@gmzynx idk lmao

[@itslumine]

@@gmzynx as long as everyone understands the tools colon programed then yes

[@thatoneguy9582]

Honestly that would probably work really well I assume

[@DryBones818]

same its may for me

[@shyftrr]

You could probably code 2.2 from scratch and be done with it before RobTop is

[@RPC29Gaming]

**looks at macropixel**

[@brutalthebigone]

do it *IN SCRATCH*

[@TotallyNotMax1]

Colon strikes me as the kind of guy to create a minecraft structure generator on top of minecraft's structure generator

[@SkylarGlider]

Next vid

[@barsukascool]

I know im like 2 years late lol, but there is a 2.2 private server

[@superdot9513]

"function doShit()" 1:44 groundbreaking naming conventions

[@aaronhrahsel6147]

Colon: screams at his code for doing what he didn't tell it to do The code doing exactly what colon coded it to do: (Insert crying cat)

[@Marianian]

Colon: "takes him hours to make a level in spreadsheet" Me, who can do it in 10 minutes in the game itself: *Pathetic*

[@SkylarGlider]

XD

[@biggerboids]

"Consider unsubscribing" Dude I'm as tired as you I know how it feels bro.

[@alfy01]

"Nooo arrays start at 0!!" So damn relatable 😂

[@masterpablothedarkman]

Colon: "puts a Dream reference in the intro" Dream fan's: *wAs ThAt A dReAm ReFeReNcE????*

[@arplight7]

lmao

[@batuajah2007]

i get it xD

[@literallyonlysuperb]

69 speedrunners vs 420 hunters

[@jirehemanuel]

Wait I thought that's a KZbin feature...

[@batal0538]

ha

[@SumPlusWord]

I am proud to say I was able to get a copy of the ancient level “peepee” by Colon and I am now selling it for $5 per copy! :)

[@fxshyy]

will you take £10 for a copyable with no pass?

[@6316]

Sure

[@SKYGamingYT1]

imagine if there was no real gd editor and you had to make levels like this

[@booprsnoot]

then I wouldn't be playing geometry dash because and as dumb as an ant lol

[@DiamondThing]

Pain

[@fallingbat2433]

Someone stop the mad lad… Keep up the good work buddy.

[@Klaux]

At this rate he's probably gonna finish 2.2 in a spreadsheet before Robtop does it himself

[@Reihynn]

colon is literally refrencing every youtuber in some way

[@videogamahagain]

He might reference jojo if we're not careful

[@ahmed4363]

@@videogamahagain oh no

[@Reihynn]

@Adam Baine Cubillas ancient comment on my side lmao

[@SpamLRBLX]

Hi Reihynn

[@Reihynn]

@@SpamLRBLX SPAML

[@The_Horizon]

yo I wonder if someone could make another seperate GD editor to make level building much faster

[@boxofturtles761]

You have to crash the p2w gem and mana orb economy

[@beequabee2593]

How did i just find this now?

[@gbl148]

"in y=46 and x=O" Did you put that on purpose?

[@poliwagpi4554]

im just singin cos its over

[@Venom-xb4jx]

Xo

[@nocontent1238]

Well I'm assuming so, he edited in a part of the XO instrumental.

[@Cryptic-xz7ph]

EX OOOOOOOH

[@kham_pastgom]

Probably not

[@YourRFriend385]

Nice reminder at the beggining! I now remembered to unsubscribe

[@Klaux]

lel

[@Reactive04.]

Yes, I just unsubbed as well

[@javiaa._]

you spelled beginning wrong

[@Weezeler]

Me too!

[@vunshsharma1817]

Lol

[@tristan4gd281]

0:21 Now I know that Colon is a fan of Dream xD

[@guiAstorDunc]

That beginning segment was essentially “I did a bit of mining off camera” but on a whole different level lmao

[@arplight7]

I have been waiting to see this video uploaded. Im happy to see original content as expected from you :)

[@xRaffa]

Does anybody notice in 0:37 in the second tab and it says "How to program a girlfriend", "sewayaki kitsune no senko-san", "little bobby tables", "definition of insanity" and "yanderedev coding practices"

[@evylah2]

no

[@ItzVaporwaze]

Alternative Title: Colon becomes an absolute intellectual and does big brain things on stream

[@6316]

Yes

[@inno4245]

1:43 Great way to name your functions 👍

[@NANKAIDATTE]

Colon: (puts dreams intro) 10 years later... Dream: (fake face reveal with colons face)

[@Ronicalter]

So

[@charlesmot54]

When i first seen the streams there were all kinds of bugs lol. I'm glad you fixed them, wish I was able to watch the streams more. Great video so far though Edit: Great video in its entirety

[@lywke9574]

soon, “I made a sequel to HOW in a google spreadsheet”

[@pikutastic]

This is CRAZY... You did AWESOME Colon!

[@duckit]

She's in love with the concept

[@avision7487]

As if we're all just how she imagined

[@lucidmlem]

Where in love we just don't know it at huh

[@avision7487]

Well, tell me how am I supposed to see the magic?

[@rthree8102]

Cause I don’t believe in it no more

[@avision7487]

But wont tell her

[@memesalt_19182]

Honestly colon deserves more subs because of the work he does

[@Xx2Devexia2xX]

Awesome! I was quite bummed not having time to catch the streams

[@Xx2Devexia2xX]

More coding videos would be awesome, that was quite untertaining :)

[@qw8u]

Congrats on 250k, Colon! :D

[@KopsGD]

Even though I don’t really understand coding, I still thought that this was an awesome video! “Btw typescript sucks”

[@Luka-he5mr]

typescript doesn't suck

[@KopsGD]

@@Luka-he5mr read the last line of the description, I just said it because colonial man told me to lol

[@Dukemz]

This is awesome! You've made a lot of amazing projects, and this is no exception. I really do look up to you :) btw typescript sucks

[@pitifulrock630]

i havent watched the whole thing but i clicked the link and made a level. holy shit good work man!

[@cipherstar6760]

best part of finding an awesome channel you've never seen before is when they have a fuck ton of content already posted for you to binge. you're really entertaining to watch when i'm just chilling in bed after a long day, so thanks. btw typescript sucks.

[@DuderGamer]

This is honestly awesome, the fact that you put that much effort into something amazes me. btw typescript sucks

[@kantraa]

Me: **doesn't know how to use excel** GD Colon: **literally codes the whole GD editor on excel**

[@QuincyBTD]

It’s Google Sheets, not Microsoft Excel

[@dumb5308]

this is so fucking cool dude, how are u so good at typescript ?? literally amazing, can't wait for part 2

[@dumb5308]

also just wondering - is there like a wiki for the structure of GD levels? just interested :)

[@Muffin_1645]

This is actually incredible, nice work, Colon from 3.5 years ago!

[@kazy.2936]

I like how bored is trademarked in the description

[@Nerdopedia]

btw typescript sucks

[@Weezeler]

Typescript sucks

[@dradekon]

Whats typescript

[@batal0538]

@@dradekon typescript

[@Metricdoom]

0:27 reverse scpycology

[@erikhjortsater5461]

Scpycology

[@Metricdoom]

@@erikhjortsater5461 yeah mate I have no idea how you spelled that

[@erikhjortsater5461]

@@Metricdoom psychology?

[@TheRealMusix]

Nice Colon. You make lots of cool things

[@ProjectPowerPoint]

This is awesome! Fellow making stuff in office programmer here!

[@figmentboy]

The fact that the file you put Ugly KZbinr in was PHP was icing on the cake ts = bad btw

[@yoshiboi18303]

Lol. Hi Figment. (Someone kill me soon)

[@cst1229]

let typescript = "bad";

[@sjebsstuff1354]

Nobody: What Colon thinks the comments will end with: btw typescript sucks

[@colinstorm2892]

I love the idea that you recreated the dream intro 🤣 Your vids are always good

[@therealgdbg4]

I don’t wanna unsubscribe, you’re a great youtuber

[@eneidahoracio]

0.1%? THAT'S SO SMALL!

[@ridzuanmd.s.4753]

The “Dream” of Geometry Dash🤣 if you know what I mean

[@uzziahlatour1052]

I dont know wjat you mean

[@jansenncuber8009]

@@uzziahlatour1052 he means that he codes cool or funny stuff regarding the game

[@uzziahlatour1052]

@@jansenncuber8009 ok thantfor ckearing that up.

[@NANKAIDATTE]

@@jansenncuber8009 *facepalm* do you know dream??????

[@hxgonic]

YES i saw this on a comment some time ago, glad you made it XD

[@aidancode]

Man colon is actually seriously intelligent with programming. I hope you get a good job man cuz ur really gifted. and yea i know your arent the best at programming, but its a difficult skill

[@zel9853]

Hi

[@krisna08gd]

Yooo your the first comment

[@glato7]

Hi

[@hoopa.g1]

Ay gg

[@0D0R]

This da first :))

[@itsashyboi8943]

You are first! GG

[@playfulpigmsm5613]

First, luv your vids❤️❤️

[@rudy7548]

Well I luv you

[@noofi3601]

Watttt

[@rudy7548]

Wuv you too

[@noofi3601]

???

[@playfulpigmsm5613]

Crazy right😂

[@juicyguyzer]

*THIS VIDEO* and *SMALL PERCENTAGE OF PEOPLE ARE SUBBED* i smell a dream intro

[@user-ng8cm1bn6j]

True

[@radiant_7354]

you are legit more useful to the gd community then probably every mod ever

[@krisna08gd]

Stop saying first, kid.

[@Bryce_XYZ]

thank u nobody cares if people are first

[@inkaytoo]

ye i will

[@thisguykreas]

Unsubscribed Edit: Resubscribed in the future

[@Delon1878]

this is exactly what we need while we’re at home waiting for 2.2

[@henrybusse7513]

Absolute legend with the oneshot background

[@gdviicecold9008]

It might be off topic but 2.2 is taking really long because it is actually taking most levels and the level editor from SZ, MD and W, adding new features using THIS FOCKING FEATURE Keep it up man.

[@raynelfastination]

I loved how you mocked Dream at the beginning😂. That was pretty clever!

[@rayg9067]

I like how the music is the Mario Paint Creative Exercise theme

[@Cooproxx]

This is incredibly entertaining

[@jack-vh6ci]

hello colon. i see you have made a geometry dash level in google sheets. thats cool. good job

[@sassibagnati7637]

Cool good job man

[@mezbo704]

Colon, you are a god at coding

[@its_marre7]

0:23 dude, I actually believed that chart for a moment, but then I remember, you're a coder.

[@AbsnormalCoolest]

Colon: *codes the entire GD level maker in Google Sheets in 3 entire streams* Also Colon: "It's very basic."

[@b_mbyz]

coding is amazing simply because of the reaction u get when u do something big brain i do kenos reaction every time my code works O_o

[@tr1xter69]

0:36 these tab titles are hilarious :D

[@Mr_Reggie]

1:42 I like how the function at the top is called "doShit"

[@polarizing]

Heres a idea, I saw a comment a while back. it really made me think. Most levels in GD atm are not random, and for sure not physics based. technically they could be controlled via some sort of bot. This is prior to change when 2.2 introduces the random trigger. My challenge for you is to train a form of AI to play GD and beat stereo madness. Theoretically this is very possible, although the training algorithm you would pick for the AI would make quite the difference. Want a real challenge, train it to beat electrodynamix, nah im kidding. only a madman would do that, anyways. this would be very interesting if completed. figured I would share the idea.

[@TheSoft]

@GD Colon You are one of the Most underrated GD channels on YT

[@brandonohno8312]

I love the tag "typescript sucks" thats in the tags.

[@Archiver_Nova]

This man making the ENTIRE GAME in google, we have GD browser, the icon kit with some 2.2 stuf, and now the editor WHAT

[@blowfl]

Thanks for the useful information. 13:55

[@kidsmoq]

Thank you Colon, very cool. On a serious note, the streams were very cool and I had a really fun time. Also, are your streams uploaded on your YT channel or not? I have to see that Mario Paint stream, mainly the lego city part. Hmm? Oh no reason.

[@GDColon]

kzbin.info/aero/PLivEE7I7krsqoBJ3d_TlfFy_Cp6g_D9WK

[@kidsmoq]

@@GDColon I too have learned the ways of memorizing Rick Roll, thankfully this is not the link.

[@aingha213]

wait colon is actually really smart what. this is the first video ive seen from him in like months what 😭

[@jax3280]

*Good job!*

[@insertnicknamehere_]

She’s in love with the concept

[@gdcrazymister-crazyturkey9251]

The king has upload

[@iesty]

I was in a VC with you when you were doing it at one point :)

[@Yackalips]

Me seeing the beginning intro: this mans an absolute legend

[@TryNiceGT]

Colon’s face cam is on the floor lol btw your epic

[@souljynx]

me: I have to go to bed colon: *wanna make a spreadsheet*

[@elijah44gd79]

I wanna make a spreadsheet*

[@kviys]

this man could fix the bugs in 2.2 for robtop

[@cheeta320]

I love the dream intro lmao

[@geebs7275]

I didn't realize you where gonna upload a video until now but ok :D

[@astronix2719]

man i remember this just being released

[@TequilaFounder]

Alternative alternative title : colon making the gd editor into a spreadsheet.

[@anjrootrollface]

fresh cut, clean cut

[@marcelsyt]

I sadly wasn't able to watch this all live because it was midnight over here.

[@Amp64]

You should make more of these

[@thenewcg1x]

you are truly a big brain boi now

[@fratzentoaster]

0:22 damn, I love this