4 ms·

Can Excel open a 1-billion-row data file?

• retr0rocket 13y ago
  there is a limit and its no where near 1 billion.
• karamazov 13y ago
  No, it can't - the limit is just over one million rows. This doesn't involve pulling anywhere near that many rows into your spreadsheet.
  • wbsun 13y ago
    Then why MapReduce?
    • karamazov 13y ago
      We let people with Hadoop Clusters pull a small sample of data into Excel, analyze it with Excel formulas, and then run the analysis on the full data set. The last part happens outside of Excel.