How to export huge data from data model into normal sheet

[earthworm]

If the data length in data model is > 2 million and I need to export it to excel sheets how to do it so that upon exporting the data splits automatically into multiple sheets if the sheet row size exceeds the data

 

[denzo36]

I don't think this is possible. If you data model is > 2 millions rows then it's probably coming from a SQL server database or similar, so best thing to do would be query it directly from there instead of trying to extract it from your data model