How to change language on excel
You can find the official 2-character language codes (subtags) here. When you are done, make sure you didn’t skip any questions (for every field that has text inside the label column there should be text inside the label::language (code) column). Now add your translations for every row inside the label::language (code) column. Then, if you have hints in your form, the same needs to apply to the hint column, for example hint::Français (fr) or hint::English (en). You can change the size of your columns, add colors or change the font size, none of these will affect your form. In the header (first row) of this new column, write label::language (code), for example label::Français (fr) or label::English (en). Insert another column to the right of label.
This is where your original question labels are stored. Stay in the survey sheet for now.įind the column called label. See here.) Your spreadsheet will have three sheets (see the little tabs at the bottom): survey, choices, settings. Open the file in Excel (Google Spreadsheet, Open Office Calc, etc will all work) (If you’re in Excel it’s possible you have to take the file out of Protected View first. You’ll be returned to the draft form’s project dashboard. When you are done, or when a portion of the form has been created, save it. This should be the language that the person responsible for designing the questionnaire is most comfortable with. Here are detailed instructions on how you can add another language to your form:Ĭreate your form in the default language. You can either add and manage them directly through the online Project Dashboard or you can add them in an XLSForm and upload it to KoBo. There are two methods to adding multiple languages to your form.
Adding Another Language to your XLSForm ¶