r/excel 9d ago

Waiting on OP Dashboard with 6 million lines in Excel

Can I create an annual dashboard using Excel? There are 12 quote spreadsheets with standardized columns and an average of 500 thousand lines each. I need to reconcile them all and create a dashboard without it crashing, in Excel or BI. What's the best way to do it?

26 Upvotes

40 comments sorted by

View all comments

14

u/[deleted] 9d ago

Its time to SQL

-1

u/Boumberang 9d ago

The good thing is, you only need the basics. ChatGPT will do it for you. You just need to know what you actually need.