Create lookuptable structure same as your input file. Loop input file and use lookuptable addrecord method.

For excel you can use export data and lookuptable replacetable method.

I like to load my lookup table in code to start with and then save it as Xml.  After that I can hand edit the Xml and reload the table whenever I want.  I do it like this: