Another useful method of creating test data is to define the data in MS Excel, and then create a job to convert the Excel worksheets into the format required by the application, such as a CSV file or database table.
Open the Excel workbook
chapter10_jo_0130_ExcelTestData.xlsx that can be found in the data directory. You will see two worksheets: customer and item.
The steps for creating test data using Excel are as follows: