Excelis XML-andmete importimiseks ja eksportimiseks on abi XML-vastendusest, mis koondab XML-elemente, mille lahtrites olevad andmed aitavad teil soovitud tulemused saada. Vastenduse loomiseks peab teil olema XML-skeemifail (.xsd) ja XML-andmefail (.xml). Pärast XML-vastenduse loomist saate vastendada XML-elemente nii, nagu soovite.
Data mapping is when one set of data is connected with or assigned to a destination in a database. Data mapping helps keep data in an organized, accessible format, even when it is collected in a variety of different formats.