hideHeaders

By default, in order to help finding the right filters, the function may display rows headers and columns headers. Hide them by writing one of the following option as third parameter:

  • hideHeaders: hides rows headers and columns headers
  • hideHeaderRow: hides the header row
  • hideHeaderColumn: hides the header column

Example:

=IMPORTJSON(B1, "/topLevelDomain/0", "hideHeaders")

or

=IMPORTJSON(B1, , "hideHeaderRow")