Xml over Excel

[Prajwal G Vaish]

Hi Team, 
Just had a doubt. To import data we use XML over Excel why is that. 
please request you to note down few points which justify this.
Thank you in advance

[AndersBGS · Accepted solution]

Hi @Prajwal G Vaish ,

XML supports information exchange between computer systems such as websites, databases, and third-party applications, where Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. Predefined rules make it easy to transmit data as XML files over any network because the recipient can use those rules to read the data accurately and efficiently.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[AndersBGS · Accepted solution]

Hi @Prajwal G Vaish ,

XML supports information exchange between computer systems such as websites, databases, and third-party applications, where Microsoft Excel enables users to format, organize and calculate data in a spreadsheet. Predefined rules make it easy to transmit data as XML files over any network because the recipient can use those rules to read the data accurately and efficiently.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[AndersBGS]

Hi @Prajwal G Vaish 

If my answer has helped with your question, please mark my answer as accepted solution.

best regards

Anders

[Prajwal G Vaish · Accepted solution]

1 - Importing XML does not trigger business rules or update the instance cache.

2 - Exporting a record/ List in Excel has Label [Field Name] but in xml it has field backend value [field_name].

3 - when exporting XML data, all of the fields are exported, regardless of the view. You cannot export records to CSV or Excel from a form.

4 - The sys_id of the record will be same while importing using XML.

5 - Excel

Export table records as a Microsoft Excel spreadsheet. Use this option to export the currently displayed fields in the list or form as an Excel spreadsheet. Configure the list or form to add or remove fields from the export.

6 - XML
Export table records as an XML document. Use this option to export all data from a table or all data for a particular record. The XML file has an XML element for each column in the table. Note:   Image field data is not preserved when exporting to XML.