You can copy the data from as400 to Excel by using the data transfer utility by following some steps if you have Access Client Solution (ACS) installed at your end.

1. Open IBM i ACS and then from the General menu open the Data Transfer utility.
2. Once the Data transfer utility opens up, then select From IBM i tab to export data from as400 to Excel.
3. Select the already configured as400 system under the IBM i section.
4. Provide the qualified file name like library/filename that you want to export from the as400 system.
5. Select the output device as File under the file section.
6. Click on the details button and the File details dialog opens.
7. Select File Type as Microsoft Excel(.xlsx).
8. Select File action as per your choice/requirement.
9. Under the Client file description section check the Save client file description box.
10. Once you check the box, the File name box that was earlier disabled will get enabled and then click on browse to browse the file location where you want to save the .fdfx type file i.e. file description files, and now provide a file name and click on open that will close the dialog box.
11. Click on OK on the File Details dialog box to save file details.
12. Click on the Start Transfer button on the main Data Transfer From IBM i utility dialog box.
13. You may be asked to input your user ID and password and after that, the data will be copied from as400 to Excel.