Copy Text Between Excel and the Developer Tool
Effective in version 10.1, you can copy text from Excel to the Developer tool or from the Developer tool to Excel. Copy text from Excel to the Developer tool to provide metadata for transformations. For example, you have designed a mapping in Excel that includes all transformations, their port names, data types, and transformation logic. In the Developer tool, you can copy the fields from Excel into the ports of empty transformations. Similarly, you can copy transformation ports from the Developer tool into Excel.