Question: how to import data from another program into excel?
Answer: Copy/Paste. The Copy/Paste method is probably the most common. ... 
Pull. You can pull the data directly from the external data source using the External Data feature of Excel. ... 
Push. You can also push the data from the system into a specific worksheet in an existing workbook. ... 
External Data. ... 
Recap.