Using Excel to calculate data from verry large .csv files

Hello everyone,

Currently I have some verry large .csv files with over a couple million of rows, which in the future will probably be in the billions.

I am trying to import these into excel, but if I do this the "normal" way, i get an error because Excel can only handle 1 million something rows.

Then when I import the file as a database, I am able to view all the rows, but in the data model I am not able to use normal excel functions (like COUNTIF, for example).

I would like to be able to use all functions that are built into excel to help me calculate some stuff inside those large .csv files, can someone explain me how to achieve this?

(btw, i do not need a pivot table, and I am not able to use my data in a pivot table since I have a few different columns of data).

Kind regards,



Jack

Perhaps PowerPivot or Power Query ?

Thank you for your response Pepe,

I am not able to use normal excel formulas in power pivot, and my dataset is to large for power query.

So where you normall would use a formula:
=countif(A:A;">0")

I would like to specify in excel that A:A is inside the .csv