<p>It all comes down to preference, as long as the spreadsheets are neat and easy to read. Looking for other alternatives beyond spreadsheets is also a viable option. As an example, I used a bit of programming knowledge to take the data from my spreadsheets and represent them in a format that resembles old dictionaries. (That might not be for everyone, caffeine overdose is real :)</p>

CC BY-SA 4.0
2023-01-25T00:43:18.713Z
Thanks, Paul. I reckon that dictionary-look adds a bit of flavor and verisimilitude for you.
Vir
CC BY-SA 4.0
2023-01-26T01:04:42.887Z
It gives the lexicon a professional look that just makes it a lot easier to find motivation to work on (it's also a lot easier and more intuitive to use, so that's a plus)
just Paul
CC BY-SA 4.0
2023-01-24T05:41:12.557Z
2023-01-24T05:41:12.557Z
just Paul
<p>Although I've never tried it, it seems like a data structure other than a spreadsheet (a database of some form) would be more suited to the complex relationships between lexemes and definitions.</p>
<p>If presented sequentially, it seems like ordering the lexicon according to its writing system (&quot;alphabetical order&quot;) is the only really workable method. Trying to order by meaning ignores just how messy meaning can be and doesn't account for figures of speech or semantic shifts.</p>

CC BY-SA 4.0
2023-02-10T12:51:08.590Z
You could also sort by the Romanization. That's what I do because a) I can't be bothered to remember the order of the Atili alphabet and b) I only rarely care how a word is actually spelled in Atili.
OpenAI was the last straw
CC BY-SA 4.0
2023-02-01T16:24:19.250Z
2023-02-01T16:24:19.250Z
Theodore
<p>I'll throw my hat in on the main best practices I have, anyway.</p>
<p><strong>In my view, the number one best practice in assembling a conlang lexicon must be:</strong></p>
<ul>
<li><strong>Get familiar with whatever filters, advanced find &amp; replace, slicers, conditional formatting, grouping, sorting, and other organizational tools your medium has. 10 minutes per day for a week asking, &quot;What does the next menu option do?&quot; may save you days of tedious manual searching/organizing over time. I have learned new spreadsheet features and functions while conlanging that I could use elsewhere, too.</strong></li>
</ul>
<p>Here I discuss an &quot;alphabetically&quot; organized google sheet, with the advantage it can expand indefinitely and organize numerous nuances.</p>
<p>The conlang-guiding spreadsheets @Ylahris made, <a href="https://conlang.meta.stackexchange.com/questions/212/i-created-a-spreadsheet-to-help-catalyze-and-organise-the-conlang-process">Der Spracherfinder</a>, has a theme-based starter words lexicon template. This could have the advantage over my suggestions if you're aiming to showcase relatively fewer words, or looking for prompts to get started.</p>
<ul>
<li><a href="https://docs.google.com/spreadsheets/d/1c2cDczkZcrA2nZa4FjpNhhkn7QYn_3o6OZpN8YQA11M/edit?usp=sharing" rel="nofollow noreferrer">Here's a simple template with a bit of nonsense to give the idea.</a></li>
</ul>
<p><strong>Notes on the template</strong></p>
<p>Why not just write all the parts of speech a word can do in one cell?</p>
<ul>
<li>So that I can more easily find or organize patterns/exceptions, I have definition columns for different parts of speech and different transitivity situations (to shoot, to shoot it, to shoot at it).</li>
</ul>
<p>What's the benefit of the Type column? Why start with the filter there?</p>
<ul>
<li>I sometimes want to deal with or look among all words of a type. I could name quite a few more of these tags which I have found useful. But in short this tagging system saves me a lot of time and a lot of &quot;I have fixed all the ones I could find. But could I be missing some?&quot;</li>
</ul>
<p>Why are certain cells colored in the template?</p>
<ul>
<li>Conditional formatting can help color-code certain patterns automatically. Here, I have it highlighting duplicate/homograph words and certain tags.</li>
</ul>
<p>What is the advantage of the +/- at left?</p>
<ul>
<li>When you have dozens or hundreds of words starting with each letter, the collapsible grouping saves a lot of time scrolling, either when initially alphabetizing and/or editing words. Sometimes you want to Ctrl+F search only certain letter sections, too.</li>
</ul>
<p>What do I need the top &quot;?&quot; sections for?</p>
<ul>
<li><p>Often times working on thing A brings thing B to my attention. If I can make a note and place to put it in an &quot;under construction&quot; section at the top, I can follow through thing A without forgetting thing B.</p>
</li>
<li><p>Sometimes I'm on a roll thinking up good-sounding words. It's not always when I'm on a row thinking analytically and defining new concepts/grammatical approaches for the same words. While I am on the aesthetic roll, having a separate workshop section for extra &quot;sounds good, needs definition&quot; words can save time and improve both goals over all.</p>
</li>
</ul>

CC BY-SA 4.0
2023-02-20T07:16:50.557Z
2023-02-20T07:16:50.557Z
Vir
<p>Organizing a lexicon when it gets greater than 100 words is a problem. I tried text files, Markdown, and spreadsheets but they all seem to get harder to work with as the lexicon grows. I am working on the following hierarchy which may be implemented in a database. Note that each level may have more than one entry for the entry above.</p>
<ol>
<li>word</li>
<li>etymology</li>
<li>pronunciation</li>
<li>part of speech</li>
<li>definition</li>
<li>example</li>
<li>gloss</li>
</ol>

CC BY-SA 4.0
2023-03-04T19:10:58.020Z
2023-03-04T19:10:58.020Z
shawnhcorey
<p>Mine has evolved over years and I'm sure I can still learn more about how to organize it. This might be an even more helpful question for folks starting out.</p>

<conlang-creation><conlang-documentation>
Are there best practices for creating a lexicon or dictionary spreadsheet?
# Are there best practices for creating a lexicon or dictionary spreadsheet?

(Asked by: username_0 on 2023-01-01)

Mine has evolved over years and I'm sure I can still learn more about how to organize it. This might be an even more helpful question for folks starting out.

**Tags:** conlang-creation, conlang-documentation


---

## 4 answers

### Answer by username_1 on 2023-01-24. Score: 2

It all comes down to preference, as long as the spreadsheets are neat and easy to read. Looking for other alternatives beyond spreadsheets is also a viable option. As an example, I used a bit of programming knowledge to take the data from my spreadsheets and represent them in a format that resembles old dictionaries. (That might not be for everyone, caffeine overdose is real :)

> **Comments:**
> **username_0**: Thanks, username_1. I reckon that dictionary-look adds a bit of flavor and verisimilitude for you.  
> **username_1**: It gives the lexicon a professional look that username_1 makes it a lot easier to find motivation to work on (it's also a lot easier and more intuitive to use, so that's a plus)  

---

### Answer by username_2 on 2023-02-01. Score: 1

Although I've never tried it, it seems like a data structure other than a spreadsheet (a database of some form) would be more suited to the complex relationships between lexemes and definitions.

If presented sequentially, it seems like ordering the lexicon according to its writing system ("alphabetical order") is the only really workable method. Trying to order by meaning ignores username_1 how messy meaning can be and doesn't account for figures of speech or semantic shifts.

> **Comments:**
> **username_3**: You could also sort by the Romanization. That's what I do because a) I can't be bothered to remember the order of the Atili alphabet and b) I only rarely care how a word is actually spelled in Atili.  

---

### Answer by username_0 on 2023-02-20. Score: 1

I'll throw my hat in on the main best practices I have, anyway.

**In my view, the number one best practice in assembling a conlang lexicon must be:**

* **Get familiar with whatever filters, advanced find & replace, slicers, conditional formatting, grouping, sorting, and other organizational tools your medium has. 10 minutes per day for a week asking, "What does the next menu option do?" may save you days of tedious manual searching/organizing over time. I have learned new spreadsheet features and functions while conlanging that I could use elsewhere, too.**

Here I discuss an "alphabetically" organized google sheet, with the advantage it can expand indefinitely and organize numerous nuances.

The conlang-guiding spreadsheets @Ylahris made, [Der Spracherfinder](https://conlang.meta.stackexchange.com/questions/212/i-created-a-spreadsheet-to-help-catalyze-and-organise-the-conlang-process), has a theme-based starter words lexicon template. This could have the advantage over my suggestions if you're aiming to showcase relatively fewer words, or looking for prompts to get started.

* [Here's a simple template with a bit of nonsense to give the idea.](https://docs.google.com/spreadsheets/d/1c2cDczkZcrA2nZa4FjpNhhkn7QYn_3o6OZpN8YQA11M/edit?usp=sharing)

**Notes on the template**

Why not username_1 write all the parts of speech a word can do in one cell?

* So that I can more easily find or organize patterns/exceptions, I have definition columns for different parts of speech and different transitivity situations (to shoot, to shoot it, to shoot at it).

What's the benefit of the Type column? Why start with the filter there?

* I sometimes want to deal with or look among all words of a type. I could name quite a few more of these tags which I have found useful. But in short this tagging system saves me a lot of time and a lot of "I have fixed all the ones I could find. But could I be missing some?"

Why are certain cells colored in the template?

* Conditional formatting can help color-code certain patterns automatically. Here, I have it highlighting duplicate/homograph words and certain tags.

What is the advantage of the +/- at left?

* When you have dozens or hundreds of words starting with each letter, the collapsible grouping saves a lot of time scrolling, either when initially alphabetizing and/or editing words. Sometimes you want to Ctrl+F search only certain letter sections, too.

What do I need the top "?" sections for?

* Often times working on thing A brings thing B to my attention. If I can make a note and place to put it in an "under construction" section at the top, I can follow through thing A without forgetting thing B.
* Sometimes I'm on a roll thinking up good-sounding words. It's not always when I'm on a row thinking analytically and defining new concepts/grammatical approaches for the same words. While I am on the aesthetic roll, having a separate workshop section for extra "sounds good, needs definition" words can save time and improve both goals over all.


---

### Answer by username_4 on 2023-03-04. Score: 0

Organizing a lexicon when it gets greater than 100 words is a problem. I tried text files, Markdown, and spreadsheets but they all seem to get harder to work with as the lexicon grows. I am working on the following hierarchy which may be implemented in a database. Note that each level may have more than one entry for the entry above.

1. word
2. etymology
3. pronunciation
4. part of speech
5. definition
6. example
7. gloss


---

