Excel/XML File Limitations

D

DaleB

Hi:

I am trying to import XML files into Excel (say one at a time), but many
of the XML files are large in size many GB. Does anyone know if there
isa size limitation in files for importing into Excel.

In other words...
Is there an upper limit in how big the source .xml file can be ?
Is there an upper limit in how big the target Excel .xls or .csv file can be ?
Is there an upper limit on the number of rows in an Excel Worksheet ?
Is there an upper limit on the number of columns in an Excel Worksheet ?
Is there an upper limit on the number of bytes within an Excel Worksheet
cell ?

Thank you...

DaleB
 
B

Bernard Liengme

Many (all?) of your questions are answered in the Help topic "Excel
specifications and limits" - search Help with the term <specs>
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xml import....Size limit?? Can the XML file be split?? 0
Converting Large XML Files into CSV File via Excel 2
import XML data...Is there a size limit on the import? 0
xml feed imported to excel file 1
How to find the number of value within a range? 4
Why the arbitrary spreadsheet size limitations? 7
Excel 2002: What happen to the extra rows and columns ? 1
Excel Viewer 2003 supported file types 4

Top