Paste Data into Stata from Other Spreadsheets
If you are working with numbers or strings in a spreadsheet and are not concerned with retaining any information but the actual value in the cell you can always copy and paste data into Stata. Bring up an editable data window in Stata via the edit command. Click to highlight the first box in the first blank row of the first column in which you want to add data. Then simply highlight the cells you wish to transfer (in your data spreadsheet), copy them Edit => Copy, switch back to Stata and paste Edit=>Paste
Note: Paste will only work with a single blank cell selected (highlighted). Paste will not overwrite existing values.
The results of pasting will appear in your Results window, including how many variables and observations were pasted into the data sheet.
Back to Home