DTM Data Generator for Excel is an easy-to-use tool and add-in that helps you to create and populate test Microsoft Excel spreadsheets.
The generator's project corresponds to single output document. The project file stores columns definitions and general properties like file name and a number of data rows to be generated.
Each file column (or field) has only two mandatory properties like name and generator. The generator is a rule that the program will use to create test data.
You can specify file structure manually by adding columns line by line. Also, DTM Data Generator for Excel can help you to import structure.