I only have Excel 2003 – but we have an “add-on” to our excel that allows us to simply walk through the options: Data, Transfer Data to iSeries etc.
From an AS400 session you can also select: Actions, Send file to Host, then browse for the PC file you want to use and it will build the transfer for you.
Hope this helps.
Not pretty but this will work.
Open it in Excel
Select File Save As
Select a type that you can transfer