Excel Big Data alternatives doesn't have formulas

Hey, I have excel sheet with more than 3 million rows. I Tried all these alternative applications to open excel files that are bigger than 1,048,576
I need to have IF commands and other excel commands in the entire sheet from row 1 to row 3 million
Here are the applications I used and the problem I had:

Google Sheets - limited to 200K cells
Microsoft Excel Live - start to do problems above 500k rows, nearly impossible to scroll down
MATLAB R2018a (Trial) - doesn't allow excel commands
Delimit (trial) - doesnt allow excel commands
Openrefine - doesn't decode the text good
PowerPivot - look like it a tool that can sum certain columns but can't put if commands in row 2 million

I also read that people recommending about R and i didn't try it but on youtube it seems like its doesn't compatible with excel commands.


There is any program that will allow me to use excel commands on sheets with more than 1,048,576 rows?

So Power Query doesnt compatible with excel commands?
I can split the files to 4 file each up to 1 million row but i prefer that it will be on one file.

what you mean: excel commands?
PQ is a build-in into Excel 2016 and 365 so each M language command is an excel command also.
IMHO if you want to use any excel worksheet FUNCTION(s) on your 3 million rows you'll need to make a coffee for a long time waiting

Originally Posted by sandy666

what you mean: excel commands?
PQ is a build-in into Excel 2016 and 365 so each M language command is an excel command also.
IMHO if you want to use any excel worksheet FUNCTION(s) on your 3 million rows you'll need to make a coffee for a long time waiting

PQ allow more than 1,048,576 rows?
Made this commands on 1 millions rows and it wan't that bad, under 15 seconds but i need a couple of columns so we will see about that.
MATLAB took me about an hour to install and about a 45 minutes to open the file, and then i can only watch it???
Also needed to change my windows from 32 Bit to 64 Bit, hopefully it will run fast. All the non Microsoft apps left me with about 3 hairs on my head.

It's sounds good, I will try it
Thanks for your time

You are welcome

also you can use pencil and paper
or PowerBi Desktop (conglomerate of PowerPivot&PowerQuery) but forget about Excel