CODEWITHSUNDEEP
xmlexcel
user3845894
user3845894

Reputation: 373

Exporting data from Excel sheet into XML file

I am dealing with a large number of records. I have around 5,50,000 records in an excel sheet. I need to export that data in an XML file. I tried using the inbuilt functions in Excel but it has a limitation. A max of only 65,000 records can be exported into XML file using Excel. Can you please suggest something on how can this be done?

Thanks.

Upvotes: 1

Views: 637

Answers (1)

datchung
datchung

Reputation: 4622

  1. Make sure your file is saved in the XLSX format.
  2. In File Explorer, right click the XLSX file > Unzip.
  3. Browse unzipped contents, you should see an XML file with your data. In my version of Excel, the data is in the \xl\worksheets folder.

Upvotes: 1

Related Questions