importing large excel file to stata

[Yusra Noorwali]

Hello everyone,

I have data in excel format (.xlsx). the file is quite big with many different variables. the file has 112 columns, and 181763 observations (raws).
the file size is 122MB.

I tried to import this file to stata using the import excel spreadsheet command, but a message appears that ' the file you are attempting to open is too large. the maximum size allowed for .xlsx is 40 MB.'

could you please suggest easy solutions on how to import my data to stata? I tried to convert the excel file to CSV format but the file didn't list/show the variables correctly in stata

I am using STATA 14 version.

Many thanks

[Andrew Musau]

Maybe try creating 4 Excel files each of \(\approx\) 122/4= 30.5 MB and import each separately, appending sequentially.