Conlang is an abbreviated term for Constructed Language, essentially a made up language. Constructed languages are used in a lot of media to give a certain feeling to a setting, race, etc. You can see examples in the names and place names of your favorite RPG fantasy race or alien. Done right they’re ridiculously complex, take many factors into consideration and require a large time investment. That’s why some Conlang professionals make the big bucks. This is not an article about doing conlang right. That’s well beyond my expertise. This is instead an article about making a quick and dirty conlang generator based on a seed from an existing language so you can effortlessly name every guardsman, tavern, ceremonial birthing spear, whatever that your players pester you about.

I attempted to make such a generator for a game recently and found that they’re fairly easy to construct with Google Sheets. Other spreadsheet programs will work fine as well if you have them, but the logic will be slightly different.

To start with you’ll need to put your word list in a page on your Google Sheet. Just for fun, we’ll base this conlang on the names of the cast of Jersey Shore. I’ve chosen to ignore the difference between first, middle and last names and to count the dash in Ortiz-Magro as a name so it shows up in our final results. Once you have them listed, break them up by first, last, and middle syllables like so:


Once your root words are broken down by syllables, use the =counta() function to count the number of cells with values in each syllable column. Put these above the root words to make it easy to add more roots later if you want to.


From there, use a formula to subtract the count of column 2 from column 1’s count etc… This will give us an estimate of the proportion of words that have each number of syllables.


Here we can see on Planet J-Shore that around half of names have 2 syllables, around a 6th have 1, 3, or 4, and ~4% have 5.

Next add another row with cumulative syllable count like so:


The next step is to build lookup tables for our syllables. It’s easiest to do this on a new sheet. The plus sign in the lower left will make new sheets. You can re-name your sheets with the drop down arrow on the sheet tab.


Copy-Paste your syllables into columns on this new sheet. Put ALL middle syllable columns into one column here. You can get rid of extra spaces by selecting a column, then from the menu choosing Data>Sort Range picking “has header” and sort. Add a table of numbers just like you were making a table to roll on. (which is what we’re doing) Don’t worry that you have an odd number of syllables.


Create a new sheet for the actual generator. Put in a column for the number of syllables in each random word, one column for each potential syllable (in our case 5) and a final column for the constructed word like so:


In the syllables column add the following formula to each cell:


The fractions in the brackets are the values from the cumulative syllable row from our first sheet. This code creates a random number of syllables based on our observed number of syllables in our seed words.


The contents of the 1st, mid and last syllable columns is all slightly different, but similar to this:


“$A2>2” checks how many syllables the word has. I’m assuming that syllables get added in order of first, last, mid1, mid2, mid3.

“randbetween(1,17)” is the possible “rolls” on the table.

“Tables!G$2:G$18,Tables!H$2:H$18” is the sheet “Tables” and cell range for the “roll number” and result for that syllable type.

Here’s the code for each column in order:






The final column has the code:


which just sticks together all the  pieces.


You can hide the first columns if you just want the output list, but I find them useful as a pronunciation guide. I might tweak this generator if I were going to use it by dumping the “-“ syllable, adding some more seeds, and assembling the individual name results into one to three name groups (nickname, first last, first middle last, and first last-last) but for the 15 minutes it takes to put together it does it’s job well enough.

You can view the final sheet here. Feel free to copy, tweak, and put in your own seeds for your own projects.