Working with arrays in Excel

A few functions in SeoTools like XPathOnUrl, JsonPathOnUrl and RegexpFindOnUrl return arrays.

To work with arrays in Excel your have some options:


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

Besides beeing quite difficult to master, there also the problem that you need to know the size of the array.

Use Dump() or 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 →