Google Spreadsheet import fails for my project

I have created a spreadsheet for multiple languages using the local import CSV function and the export/merge Google spreadsheet function.

The spreadsheet looks good, the left column has all the keys and the other column all have a translation (15 in total)

I wanted to try to import all languages from the spreadsheet and when I did (Google spreadsheet import->Replace) only one language was imported (the last language in the sheet, wioth the language code of the first language in the sheet)

No error messages were shown.

Thanks for your quick reply.

I have sent you the google spreadsheet as I don't have a CSV file.
I checked the filter and it was set to default. When I set it to 'everything' the filter text still shows default.

When I import a single language using a CSV file and then set the language code for the language, then the language text field is not updated. The text for the language is 'source'.
Then I exported/merged the language with the google spreadsheet resulting in a language key 'source [LANGUAGE CODE]'
I did this for all languages that I needed,
I figured out that importing the spreadsheet works when I replace all the 'source [LANGUAGE CODE]' keys in the spreadsheet with the correct language name as shown when adding a language.

Some remaining import issues:
Arabic (Arabic) is imported but gets the wrong language code ar-DZ
Russian (Russian) is imported but gets the wrong language code ru-MO.
Chinese (Traditional) is skipped, I don't know why.

There is no standard language option for English (en)
There is no standard language option for Portuguese (pt)

Hi,

I sent the spreadsheet to This email address is being protected from spambots. You need JavaScript enabled to view it..
I have just sent a csv file to the same e-mail address.

Thanks,
Marcel