RTF files are Rich Text Format files and they're not commonly used to store delimited data that you could import into Excel. Without being delimited, you would end up with everything in one cell, or possibly several cells moving downward.
Have you tried an import though? It's possible that what you are receiving IS delimited. Without seeing it, we can't tell.
If you can't import it, you'll need to ask the sender to send in a different format.
Note: This file type (RTF) can become infected and should be carefully scanned if someone sends you a file with this extension. As of August 2007, spammers have started to attach RTF file messages to E-mail. When opened you see the spammed message. This is similar to the XLS, PDF, and other similar spam techniques......