Go to the folder containing your txt file and click "Import". We’re going to use power query to look at this file so after downloading the data file…Ĭlick on the Data tab, then choose "Get Data" then "From File" then "From Text/CSV" Here we have a large csv file with roughly 1.5 million rows of data, this definitely blows Excel’s data limit. As of Excel 2016 going forward Excel can hold 1,048,576 rows of data, but sometimes even that’s not enough.
0 kommentar(er)
