Here’s how you can import strings from a spreadsheet into the Localization Editor. .xlsx and .xls Excel formats and Google Sheets are supported.
Import Google Spreadsheet
Choose “Import Google Spreadsheet” in the Window→Localization Editor→Import Spreadsheet Menu. If you have already authenticated with Google, go to Step #5.
Choose “Go to Google Authenticate URL.” The google authenticate prompt should open in your browser.
Grant Access to Localization Editor. The google authenticate will ask you to grant access to your files. Click Accept to continue the authentication process.
Copy the access code from your browser and paste it into Set LE Access Code window.
Select the Spreadsheet to Import and click “Download”
Import Local Spreadsheet
Choose “Import Local File” in the Window→Localization Editor→Import Spreadsheet Menu.
Browse to the spreadsheet on your harddrive or local network and click “Import”