How to handle more than million rows in Excel - Interview Question 02

#MoreThanMillionRows #ExcelInterviewQuestions #DataModelExcel
Can you handle more than a million rows in Excel? If so, how?

In this episode of Excel Interview Questions, let's review Excel Data Model and how you can use it to analyze large sets of data.

For more on topic and resources, visit
===============================

[joelester]

Nice to see you here are the reason I started developing interest in learning Microsoft are a living legend Sir.

[MLFranklin]

This is a huge issue for me. Currently I'm breaking my CSV file up with a macro to make it manageable in Excel. But even with that automation, there is still a lot of manual work in getting it into the pivot tables that I need.
You're offering a logical solution. I'll have to try it this week.
Thanks so much for sharing your knowledge!

[garylhaas]

I had a 10+ million row table of general ledger transactions - i imported this into Excel data model - Access file was over a gigabyte, Excel file was 40 million bytes

[wayneedmondson]

Hi Chandoo.. thanks for the video. Nice to understand the technical aspects of data compression and file size. Also, was not aware that Power BI had an advantage with larger data sets.. makes sense.. now that you point it out and given the purpose and design of Power BI vs. EXCEL. Thanks for sharing your knowledge. Thumbs up!

[pektuspektus]

Thanks for making me awesome in Excel Purna!

[MrKathayat]

Big fan of yours sir, a long time student probably more then 12

[jorgeperezcastedo]

Thank you so much Chandooo for sharing this great tip. I love pivots and always wondered how could anylize millions of rows. This is awesome, you may my day. :)

[cacacdt]

Excelent suggestion!! I couldn't with a xls or xslx file, but I downloaded the report with CSV and then it was possible to proceed as you suggested.

[garavindh]

Hi Chandoo. Could you speak louder in the future pls. Voice is not audible.

[wuliangye]

Amazing stuff.. Solved a big issue I have when analyzing huge amount of records. Hope my evolution will be to update my skills and tools to something more powerful thank Excel!

[robertjay]

Thanks for this - could you search or look up against those numbers? a large v lookup for example

[hirengson]

Hey I have really difficult question in my mind can u just solve this..
I was doing word column combinations in my excel.
And rows are continuing loding till now. So can I save it.. for stop loading rows and catch up already loaded rows.

[waltruiz]

This is great, I have a question, I have a query in access with more than 12 millions of records, how can I bring the data for analysis in excel???

[kldpmishra]

I always find your videos very helpful thanks chandoo

[nazarkamal]

Hi chandoo!! If we load that data in excel cant that reflect in another sheets in this same workbook ???

[bigmoist]

if we need to add a custom column in the raw data, how do you suggest we go about it?
Lets say its a vlookup where i have to refer to another excel.

[premprakash]

Chandoo..what's the secret of your profound knowledge..?

[growth]

One challenge I note is that when an Excel file gets too large because it contains large amounts of data the file starts to lag tremendously. What about connecting a query to an Access database. Will this mitigate the processing limitations of Excel in such a case.

[engr.engr.]

Now if i want to remove some data or replace some data from +2 M rows using data model. How to save the modified data to csv after this change?

[santanuroy]

I want to do something else ..we know that in a single tab it can display 1048576.. so for 3.5 million records i want as soon as it reaches that limit the next rows creates new tabs and moves there and so on .. untill it reaches to the count.. how can we do it in excel?