6 Replies Latest reply on May 12, 2016 12:47 AM by agopaul

    InDesign to Excel - Export & Import Utility




      My wife is a freelance designer  & im a software developer. We worked together on one of her freelance assignments which involved transcreation of indesign document in variuous languages.


      I wrote software which would export all the text content from indesign idml file to excel sheet. Any one can edit these excel sheets & software will be able to merge it back and create new idml file from it. Basically its easier to export and import text back in to idml files.


      Heres use case : Take idml file , export all text content to excel sheet with just click of a button and send it to translators/proofreaders/editors. When they are done with it - simply merge it back in to original idml file within seconds (without graphic designer spending time on copy-n-pasting in to indesign file)


      I think this can reduce indesign text copy-n-paste job time by 90%


      I would like to know is there any market for such utility & would it make any sense to develop it any furthur.



        • 1. Re: InDesign to Excel - Export & Import Utility
          Rik Ramsay Level 4

          The export out of InDesign is interesting but would only really be useful if the multiple variances of text was an after-thought. If you knew in advance you were going to do this, you would set the file and work flow up diffently. As for the import, InDesign's built-in Data Merge does this.


          Someone with more knowledge on this might add to this but I believe InCopy is a close equivalent to what you have been doing. http://www.adobe.com/products/incopy/features.html

          • 2. Re: InDesign to Excel - Export & Import Utility
            Joel Cherney Level 5

            I don't mean to discourage you, but there is actually already a large and robust market for such tools. See SDL Trados, Kilgray memoQ, et cetera. I think that Rorohiko's StoryTweaker is the closest match to what you've done. I know few translators who prefer working in Excel over other applications - in fact I have a folder full of VBAs to move multilingual content out of Excel into Word and back, simply because the text-editing tools in Excel are pretty abysmally bad, at least from the perspectives of the translators I have asked about the matter.


            Besides, if you wanted to work in a tabular format, you'd already be using an app like Trados or SDLX or something like that.

            (without graphic designer spending time on copy-n-pasting in to indesign file)


            Actually, over the last fifteen years I've spent as a DTP wonk in the translation industry, I've found that graphic designers are pretty universally bad at this task. Each language has its own typographical conventions, and the graphic designers that recognize this fact are unfortunately quite rare. Furthermore, you only have to do one control-c alt-tab control-v job before you realize that there must be a better way to do it.


            Sorry to rain on your parade, but you're kind of reinventing the wheel here. That being said, the firms that have a lock on the Compuer-Aided Translation tools (CATs) or Translation Environment Tools (TEnTs) tend to have fairly high prices, even on their introductory toolsets. There may be some slack points in that market that I don't see. I'd suggest asking someplace else, like ProZ or Translator's Cafe, or places where InDesign expertise is less common.

            • 3. Re: InDesign to Excel - Export & Import Utility
              mpunaskar Level 1

              Joel & Rik


              Thanks for your replies.


              I will definately try asking in forums you mentioned.


              In any case its just 2 days programming work so not a big deal.

              • 4. Re: InDesign to Excel - Export & Import Utility

                Would you be willing to share this with me?

                • 5. Re: InDesign to Excel - Export & Import Utility

                  I'd highly interested in that solution, specifically for the XLS export (conversion of textual content into a database). Would you be willing to share it?

                  • 6. Re: InDesign to Excel - Export & Import Utility
                    agopaul Level 1

                    Like Joel said, there are a few tools that help translators on translating InDesign files.

                    The thing is, for a variety of reasons, not every company wants to let translators work directly on the IDML file with their tools and not every translator wants to work with IDML files anyway. Another thing to consider is that these software work with a lot of formats and sometimes are not 100% precise when it comes to InDesign files (eg. they strip kerning, tracking, soft-returns, InDesign special chars, etc.)


                    Also, I can tell from experience that some companies use their sales force or partners to translate their files and since almost none of them are professional translators, they don't use CAT tools.


                    These are some of the reasons why at Redokun we developed a platform specifically built for InDesign translation: https://redokun.com


                    The tool offers two options to translate the files:

                    • Export text from InDesign for later import through XLS or XLIFF files
                    • Invite the translators to work inside the easy-to-use integrated translation tool


                    Compared to an InDesign translation plugin, it also has additional features: it stores translation memories for later use and provides other features like document revisioning and pre-translation capabilities.