How to export publications from a topic in .xlsx format

How to export publications from a topic in .xlsx format

You can export publications from the system in different formats. If you need to get basic data about publications, choose the format of exporting publications in .xlsx

You can export publications to .xlsx:
  1. from one topic;
  2. from several topics;
  3. from the tag view mode.

How to export publications from one or more topics

STEP 1. Select the desired topic.
To export posts from one topic, click on its name in the list of topics. 
If you need to export posts from several topics at once, after selecting the first topic, click on the checkboxes of the required topics and then click OK at the bottom of the list of topics. Learn more about viewing topics.

STEP 2. Select the required posts.
After selecting the desired topic(s), select the publications to be exported. You can select all the filtered publications via the checkbox on the publications panel, or you can select several necessary publications via the checkboxes on the publication cards.

STEP 3. Open the export menu on the publication action panel.

STEP 4. Select the export option - export the selected number of documents.

STEP 5. Select the export format .xlsx.


When all options are selected, the file export will be started. A notification about the preparation of the export will appear in the bottom left part of the window. Wait until another message about successful export appears. Click "Confirm" and wait for the file to be downloaded.

How to export posts from tag viewing mode

You can export publications that contain the tag(s) you have selected, no matter which topic the publications with this tag(s) are in. 
To export a publication by tag/tags, switch to the tag mode (read more about viewing in the tag mode), select the tag/tags and choose the desired export format.

STEP 1. Go to the tag view mode.

STEP 2. Select the required tag/tags.


If your account contains tags from a group of tags, you can select the entire group by clicking on the checkbox next to its name.

STEP 3. Open the export menu on the publication action panel.

STEP 4. Select the export option - export the selected number of documents.

STEP 5. Select the export .xlsx. format.

When all options are selected, the file export will start. A message about export preparation will appear in the lower left part of the window. Wait until another message about successful export appears. Click "Confirm" and wait for the file to be downloaded.


    • Related Articles

    • Grouping tags using prefixes

      Grouping tags using prefixes Tags can be grouped if they have a tag prefix in their names - a word or several words followed by a colon and then a tag name. This prefix is the name of the tag group. Grouping tags allows you to: view tags from ...
    • How to export publications from a topic in .docx format

      You can export publications from the system in different formats. If you need to get basic data about publications, choose the format of exporting publications in .docx.  You can export publications to .docx from one topic; from several topics; from ...
    • What are tags and how can I use them?

      What is a tag? It is a mark that can be placed automatically or manually on the publications. It is a kind of classification feature. Tags allow filtering publications, generating graphics on them, and exporting data to a report. You can also set up ...
    • Automatic report by topic in Excel

      Automatic report by topic in Excel In the Semantrum, users can generate an automatic report on a topic by themselves. Users can export reports from the system in .docx, .xlsx or .pptx format. If you need to get a ready-to-use media report about your ...
    • Automatic report by topic in Word

      Automatic report by topic in Word In the Semantrum, users can generate an automatic report on a topic by themselves. Users can export reports from the system in .docx, .xlsx or .pptx format. If you need to get a ready-to-use media report about your ...