Skip to content

Extract and List all comments to the new worksheet or workbook in Excel!


Extracting and listing all comments” refers to the process of identifying and extracting comments from a particular source, such as a document, website, or social media platform, and then presenting them in a list format.

Comments are a form of user-generated content that can provide valuable insights, opinions, and feedback on a variety of topics. Extracting and listing comments can be useful for analyzing public opinion, understanding customer feedback, or monitoring social media activity.

The process of extracting and listing comments typically involves using a combination of tools and techniques, such as web scraping, natural language processing, and data cleaning. The extracted comments can then be analyzed using various data analysis techniques, such as sentiment analysis or topic modeling, to derive insights and patterns.

It’s worth noting that extracting and listing comments from a source may require permission or legal considerations, especially if the comments are from a private forum or closed group. Therefore, it’s important to ensure that any data collection and analysis are done in compliance with relevant laws and regulations.

List All Comments to New Worksheet/Workbook

A general process to extract and list all comments in a new worksheet or workbook in Excel is:

Here is an example of Sales Report of the Super market which contains “Sales Person, Sales Product and Sales month-wise data” in the comments. You can extract the data and also extract the comments.

  • Open the source file, such as a document or website, that contains the comments you want to extract.
Data range
  • Use a web scraping tool or manually copy and paste the comments into a plain text file.
  • Open Excel and create a new worksheet or workbook.
  • Import the plain text file containing the comments into Excel using the “Text Import Wizard” under the “Data” tab.
Text Import Wizard
  • After extracting the comments into the new sheet, you will see the result below.
  • Use Excel’s text manipulation functions, such as “LEFT,” “RIGHT,” “MID,” or “FIND,” to extract the comments from the imported text file and organize them into columns in the new worksheet.
  • Use Excel’s built-in data analysis tools, such as “PivotTables” or “Charts“, to analyze and visualize the data as needed.
  • Save the new worksheet or workbook with a descriptive name to distinguish it from the source file.
  • Consider using Excel’s filtering and sorting functions to organize the comments by various criteria, such as date, author, or sentiment.

Remember, when extracting and analyzing user-generated content, it’s important to consider ethical and legal implications, such as obtaining proper permissions and safeguarding user privacy.

List All Comments to New Worksheet/Workbook with Kutools

If your worksheet contains a large number of comments and you want to list them in the new worksheet, then follow the below steps.

  • First, you need to activate the worksheet or workbook, which contains a lot of comments.
  • Go to the Kutools tab, select the More option, and choose the Create Comment List option from the drop-down list.
Select the Create Comment List optionPin
Kutools > More > Create Comment List
  • Now, it will open the Create Comment List dialog box.
  • Scope: You need to select the scope (Active sheet) from which you want to extract comments from the drop-down list.
  • Comment listing: You need to select any checkbox as you need.
Click the Create buttonPin
Create Comment List
  • Then, click the Create button.
  • Now, it will create a new workbook or new worksheet to list all the comments on the active sheet, as shown in the below image.


In conclusion, extracting and listing all comments in a new worksheet or workbook in Excel can be a useful way to analyze and organize user-generated content from various sources. Excel provides a powerful set of tools for managing and analyzing data, making it a popular choice for data processing and analysis tasks. To extract and list comments in Excel, you can use various techniques such as web scraping, text mining, and data cleaning to extract the relevant information from the source and create a list of comments in Excel. You can then use Excel’s built-in functions and tools, such as pivot tables, charts, and filters, to analyze the data and derive insights. However, it’s important to ensure that you have the necessary permissions and legal considerations before extracting and analyzing user-generated content. Additionally, Excel may not be the best tool for handling very large datasets or unstructured data, so you may need to consider alternative tools and techniques depending on your specific needs. Overall, extracting and listing all comments in Excel can be a powerful way to gain insights into user opinions and feedback, as long as it’s done in a responsible and ethical manner. For more articles, you can visit our homepage.

Video Tutorial

Here is the video tutorial to Extracting and listing all comments in a new worksheet or workbook in Excel for your better understanding.

Extracting and listing all comments in a new worksheet or workbook in Excel


What kind of sources can I extract comments from using Excel?

You can extract comments from a variety of sources, such as social media platforms, online forums, review websites, blog comments, and email.

Do I need any special tools to extract comments from a source?

It depends on the source and the format of the comments. For example, you can manually copy and paste comments from a website or use a web scraping tool to automate the process. There are also specialized tools available for extracting comments from social media platforms, such as Twitter or Facebook.

What if the comments are in a different language?

If the comments are in a different language than your Excel language settings, you may need to install language packs or use third-party text translation tools to translate the comments before extracting and analyzing them.

Can Excel handle very large datasets?

Excel has some limitations when handling very large datasets or unstructured data. In such cases, you may need to consider using alternative tools, such as Python or R, for data processing and analysis.

Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...