{"id":8853,"date":"2022-05-03T21:55:56","date_gmt":"2022-05-03T21:55:56","guid":{"rendered":"https:\/\/max-drake.cc\/?p=8853"},"modified":"2022-05-04T01:49:05","modified_gmt":"2022-05-04T01:49:05","slug":"alternate-language-subtitles-for-youtube-videos","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=8853","title":{"rendered":"Alternate Language Subtitles for YouTube  videos"},"content":{"rendered":"\n<p>I am writing a post on translating the first  eBook into Chinese and so started to use the auto-generated English Subtitles from the YouTube Shorts videos and downloaded the timed captions text in .sbv format, that I pasted into  a Google Spreadsheet and used formula <strong>=GoogleTranslate (Text, Source language, Destination language) <\/strong>and setup a <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1WpSG8v_MeC2gihaJCGED_VAmV_2Hw8E0BhZ_p9Ob8vs\/edit#gid=0\" class=\"su-button su-button-style-glass\" style=\"color:#FFFFFF;background-color:#428bca;border-color:#3570a2;border-radius:6px\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"color:#FFFFFF;padding:0px 18px;font-size:14px;line-height:28px;border-color:#7baeda;border-radius:6px;text-shadow:none\"> Spreadsheet<\/span><\/a> to do this. <\/p>\n\n\n\n<p>I was pleased with the result and was able to quickly, through a multi-step process create timed translations that I could upload into the video. <\/p>\n\n\n\n<p>I would add a new language (Chinese) then download the english  transcript and open it in Notepad++ and then paste it in the Google Sheets spreadsheet where the lines would auto translate, then I&#8217;d take the column with timestamps and translated text &amp; paste it back into Notepad++, where I would save the file and then upload that file for the new language I&#8217;d created in YouTube Studio in contents section. <\/p>\n\n\n\n<p>Not a particularly onerous process but long and slightly tedious, so I&#8217;d do it in batches. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"968\" height=\"1024\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-968x1024.jpg\" alt=\"\" class=\"wp-image-8855 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-968x1024.jpg 968w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-284x300.jpg 284w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-768x813.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-1452x1536.jpg 1452w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-50x53.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-47x50.jpg 47w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-100x106.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-95x100.jpg 95w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-605x640.jpg 605w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-640x677.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-726x768.jpg 726w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-1024x1084.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-1021x1080.jpg 1021w, https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings.jpg 1480w\" data-sizes=\"(max-width: 968px) 100vw, 968px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 968px; --smush-placeholder-aspect-ratio: 968\/1024;\" \/><\/figure>\n\n\n\n<p>I looked at the numbers and there are 64 videos 62 YouTube Shorts to add languages to:<\/p>\n\n\n\n<p>Dutch French German Indonesian Italian Japanese Korean Portuguese Spanish Vietnamese Turkish Arabic Swahili Khmer, I already have Chinese. <\/p>\n\n\n\n<p>It was taking, on average about 3 minutes to add the 14 languages to a YouTube Shorts video. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Easier method in YouTube  <\/h4>\n\n\n\n<p>I then thought I&#8217;d do a bit of research (belatedly) and found that there is a method to auto-create the translations. It will not do it with YouTube auto-generated subtitles, but you can download that file and upload it again and then it will do the auto-generation into the languages of your choice. <\/p>\n\n\n\n<div class=\"su-youtube su-u-responsive-media-yes\"><iframe width=\"600\" height=\"400\" data-src=\"https:\/\/www.youtube.com\/embed\/JKo86Yogg6c?\" frameborder=\"0\" allowfullscreen allow=\"autoplay; encrypted-media; picture-in-picture\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/div>\n\n\n\n<h4 class=\"wp-block-heading\">C for captions <\/h4>\n\n\n\n<p>Another thing I learned from I think the video above , if you are watching a YouTube video and type &#8216;C&#8217; then captions will be turned on. I texted that to Zoe, it may help with her video watching. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">End Comment<\/h3>\n\n\n\n<p>A bit of a Duh!!! moment.  can now add lots of languages to subtitles a lot more quickly than the original method. I&#8217;ll do it for all of the texts <\/p>\n\n\n\n<p>Putting subtitles in videos is quite easy, getting the Manuscript translated is a single upload in Google Translate using the document button, where my concern is at the moment is in doing the comments in the script and the diagrams. I&#8217;ve yet to figure a method for doing this with all the scripts in the text.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am writing a post on translating the first eBook into Chinese and so started to use the auto-generated English Subtitles from the YouTube Shorts videos and downloaded the timed captions text in .sbv format, that I pasted into a Google Spreadsheet and used formula =GoogleTranslate (Text, Source language, Destination language) and setup a to [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":8855,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[204,28],"tags":[],"class_list":["post-8853","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-automation","category-video"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-600x400.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2022\/05\/2022-05-04-09_44_29-Settings-600x600.jpg","author_info":{"display_name":"max drake","author_link":"https:\/\/max-drake.cc\/?author=4"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/8853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8853"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/8853\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/8855"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}