What is data transformation? Definition, types and benefits

Data transformation is the process of converting data from one format — such as a database file, Extensible Markup Language (XML) document or Excel spreadsheet — into another format.