Guide

Free translation glossary template for manga and webtoon series

A translation glossary for a comic series is a two-language list of every name, term and recurring phrase, with one approved target form each. This template is a CSV file with nine columns: source, target, rule, type, note, first chapter, status, added by and date. It opens in Excel and Google Sheets, and keeps Korean, Japanese and Chinese text readable.

Table of contents
  1. What are the columns in the template?
  2. How do you open the CSV without broken characters?
  3. How should a team work with the glossary?
  4. What belongs in a comic glossary that a book glossary does not have?
  5. How do you use the glossary in Bublate?

This page explains the columns of the template, how to open it without broken characters, and how to keep it in step with a translation team and with Bublate. For the people side of a series (voice, registers, who calls whom what), use the series bible template.

What are the columns in the template?

ColumnWhat goes in itExample
sourceThe term as written in the source, in its own script각성자
targetThe one approved target form. Empty while the term is openAwakener
rulealways (exact form every time) or prefer (default, other words allowed by scene)always
typename, place, group, term, phrase, sound effectterm
noteMeaning, plural, capitals, forms to avoidpeople with powers, never "esper"
first_chapterWhere the term first appears1
statusopen (under discussion) or approvedapproved
added_byRole or name of the person who added the rowtranslator
dateWhen the row last changed, YYYY-MM-DD2026-11-20

The file holds three example rows. Delete them before you start. The column names are in English and in lower case so that scripts and CAT tools can map them without spaces.

How do you open the CSV without broken characters?

  • Excel. The file starts with a UTF-8 byte order mark, so it opens with a double-click and Hangul, kana and hanzi stay readable. Microsoft explains that a UTF-8 CSV without the mark needs Data, Get Data, From file, From Text/CSV. When you save, pick CSV UTF-8 (Comma delimited).
  • Google Sheets. File, Import, upload the file. Sheets imports .csv, .tsv and .xlsx files.
  • By hand. A field with a comma, a quote or a line break sits in double quotes, and a quote inside a field is written twice (RFC 4180). The notes in the example rows show this.

How should a team work with the glossary?

  1. One owner. The lead translator or the editor approves rows. Others add rows with status open.
  2. Add the row in the same pass as the chapter. A term that appears in chapter 12 gets its row while chapter 12 is translated, with first_chapter 12.
  3. Search before you add. Filter the source column for the term and for its variants. Korean and Japanese often write one thing in two ways (a full name and a short form, kanji and kana).
  4. Never change an approved row silently. Change the target, the date and the note ("was Esper until chapter 20"), then fix the back chapters or accept the break on purpose.
  5. Run the check. Before release, a quality check searches the chapter for each approved source term and confirms the target form.

What belongs in a comic glossary that a book glossary does not have?

Comics repeat short, loud words. Three row types are worth adding that most book glossaries skip:

  • Recurring sound effects. A footstep or a heartbeat that the series uses in every chapter should get one target word, so the letterer does not invent a new one each time. See the Korean and Japanese sound effect dictionaries for meanings.
  • Attack and skill names. They often appear in large display lettering, so a change costs a redraw, not a retype.
  • Address terms used as names. Hyung, sunbae, -nim or senpai, if the house rule keeps them. The policy lives in the series bible. The glossary records the exact spelling and hyphen.

How do you use the glossary in Bublate?

The glossary section of the series bible in Bublate has the same core fields: source, target, rule (always or prefer) and note. To bring a sheet in, open Series bible, click Import and paste the rows. Bublate reads them, fills the glossary, and saves nothing until you click Save. From then on every chapter in that series and language follows the rules, and the Bible tab lists the lines of the open chapter that use each term.

Lines a person corrected after a chapter is done also go into Bublate's translation memory, which reuses an exact match in later chapters. That covers repeated sentences. The glossary covers words. For fonts and balloon rules, use the lettering style sheet template.

Frequently asked questions

What columns should a translation glossary have?

At least the source term, the approved target term and a note. For a long series also add a rule (always or prefer), a type (name, place, term, phrase, sound effect), the first chapter where the term appears, a status (open or approved), who added it and when. This template has all nine.

Why does Korean or Japanese text look broken when I open the CSV in Excel?

Excel reads a CSV in the local code page unless the file starts with a byte order mark. Microsoft says a UTF-8 CSV saved with the mark opens normally. This template has the mark. If you save a copy yourself, choose CSV UTF-8, or import it through Data, Get Data, From Text/CSV.

Should names go in the glossary or the series bible?

Both work if the team picks one place. Many teams keep names and places in the glossary, because they are one-to-one spellings, and keep people (voice, age, how they address others) in the series bible. The type column lets you filter names from terms in one sheet.

What does the rule column mean?

Always means use exactly the target form every time, for example a rank or a power system. Prefer means use it by default but allow another word when the scene needs it, for example slang. The series bible in Bublate uses the same two rules.

Can I use this glossary in a CAT tool?

Yes, most CAT tools import a CSV with a source and a target column. Map the source and target columns and keep the note as a description. For a tool that wants the TBX standard, convert the file with that tool, because TBX is an XML format defined by ISO 30042.

Sources

  1. RFC 4180, Common Format and MIME Type for CSV Files (quoting and line ends) · checked
  2. Microsoft Support, Opening CSV UTF-8 files correctly in Excel · checked
  3. Google Docs Editors Help, Import data sets and spreadsheets (file types) · checked
  4. TBXinfo, TermBase eXchange (TBX) and ISO 30042 · checked

Try Bublate for free

Continue with Google

or