Question: how to import rpt file into excel?
Answer: Right-click the RPT file and then select Open with Notepad.
Click the File menu and then choose Save As Save the file as . ... 
Now, open Excel, go to the Data tab on the Excel window and then choose From Text/CSV under Data Tools section.