Is there a way to make more csv outputs from one csv or make an excel from it with more worksheets?

Questions
, ,
1

Hello!

Currently I would like to autmate a weekly task which I would lke to automate. The task would be that I get a CSV which has some columns and there is a column called Bolt Id. There are 2 possible solutions, which I’m looking for, but currently I can’t get any of them work.

  1. Solution:
    Somehow convert the CSV to an excel, which automatically creates a new worksheet for every distinct “Bolt Id” value, names it as the “Fotós” field value to the “Bolt Id”, then filles the worksheet with the header nad the relevant rows.

  2. Solution:
    Split the CSV file to more CSV files. These basically would work like the solution one, just with CSV files instead of excel worksheets.

Is an of this even possible in n8n? Do you have an other idea for a separation like this?

Thank you for your help.

2

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: