Unstructured Text
Title Case Converter
Capitalise the important words in a heading while keeping short words such as “and”, “of” and “the” in lowercase.
When to use it
Typical uses: Formatting blog post titles and headings; Tidying book, film and song titles; Standardising product names and menu items.
In a pipeline
Text InputTitle Case ConverterText Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Text column | select | — | Text |
| Generate New Column | checkbox | — | false |
| New Column Name | text | — | Default: <column> Result |
| Insert After | select | — | After the column |
| When a value cannot be converted | select | — | stop |
Example
Title Case Converter: an example
| Text |
|---|
| the lord of the rings: the return of the king A GUIDE TO WRITING FOR THE WEB |
| Text |
|---|
| The Lord of the Rings: The Return of the King A Guide to Writing for the Web |
Worth knowing
- Which words stay lowercase? Articles (a, an, the), short conjunctions (and, but, or, nor) and short prepositions (as, at, by, for, from, in, into, of, on, per, to, via, with), unless they are the first or last word.
- What happens to acronyms like NASA? The text is lowercased before capitalising, so acronyms become “Nasa”. Correct them by hand afterwards.
- Is title case the same as capitalising every word? Not quite. Capitalising every word is sometimes called start case. Title case keeps minor words lowercase, which most style guides prefer.
- Works on any text column, not only Text Input's: pick it under Text column. Tick Generate New Column to keep the original next to the result.