Excel xml export row limit

I have been using XML Map to export data from a Excel 2013 workbook which works fine, but it seems there's a limit of 65535 rows on a single sheet.

Is there any ways around this and is the maximum number of rows the export function documented?

• Edited by Ruban Siva Friday, July 18, 2014 4:40 PM

All replies

There's nothing on there from what I can see about XML Map export limits.

Are you using a workbook with .xls?

If so, please note that the limition of Excel 2003 (refer to Excel 2003 specifications and limits):

65,536 rows by 256 columns.

65536 is the maximum number of spreadsheet rows supported by Excel 97, Excel 2000, Excel 2002 and Excel 2003 (Excel 2007, 2010 and 2013 support 1,048,576 rows (2²⁰)).

You can press "End" + "Down" to check the last row.

Please save current workbook with .xlsx and try again.

If this doesn't give you help, would you mind sharing code for us to reproduce this issue? If you are not using code, I recommend you to repost you question in Technet forums - Excel IT Pro Discussions for more effective responses.

Hope this helps.

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

Click HERE to participate the survey.

• Edited by George Hua Moderator Monday, July 21, 2014 6:47 AM

Are you using a workbook with .xls?

If so, please note that the limition of Excel 2003 (refer to Excel 2003 specifications and limits):

65,536 rows by 256 columns.

65536 is the maximum number of spreadsheet rows supported by Excel 97, Excel 2000, Excel 2002 and Excel 2003 (Excel 2007, 2010 and 2013 support 1,048,576 rows (2²⁰)).

You can press "End" + "Down" to check the last row.

Please save current workbook with .xlsx and try again.

If this doesn't give you help, would you mind sharing code for us to reproduce this issue? If you are not using code, I recommend you to repost you question in Technet forums - Excel IT Pro Discussions for more effective responses.

Hope this helps.

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

Click HERE to participate the survey.

As I have already mentioned this is in Excel 2013 and it's to do with Excel Mapping, it's limiting the number of rows exported to 65535 rows. Seems to be a bug?

I failed to reproduce your issue on my side by exporting 65549 rows to XML (Windows 8.1 + Office 2013 32-bit). What’s the error message when exporting the data more than 65535 rows?

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

Click HERE to participate the survey.

I failed to reproduce your issue on my side by exporting 65549 rows to XML (Windows 8.1 + Office 2013 32-bit). What’s the error message when exporting the data more than 65535 rows?

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

Click HERE to participate the survey.

I have done the same, have you checked the output XML in the file ?

No error message is shown but the output will only have a handfull or rows, not the expected 65549 from your example.

Here's the output XML when exported:

• Edited by Ruban Siva Friday, July 25, 2014 4:52 PM

Thanks for the information, I could reproduce this issue now. Only a subset of data will be exported when the row count > 65535, I'm trying to involve some senior engineers to look into this issue. It will take some time and thanks for your patience.

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.

Click HERE to participate the survey.

Please let me know the exact error that you get when you are trying to export the data from Excel to xml.

Also what is the step that you follow to export the data.

How about saving the file as xml format and using this xml file? Does this work for you?

Please see my responses as per above, no actual error is thrown.

Saving the file as an xml format is not an option as this would defeat the purpose of using XML Mapping.

Exporting of XML Mapped sheets seems to be limited to 65535 rows while there seems to be no limit when importing to a XML mapped sheet, so seems inconsistent and a bug.

• Edited by Ruban Siva Tuesday, July 29, 2014 8:37 PM

Thank you for the update.

An XML table can only expand from the bottom down of the workbook. For example, there may be an object, such as a picture or even another table, immediately below the XML table that prevents the XML table from growing. Or, for the XML table to expand, it will exceed the Excel row limit of 1,048,576.

To fix this problem, rearrange the tables and objects on the worksheet to allow the XML table to expand from the bottom down.

Thank you for the update.

We will be definitely working into this.

We have informed the concerned team about the same issue & will keep you posted with the updates.

Updates are usually in terms of cumulative or fixes.

Thank you for choosing Microsoft

Any update on this?

It seems the issue still exists in the latest version.

Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.