I have an excel sheet I downloaded as a csv file. The number of observations is over 150,000. I imported the csv file, and noticed some things were off. After checking the number of observations with the original file, the number of observations in the imported file was at around 141,000. I was wondering if anyone knows why a fair amount of observations were dropped after importing the file. (I find this so strange. Also, as a small FYI, I am running on Stata 14).

This does not happen when I import the data as an excel file (.xlsx). However, when I import the excel file as a .xlsx, it runs slower and my variables turn into string variables. I have tried to destring them with destring, replace but it does not destring and reads the variables as non-numeric. I am a little bit at a loss. Thanks for any help and/or leads!