Excel can only handle a certain amount of records. I've personally found it hard... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		bhartzer on May 27, 2014 \| parent \| context \| favorite \| on: You shouldn’t use a spreadsheet for important work Excel can only handle a certain amount of records. I've personally found it hard to deal with more than 100,000 rows in Excel.

morganherlocker on May 27, 2014 [–]

The limit went up considerably with the introduction of 64-bit Excel. Also, there is a plugin called "Power Query" that allows the actual data to be stored in MSSQL. I have seen this work on tables with 100s of millions of records without a hitch.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact