XLSX to JSON

Questions
1

Describe the problem/error/question

I am trying to convert binary data that I download that is in the from of XLSX to JSON because I am planning to feed that to vector database. How exactly could that be done? Or, maybe different question, how to create an AI Agent that can talk to very large csv file (~1,000,000 tokens)?

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

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

Hi @Josip_Sare

You’re almost there! Just add another node — “Convert to File” — and select JSON as the Operation to generate the JSON file from the spreadsheet

image
image551Ă—454 18.1 KB

Here’s an example:

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.