XLImport is a command line utility (generally run in a Command Prompt in Windows, or from a Batch File) which allows for completely automated, unattended importing of text files (tab delimited) into either an existing Excel spreadsheet or a new one.
XLImport essentially automates the process of manually using Excel to import an external text file. This can be a very powerful tool for users who need to repeatedly create spreadsheets from source text files, including when they want specific formatting for individual columns.
XLImport also is capable of specifying a Total function that builds a new row at the bottom of the data, and also to invoke Excel's SubTotal feature.
You can view the full usage (all options are described) for the current version at this page.
XLImport requires Microsoft Excel to be installed on the same PC. It has been tested on Windows 95+ and Excel 97 through 2010.
Incode Systems also offers these Excel utilities that you may find useful. See their usage and details here:
The software offered on this page is commercial copyrighted
software licensed to the user by Incode Systems, Inc. (ISI).
While there is currently no cost to obtain this software, ISI does not guarantee that this software will always be available at no cost.
Furthermore, ISI assumes no liability whatsoever for any problems incurred through the use of this software.
USE AT YOUR OWN RISK. See License for details.