How do I read data from an Excel spreadsheet into Stata?
Start by opening your spreadsheet in Excel. Use your mouse to highlight the columns in your spreadsheet that you want to copy to Stata. Make sure that you highlight complete columns, i.e., do not ignore a header line if one exists (a header line contains variable names). Now, select Copy from the Edit menu in Excel. At this point you can quit Excel but doing so is not required. Start Stata as you normally would. From the command line type “edit” and you should now see a blank spreadsheet. Select “Paste” from the Edit menu in Stata, and you should see your data. Close the edit window, and you are done. Top of page.
