Importing Data for Tabular Mapping
Importing data from an existing file is a much faster way to enter large sets of data into tabular mapping. First export the data from a two-column Excel spreadsheet into the tab-delimited Format by choosing the File -> Save as… option in Excel and selecting the ‘Tab Delimited Text (txt)’ file format for importing.
In the eiConsole Data Mapper, create a tabular mapping. (See Tutorial.) In the Tabular code mapping dialog click on the ‘Import’ button (marked with a file folder icon). Then choose which file to open and the mapping will be automatically populated with the file data.