More about the limits of Excel file formats You can also Sort data in a PivotTable or Filter data in a PivotTable. The PivotTable will work with your entire data set to summarize your data. Once loaded, Use the Field List to arrange fields in a PivotTable. In the preview dialog box, select Load To. Go to the Data tab > From Text/CSV > find the file and select Import. While the data still won't display more than the number of rows and columns in Excel, the complete data set is there and you can analyze it without losing data.

Using Excel for PC means you can import the file using Get Data to load all the data. How to open a data set that exceeds Excel's grid limits Then enter a different name that's clear that this is a truncated copy of the original file. Save a truncated copy - If you need to save the file, go to File > Save a Copy. Remember that this is also an incomplete data set. Open the file in Excel for PC using Get Data- If you have the Excel app for PC, you can use Power Query to load the complete data set and analyze it with PivotTables.ĭon't save the file in Excel - If you save over the original file, you'll lose any data that wasn't loaded.

It's important to take extra precautions to avoid losing any data: If you save this workbook, you'll lose data that wasn't loaded.' This means the dataset exceeds the number of rows or columns that's available in Excel, so some data wasn’t loaded. If you’ve opened a file with a large data set in Excel, such as a delimited text (.txt) or comma separated (.csv) file, you might have seen the warning message, ' This data set is too large for the Excel grid.

Convert txt to csv