Power Pivot Excel add-inshould be able to manage million of rows. See https://support.microsoft.com/en-us/office/data-model-specification-and-limits-19aa79f8-e

Power Pivot Excel add-inshould be able to manage million of rows. See https://support.microsoft.com/en-us/office/data-model-specification-and-limits-19aa79f8-e6e8-45a8-9be2-b58778fd68ef https://support.microsoft.com/en-us/office/data-model-specif... and https://support.microsoft.com/en-us/office/create-a-memory-efficient-data-model-using-excel-and-the-power-pivot-add-in-951c73a9-21c4-46ab-9f5e-14a2833b6a70 https://support.microsoft.com/en-us/office/create-a-memory-e...