如何简便的update 很多query item

有一张表,里面有个列的值是: name_1 ..... name_500
想把它们更新为
name_1      name string 1
name_2     name string 2
.
.
.
name_500    name string 500

当然有很多解决方案,从网上转载一个我认为比较新颖的方法:

use the multilingual support features to do this.  If your model currently uses a single language (eg en), add a second language to the model (such as en-nz), then use the 'export language file' option.  This will create a text file with two columns of data - one for en and one for en-nz.

Edit the text file and replace all the names in the 'en' column with your meaningful names (or cut and paste the data from your existing excel file, making sure that the original names are in the en-nz column and the meaningful names are in the 'en' column.

Finally, import the language file, converting from en-nz to en, and all the item names should get updated in one hit.