The file contains more than 1,048,576 rows or 16,384 columns. To fix this problem, open the source file in a text editor ...

The file contains more than 1,048,576 rows or 16,384 columns. To fix this
problem, open the source file in a text editor such as Microsoft Word.
Save the source file as several smaller files that conform to this row and
column limit, and then open the smaller files in Microsoft Excel. If the
source data cannot be opened in a text editor, try importing the data into
Microsoft Access, and then exporting subsets of the data from Access to
Excel.