5 replies
by marigumeru Accepted solution
by robo_dev Accepted solution
how to do that? Answer: Simply import it into Excel
OR
Some stand-alone third party utility to do that?
Some plug-in or code to do that?
by marigumeru Accepted solution
by aratinga Accepted solution
Excel does imports nicely. The trick is to change the extension to .txt from .rtf. Then start Excel and tell it to open the file (don't double click on the file). The import dialog will start, and you can select Tab Delimited. Then you can define some of the columns as text versus number and so forth.
When in doubt, load a file into TextPad and check whether all the rows are Tab Delimited. The RTF file can have non-tabular crap at the top, which you can remove. TextPad is my favourite application for Windows.
by thatotherapple Accepted solution
An RTF is *not* a text (TXT) file. Simply renaming RTF to TXT won't make Excel recognize it. Try this: Open Notepad, drag/drop your file to the open Notepad document. See all those character sequences that have nothing to do with your data? That's RTF (Rich Text Format).
Excel does interpret TAB delimited data from the clipboard. The easiest way to bring this data in would be to select it (from Wordpad or Word), Copy it, then Paste it into Excel. You could also Paste it into a blank Notepad and save that as a TXT file. That could then be imported into Excel.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending