In the Save as type list, click XML Data, and click Save. In the File name box, type a name for the XML data file. In Excel 2007 only, click the Microsoft Office Button, point to the arrow next to Save As, and then click Other Formats. This step ensures that any changes you made to your workbook won't be lost when the workbook is saved as an XML data file.Ĭlick File > Save As, and select the location where you want to save the file. In the large Export XML dialog box, in the File name box, type a name for the XML data file.įor backward compatibility with earlier XML functionality, you might want to save the file to an XML data file (.xml) instead of using the Export command. This dialog box only appears if an XML table isn't selected and if the workbook has more than one XML Map. If a small Export XML dialog box appears, click the XML Map you want to use, and click OK. If you don't see the Developer tab, see Show the Developer tab. Our recommendation is to 1) use xlsx instead or 2) save the file as XML Spreadsheet 2003 (.xml), which will lose the mappings, or 3) delete all rows after 65,536 and then export again which will keep the mappings but lose the data at the end of the file.Įxport XML data (with no more than 65,536 rows) For example, if your worksheet has 70,000 rows, Excel will export 7007 = 4464 rows. If your file has more than 65,536 rows, Excel will export the first (#ROWS mod 65537) rows. Export to XML from Excel will save a maximum of 65,536 rows.

When creating XML Maps and exporting data in Excel to XML data files, there's a limit on the number of rows that can be exported. Before exporting XML data, you will need to enable the Developer tab on the ribbon.

Excel xml schema