Sunday, February 20, 2011

Copy text file table in PDF or clipboard to different Excel sheet columns by parsing

1. Copy the table/data from text (or PDF). The data is now in the clipboard
2. Paste to an Excel worksheet
3. Then go to Data-> Text to columns. Now  Text import wizard will pop-up with the data displayed in it
4. Use the delimiting options(comma, fixed width etc) and specify the locations for each column to get the data into separate columns
Posted by at

1 comment:

  1. AnonymousJuly 17, 2011 at 5:22 PM

    A free clipboard tool (http://www.clicktoapp.com/de) can do this in much simpler way.

    After the copy, choose "excel" from the toolbar and the content will be automatically parsed and filled into the excel worksheet.

    ReplyDelete

Subscribe to: Post Comments (Atom)