Any idea why I can't import the excel file properly anymore? I can't find an explanation for the problem either.Дў. I have several hundred columns (due to the way qualtrics handles survey experiments and randomization), so renaming each variable by hand would take a long really long time, and I'd need to do it each time I import new data. Insheet using filename.csv, clear Stata 13 and onwards can directly import excel files to the stata: Import excel using filename. This means that I can't append the data sets, because the variable names don't match (stata saves Bio1 as bio1). In my original data set, first letter of variables are capitalized, the rest is lower case (ex: Bio1). Both get the data into stata, but both have the same problem - when I specify that the first line of data should be saved as variable names, all of the variables names are changed to lower case. No problem, I though, I'll either save as a comma delineated file or copy and paste into data editor. I just installed office365 and was greeting with the following message when I tried to import the latest excel file:ДЄ quick google search shows that a few other people have had this issue, but no one reports a fix. I do this on a weekly basis and have had no problems. Several topics like data management, automation of tasks, and generating customized trend graphs are. In short, I'm running surveys, exporting the data to excel, and then appending to my stata master file on a regular basis using insheet or the import function (I'm using stata 12). This guide introduces data visualization of publicly available COVID-19 datasets in Stata. I've encountered a peculiar problem and can't find a good fix.

Insheet stata