How to import XML split files into Microsoft Excel (Tested with Microsoft Excel 2003) 1. On the Data menu, point to Import External Data, and then click Import Data. 2. Choose the folder of your hard drive where the xml split file is located and click in OK 3. In the Import Data window, click in OK