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


1 comment:

  1. 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