How to use Selected-Tab and other hidden features

[Quick Summary]

  1. Selected-Tab and other hidden features
  2. When do I use them?
  3. It's most helpful when downloading a group of data together

1. Selected-Tab and other hidden features

We introduce Selected-Tab, Selected-Cards, and All-Cards-except-Selected. They are the options to include or exclude specific content in exporting the selected tab to an Excel file.

2. When do I use them?

Alexa's ranking page is on the left and its extracted result is on the right. The extracted result mainly consists of two parts; 1) table header, 2) table data. The table header always shows up in the first card and the table data appear in the rest of the cards.

When you download an Excel file, the default option is Selected-Tab.

It means all the data are included in a spreadsheet. So the table header data in the first card would create new columns at new positions as the next screenshot.

You will agree that the structure is not pretty. You can make the result more beautiful with an option, All-Cards-except-Selected. The option allows us to select and deselect each card in a tab result. We will exclude the unpretty table header, the first card.

This is the result. Looks much better and cleaner for post-processing.

3. It's most helpful when downloading a group of data together

This feature will be of help when you download a group of data. Now we add 6 pages more to build a group of data. Compared to the first example page, the new pages have the same templates but different table data.

And then, we created a folder group with a total of 7 pages and excluded the first card using the All-Cards-except-Selected option. In this article, we won't talk about the way to extract the pages and make a folder group. You can refer to How to Download multiple private pages for more details.

When downloading an Excel file, we chose 1-Card to 1-Row option to stack up all the cards in rows.

Here's the result of group data. Look at the 52nd row. The row is the bridging point that a page moves to another one. You can see the table data changes on the row.

If we use not All-Cards-except-Selected but Selected-Tab, the result would look like this. Check the 53rd row. The first card's data popped out of other columns. The row hurts a well-arranged structure.

Again, we can visually check out the structures of both cases in a macro view. The left one is generated by All-Cards-except-Selected, which excluded the first card. The right one is generated by Selected-Tab, which included all the cards.