The Billion Rows Excel Challenge

It's a common myth that Excel can only house 1,048,576 rows of data. After all, that's how many worksheet rows there are, right? However, thanks to the Data Model, it's possible to do more — way more.

Back in December 2021 (https://youtu.be/anU7FMqko_A), I demonstrated how long it took to load varying-sized datasets into the Data Model with and without Power Query's Fast Data Load enabled.

I decided to repeat the experiment, except go two huge steps further by adding 500 million and 1 billion to the list.

How did I get on?

Watch the video here:

0:00 — Recap
0:50 — 1 Million Rows (Fast Data Load ❌)
1:08 — 1 Million Rows (Fast Data Load ✅)
1:26 — 5 Million Rows (Fast Data Load ❌)
1:45 — 5 Million Rows (Fast Data Load ✅)
2:02 — 10 Million Rows (Fast Data Load ❌)
2:21 — 10 Million Rows (Fast Data Load ✅)
2:39 — 50 Million Rows (Fast Data Load ❌)
2:58 — 50 Million Rows (Fast Data Load ✅)
3:17 — 100 Million Rows (Fast Data Load ❌)
3:42 — 100 Million Rows (Fast Data Load ✅)
4:05 — 500 Million Rows (Fast Data Load ❌)
4:32 — 500 Million Rows (Fast Data Load ✅)
4:57 — 1 Billion Rows (Fast Data Load ❌)
5:30 — 1 Billion Rows (Fast Data Load ✅)
6:05 — Final Results
6:20 — Testing

Read the blog post on Medium:
👇
https://andrewcharlesmoss.medium.com/the-billion-rows-excel-challenge-e290461b65ab

---

Where to find me:

Website — https://andrewmoss.me
LinkedIn — https://www.linkedin.com/in/andrewcharlesmoss

Видео The Billion Rows Excel Challenge канала Andrew Moss