Does anyone know how to convert a Microsoft Word .RTF file into a Microsoft Excel file? I have tried everything I know and I have no success other than getting everything crammed into column A in excel. Thank you.
No this does not work. The RTF document I am using was an export from Seagate Crystal Reporting. It is over 135 pages long. It cannot be pasted into Excel.
Yes. I saved it as a .doc then tried to open in Excel, but it says "invalid format".
I also tried the software link you mentioned, and had no success either.
Surely SOMEONE out there has has to convert .RTF to Excel????
Since the document was generated by an automated process, can you use a different layout in CR and format it differently? Preferably, some sort of tab delimited text file format. Or maybe I can show you an easy way to extract it from the database without even using CR?
The report was generated by Seagate Crystal Reports then exported into the format I have which is a RTF file that opens in WORD. I don't have access to the database from which the report was generated. I am famailiar with Crystal because I use it at my business, but I am unable to import the RTF into Crystal, Excel, or anything.
The file is extremely large and the company that sent it to me sent it this way on purpose so that I would be unable to sort/manipulate the data for further analysis. I know it was generated from Crystal bc it says so when I do a properties on the file.
I cannot send the file as it is confidential information. So I guess I'm stuck.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.