Best file format for large file

[conorsgaffney]

Hi,

I'm working with several extremely large spreadsheets (in between 60 and 100 MBs each). They're .csv's and I found that when I saved them as .xlsx or .xlsb their size shrank dramatically.
However, they're still a bit too large for excel to manipulate them without periodically crashing. I was wondering if anybody had any recommendations for either:

1) the best file format for large spreadsheets (i am not doing any complicated functions, just SUM and SUMIF)

2) alternative spreadsheet programs that done have as much functionality as excel but might be better suited to manipulate the data in the way I want to

Thanks!

Conor

[cloudswhite]

If you show us your sample file.

Expert member will guide you how to solve it.

IMHO, it's better way to get advice from member.

Good luck every member