{"id":934,"date":"2013-02-11T10:58:43","date_gmt":"2013-02-11T10:58:43","guid":{"rendered":"http:\/\/www.geoplanit.co.uk\/?p=934"},"modified":"2013-02-11T10:58:43","modified_gmt":"2013-02-11T10:58:43","slug":"translating-text-for-arcgis-google-translate-excel-a-quick-guide","status":"publish","type":"post","link":"https:\/\/www.geoplanit.co.uk\/?p=934","title":{"rendered":"Translating text for ArcGIS – Google Translate + Excel – A quick guide"},"content":{"rendered":"

This is a useful tip that has been pointed out to me by a colleague, so useful in fact I have to make sure I note it down somewhere. \u00a0 Until my idea is incorporated into ArcGIS<\/a>\u00a0this is a quick and dirty workaround for translating Arabic labels in ArcGIS.<\/p>\n

\"arcgis_arabic_translation\"<\/a>
Yes, but what does it mean?<\/figcaption><\/figure>\n

We have\u00a0received\u00a0some GIS data from a client, it’s landuse in a geodatabase with Arabic labels. \u00a0Trouble is our maps are needed in English! \u00a0 In the past we’ve tested the Microsoft translation tools (for office)<\/a> against Google’s online translate tool<\/a>\u00a0and found that Google does a much better translation.<\/p>\n

So how do we translate this large landuse table quickly and easily? \u00a0 Use Excel of course! \u00a0 Please note that this bullet point list assumes you know ArcGIS and Excel quite well<\/strong>, to instruct from a beginners point of view would be a bit to long winded for me.<\/p>\n

    \n
  1. First create a field name for the English Translation in ArcGIS<\/li>\n
  2. Open a new Excel document<\/li>\n
  3. Copy (using this method) the table from ArcGIS into Excel.<\/a><\/li>\n
  4. Create a PivotTable that lists the row labels (in this case Arabic Landuse)<\/li>\n
  5. Copy and paste this list out (so the text is static, you probably don’t have to)<\/li>\n
  6. Copy the Arabic text into the text box at translate.google.com<\/a>\n

    \"google_arabic_translation\"<\/a>
    Google Translate<\/figcaption><\/figure><\/li>\n
  7. Now Copy that English translation text list back adjacent to your Arabic landuse list into Excel\n

    \"excel_arabic_translation\"<\/a>
    Pasted back into Excel<\/figcaption><\/figure><\/li>\n
  8. Now you have to use some Excel magic, select the English and Arabic text and under the Formulas tab (in Excel 2007) define a name ( in this case I called it English Translate)<\/li>\n
  9. Once you have done this go to the English Landuse field name column and type in code like this “=VLOOKUP(E7,EnglishTranslate,2)”. \u00a0 E7 is the Arabic landuse in your original table in Excel, EnglishTranslate is that Name you defined above and the number 2 is the column number of the EnglishTranslate you need to use if matched.<\/li>\n
  10. Then click and drag copy this down your English translation field to check it works.<\/li>\n
  11. Now copy back this data into ArcGIS or Join\/Link it.<\/li>\n<\/ol>\n

    Well that’s it if you have any improvements\/questions\/suggestions please add them in the comments section below!<\/p>\n","protected":false},"excerpt":{"rendered":"

    This is a useful tip that has been pointed out to me by a colleague, so useful in fact I have to make sure I note it down somewhere. \u00a0 Until my idea is incorporated into ArcGIS\u00a0this is a quick and dirty workaround for translating Arabic labels in ArcGIS. We have\u00a0received\u00a0some GIS data from a […]<\/p>\n","protected":false},"author":161,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":"","footnotes":""},"categories":[226,12,13,64,32,54,6,142,9],"tags":[],"class_list":["post-934","post","type-post","status-publish","format-standard","category-arabic","category-arcgis","category-arcmap","category-esri","category-excel","category-tips","category-tools","category-tutorial","category-workflow"],"_links":{"self":[{"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/934","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=\/wp\/v2\/users\/161"}],"replies":[{"embeddable":true,"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=934"}],"version-history":[{"count":2,"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/934\/revisions"}],"predecessor-version":[{"id":939,"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/934\/revisions\/939"}],"wp:attachment":[{"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.geoplanit.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}