1 Reply Latest reply on Sep 18, 2010 3:39 AM by Kasyan Servetsky

    Export/Import Text from Excel to InDesign using XML

    mzKawen


      Hi there! I just want to ask if this is possible in InDesign. Is it possible to create all XML flags/tags needed which would allow me to export/import all the text in one action (ideally thru Excel).


      Appreciate your help on this. Thanks!

        • 1. Re: Export/Import Text from Excel to InDesign using XML
          Kasyan Servetsky Level 5

           

          You can export data from Excel as XML file, then transform it (e.g. change the order of XML elements) either manually, for example in Notepad, or automatically on importing the XML file into an InDesign document by applying an XSLT.

          If the data in Excel file changes, you can repeat the process again -- the formatting of text in InDesign document will not change after you update the data (only contents will change). You can also export XML files from other applications: all date base applications such as Access (PC) or FileMaker Pro (Mac), Word, etc.

          I haven't tried to export XML file from InDesign and then import it into Excel, but I am sure this is possible as well.

           

          If you are interested, check out this book and this tutorial for detailed information.

           

           

          Kasyan