Windows, view the IP address of the process's connection, batch mode, and finally Excel

1.CMD, Netstat-ano, copy to UltraEdit

2. Replace the double spaces with a single space, which is repeated many times until all are replaced. Next, point 20 times to replace the line.

3. Replace the single space with ^t, which is the tab character.

4. Copy all content to Excel 2013, and the content is automatically distributed to the grid.

5. Find the PID of the process, in Excel, through the data filtering function, only show the line of the PID.

6. Copy all the data that is filtered out of the current page and paste it into the new Excel worksheet.

7. Go to Baidu to find a can paste bulk IP, and give the IP address of the URL. Recommendation: www.1234i.com

8. The new worksheet, copy the IP address, every 300 lines, copy to the Bulk query window of this website.

9. Copy the query results into the UltraEdit and replace the # with the ^t.

10.Excel open a new worksheet, copy the replaced content to this new worksheet, you will find the detailed IP address all become a column.

11. Paste the details of the IP address into the previously copied work table. Of course, the worksheet needs to add a column by itself and enter the column header name.

12. It's over. If you need to go heavy, you can use the Deduplication feature of Excel data.