In this tutorial you'll see how to import a text file that's got 1.5 million rows of data, that's roughly 500K more rows than Excel can handle. Get the spreadsheet and Data File. Also get updates when new blog or video tutorials are released. As of Excel … [Read more...] about How To Use Power Query In Excel To Import Large Files