#-----------------------------------------------------------------------------------------------
#NOTES TO TRANSLATORS:

Excel is not mandatory for editing csv files. Opening a file in a text editor and saving with CSV extension (.csv) can be the best way! 

1) '%s' is for indicating where another string is inserted, and MAY NEVER BE REMOVED! If there are more than one '%s' in a string, they may NOT CHANGE PLACES.
2) '%d' is for indicating where another integer value is inserted, and MAY NEVER BE REMOVED! If there are more than one '%d' in a string, they may not change places. ('%.1f' is used in exactly the same way but for non-integer values – '%s%d' is often used for values that are displayed with a '+' or '-' sign in front, DO NOT CHANGE, ADD, OR REMOVE!)
3) '%t' is for indicating where the player's 'title' is inserted, however only in game message boxes.
4) '\%' is for displaying '%' (percentage sign). To NOT be used with with other % controls in the same entry.
5) The characters '#' (hashmark), semicolon, '%' (percentage sign), '§' (paragraph sign), quotation marks and '\' (backslash) MAY NOT BE USED (except when used as control codes – this will otherwise create serious problems!!! Quotation marks may not even be used in comments -- use a 'citation mark' (single) instead if necessary!)
6) A dollar sign, '$' will always automatically be replaced by the 'ducats' icon.
7) Any row with a '#' in the first column (column 'A') will be ignored. However, you cannot use any paragraph characters in these rows!!!
8) To insert a carriage return, insert a '\n' (backslash + n)
9) No formatting can be done in this file. To change the color of a text, insert the following codes in front of the word:
  §W = info entry in the interface colors DB file
  §Y = standard entry in the interface colors DB file
  %RGB = rgb color with R, G and B from index 0 => 0 x 32 = 0 to index 7 => 7 x 32 = 224
Note that the color change will be applied to all words after the code, until the end of the line that the word is printed on. If several words should have a color change, put the code in front of each of them to be on the safe side. If only one word should have a color change, make sure to reset the color after the word.
10) Unless otherwise specifically stated, length of words and texts does not really matter THAT much except for tutorial and hints with no more than current max for English version (message boxes, rollover help boxes and buttons WILL stretch to fit the text string) – however you will notice once the translation is inserted that space IS limited in quite a few areas... so be brief, and try not to use words that are considerably longer than the english original.
11) ALL CELLS in column 'C' in each document MUST contain 'x' except lines beginning with '#'!
12) The LAST CELL in the 'A' column MUST contain the string '#EOF'
13) If you want to begin a string with a ' (citation mark), you will need to type it twice (Excel will read the first one as a commentary which is not exported into the actual text database file)
14) LANGUAGE entry is for the name in ENGLISH of the used language for all the csv text files.
15) DATE_FORMAT entry is for the date format related to the used language. <day>, <month> and <year> are for indicating where day, month and year are inserted respectively, and MAY NEVER BE REMOVED NOR TRANSLATED! However, they may change places.

WHEN DONE: save as 'Semicolon Separated (.csv)' format.
It should be saved in ANSI (cp1252) encoding, NOT UTF-8 or UTF-16.

NOTE: If Excel complains about an 'Error in formula' when the cell content begins with a '+' or '-' sign, type a ' (citation mark) in front of the plus or minus.

#-----------------------------------------------------------------------------------------------

Localization files are loaded in the following order:
interface.csv
countries.csv
geography.csv
provinces.csv
cultures.csv
terrains.csv
goods.csv
technologies.csv
religions.csv
scenarios.csv
rebels.csv
events.csv
decisions.csv
triggers.csv
addendum.csv #NOTE: As of 1.3 this file is now considered obsolete in vanilla, but may still be used in mods.
misc.csv
1.3.csv

If a key is present more than once (even in different files), the last entry will take precedence.

If a mod is active, it may override any of these files. However, it is recommended to put new text into misc.csv, since the vanilla misc.csv is always only a placeholder; all other files are subject to change in patches.
