How convert XLS to RESX?

Question

I have an Excel file with translation and I must load a new language into the project.

How do I convert an XLS file to a RESX format?

There is [a tool](http://www.codeproject.com/Articles/19461/RESX-to-XLS-conversion-for-multi-language-support) achieving this. — Chris Li, Jun 21 '12 at 07:35

score 12 · Answer 1 · answered Jan 17 '14 at 18:35

12

In Visual Studio 2012, this is just as easy as selecting the excel columns to be copied over and just pasting them into resx interface that VS 2012 provides.

It works the other way around too. You could just create an xls file off of the resx by just select/copying the content from resx over into an excel document. enter image description here

answered Jan 17 '14 at 18:35

Zahra

6,798
9
51
76

I've had an issue with pasting from the resx UI into Excel, where text that was valid in the RESX got seriously messed up in Excel. I seem to remember it was a CRLF in one of the columns followed some time later by a double quote. Excel then just missed out 50 rows until it found another quote. The details are woolly now, but beware. – Greg Woods Sep 26 '21 at 14:42

score 0 · Answer 2 · edited May 23 '17 at 10:29

0

Did you check that topic ?

Convert CSV file or Excel spreadsheet to RESX File

I think they are giving good links:

http://blog.lavablast.com/post/2008/02/RESX-file-Web-Editor.aspx

A tool: http://www.codeproject.com/Articles/16068/Zeta-Resource-Editor

edited May 23 '17 at 10:29

Community

1
1

answered Aug 02 '12 at 20:28

Dekx

402
2
15

score 0 · Answer 3 · answered Sep 02 '13 at 13:22

0

This is a free tool that exports resx to xls and imports xls back to resx. But you should have first exported to xls via this tool: http://www.winking.be/resource-translation-helper

answered Sep 02 '13 at 13:22

juFo

17,849
10
105
142

score -1 · Answer 4 · edited Oct 29 '14 at 09:29

-1

You cant try to use this Visual Studio extension https://visualstudiogallery.msdn.microsoft.com/2676967b-0516-4f5f-b312-6873e2f9d219.
It allows to export/import your project resources to/from excel and to add new cultures.

edited Oct 29 '14 at 09:29

Rajesh Loganathan

11,129
4
78
90

answered Oct 29 '14 at 08:37

esolCrusador

11
1

How convert XLS to RESX?

4 Answers4