Import too large an Excel file into Stata
If you get the “file too big” error when using the “import excel using…” command in Stata, simply add
set excelxlsxlargefile on
To the top of your do file. Stata will be unresponsive for any large excel file loaded, so be prepared.