It seems Google Sheets has a limit of 8000 rows (approximately due to my little test). I have an XML file URL containing several thousands of elements. Because of that I'd like to split the XML file into multiple Google Sheets.
Is there some way I could select a range to import? E.g.
=IMPORTXML("https://example.com/file.xml", "//element", "formula-for-only-selecting 0-999")
Another way I'd like to split the XML file into multiple Sheets, would be to choose which types of elements to import based on additional data, such as "Name" contains "Jack". E.g.
=IMPORTXML("https://example.com/file.xml", "//element", "formula-for-only-selecting-elements-including-name-equals-jack")
This is how the XML file looks like:
<elements>
<element>
<link>
<![CDATA[ https://example.com/jones ]]>
</link>
<name>
<![CDATA[ Jones ]]>
</name>
</element>
<element>
<link>
<![CDATA[ https://example.com/jack ]]>
</link>
<name>
<![CDATA[ Jack ]]>
</name>
</element>
</elements>