SpreadsheetFile rearrange result

Hi,

Just one question on the spreadsheet node.
Is there a way to increase the quality of the way the results are shown or it depenses of the json?
For exemple :

It would be better to have something like

Thanks a lot

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

@herrT15 , to get the output depicted in the 2nd image the output in the node that feeds the data into the Spreadsheet node should look like this

[
  {
    "IP": "...",
    "continentCode": "...",
    "continentName": "...",
    "countryCode": "...",
    "countryName": "..."
  },
  {
    "IP": "...",
    "continentCode": "...",
    "continentName": "...",
    "countryCode": "...",
    "countryName": "..."
  }
]

Each property name represents the column, and each item in the array is a spreadsheet row.

Thanks. My json looks like
[

{

“8.8.8.8”:{

“continentCode”:“NA”,

“continentName”:“North America”,

“countryCode”:“US”,

“countryName”:“United States”,

“stateProvCode”:“CA”,

“stateProv”:“California”,

“city”:“Mountain View”

},

“1.2.3.4”:{

“continentCode”:“OC”,

“continentName”:“Oceania”,

“countryCode”:“AU”,

“countryName”:“Australia”,

“stateProvCode”:“QLD”,

“stateProv”:“Queensland”,

“city”:“South Brisbane”

},

“4.3.2.1”:{

“continentCode”:“NA”,

“continentName”:“North America”,

“countryCode”:“US”,

“countryName”:“United States”,

“stateProvCode”:“CA”,

“stateProv”:“California”,

“city”:“Mountain View”

}

}

]

i will try with itemlist

@herrT15 ,

1 Like