1

I have a large notepad TSV file that I need to copy all lines that contain a specific word in them and then paste them into an excel file. How do I go about doing this?

Thanks!

Eve
  • 11
  • 1
  • 1
  • 2

1 Answers1

8
  1. Use Notepad++
  2. Ctrl+F to bring up the search box, then go to the Mark tab. Enter your keyword, and tick 'Bookmark line'. Now click Mark All.

enter image description here

  1. Now you have a bunch of lines with a blue dot in the left border

enter image description here

  1. Now click 'Search' on the top toolbar > Bookmark > Copy Bookmarked Lines

enter image description here

  1. Paste the results into Excel

enter image description here