Working with arrays in Excel

An array is a series of items that are of the same data type. Many functions in SeoTools like XPathOnUrl, JsonPathOnUrl and RegexpFindOnUrl return arrays.


Methods

To work with arrays in Excel your have some options:

Traditional

  1. Select a range of [10Rows] x [1Columns] cells.
  2. Press F2 to go into formula mode.
  3. Type =XPathOnUrl("http://www.google.com/search?q=dogs&num=10","//h3[@class='r']/a","href")
  4. Press CTRL+SHIFT+ENTER to make it a array formula.

Dump & Resize

There are two macro functions in SeoTools to simplify working with arrays in Excel:

  • Dump - Takes an array and Dumps it on the spreadsheet.

  • Resize - Automatically creates an Excel array formula.


Get help with this function in the community →