Hello, I’m trying to import data from an Excel spreadsheet in CSV format, but the Data Tables panel doesn’t give me the option. I saw in a video that when creating the table in n8n, it should allow me to import CSV data into my Data Table in n8n, but the option isn’t appearing. I want to import data into this table automatically.
Version 1.121.3 onprem
You first need to use the Extract from file node. Basically your file first needs to be converted to JSON, a format that n8n can work with. then it can insert the individual rows into the data table. Here is the example workflow. So first you need to download the file or choose it from some stored location (for example with the google drive node like in this example. then you extract it from csv or XLSX and then you store it in the data table.
If that helps please mark your question as solved 
Hi @cgl,
You need to upgrade to at least version 1.122 for the csv import option to display.
You can quickly try it by running:
npx [email protected]
version 1.121:
vs 1.122:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
