Import XML Files
How do I import data from a XML file?
Start by opening the main menu at the top left corner. In the list you find the menu item Data Source that leads you to all importer settings.
![](https://docs.exply.io/_Resources/Persistent/35dd944d76e54bc9cba2617fbfe9eb88a5deeae6/1-Menu-Data-Sources-1920x1165.png)
Choose Data Sources from the Menu or Connect from the Startpage
![](https://docs.exply.io/_Resources/Persistent/d3e0b2d34a7e360e18938a964a3a032e2d5e3b98/2-Data-Sources-Configured-Overview-1920x1165.png)
Configured Data Sources Overview
![](https://docs.exply.io/_Resources/Persistent/1562879dd9d33d3f0f09bab94cc1c6a87011e8b5/4-XML-File-Importer-1920x1165.png)
Choose XML File from the Data Source Overview
![](https://docs.exply.io/_Resources/Persistent/5f2d9d7963e3445bba49097b1c52e0e4e73fa531/5-XML-FIle-Importer-Config-1920x1165.png)
Choose how to import your XML File
XML Import Configuration
![](https://docs.exply.io/_Resources/Persistent/520e5f773669c495c52b7f0671d77a08eab4a7a1/6-CSV-File-Config-Upload-1920x1165.png)
XML File Upload successful
![](https://docs.exply.io/_Resources/Persistent/2e6854087ff12348f9de63561ddd43043ba1174d/7-CSV-File-Config-Delimiter-Before-Refresh-1920x1165.png)
Preview without a selected Delimiter
![](https://docs.exply.io/_Resources/Persistent/0bd58fc3c0b2f251ba9656ed3ef20f91ff85a2b9/8-CSV-File-Config-Correct-Delimiter-Before-Refresh-1920x1165.png)
Enter the correct Delimiter and reload the Preview to see if everything is fine
![](https://docs.exply.io/_Resources/Persistent/1fd694490fb370447172a1b49198e3bd5dc0f2bf/9-CSV-File-Config-Correct-Delimiter-After-Refresh-1920x1165.png)
After correct Delimiter was entered and Preview is refreshed hit next
![](https://docs.exply.io/_Resources/Persistent/a0d8ebf5be4353e2feafa6991076dda86f3dc0b8/10-CSV-File-Config-Advanced-Options-1920x1165.png)
Advanced Options for advanced CSV Files if necessary
![](https://docs.exply.io/_Resources/Persistent/a9f77398d598b81d3b0d095e1f32381b06181ffa/11-CSV-File-Config-Choose-Language-Auto-Detect-1920x1165.png)
Choose the language of your XML file to enable auto-detect
![](https://docs.exply.io/_Resources/Persistent/a2065a356e8480462ecfdf4aa29365a944d9e3b3/12-CSV-File-Config-Data-Mapping-1920x1165.png)
Auto-detect is not perfect 😉 validate all columns
![](https://docs.exply.io/_Resources/Persistent/dc12ac20f2e67da84432319248de632df31067bf/13-CSV-File-Config-Data-Mapping-Deactivate-Columns-1920x1165.png)
In this example we do not want to import the transaction time and deactivated the corresponding column via the switch
![](https://docs.exply.io/_Resources/Persistent/50c77be29b6dbe6328894d49bf827796f70a36f0/14-CSV-File-Config-Change-Data-Type-1920x1165.png)
Transaction was recognized as value but is a category so we changed the type via the dropdown
![](https://docs.exply.io/_Resources/Persistent/b42c66fc5deb1e85cfc16cc968da698b39575417/15-CSV-File-Config-Import-Start-1920x1165.png)
Everything is correct and the import started after hitting the save button
![](https://docs.exply.io/_Resources/Persistent/bdce189f7f1c4b42571af99d05e0819b1020d12f/16-CSV-File-Config-Import-Finished-1920x1165.png)
If the dot in front of your new importer is green, the importer is finished and you can start analyzing your data.