Extract from CSV stops working

Questions
1

Hello,

I’m using an Extract from File Node after a Read from File Node to get data from a CSV. However it stops working after the first 6 (7 if you count the header) lines. There is no difference in the way the CSV is structured between lines. There’s no error message.

Information on your n8n setup

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

hello @Corvin

Can you please provide a sample file?

3 
description|isNew|halal|gluten|lactose|veggie
Aurora Sauce|False|False|True|True|True
Blumenkohl und Brokkoli mit Mandeln|False|True|True|True|True
Butterreis|False|True|True|True|True
Cordon bleu|False|False|False|True|False
Essig & Öl|False|True|True|True|True
Grillschinken mit Honig-Orangenpfeffer-Kruste|False|False|True|True|False
Hähnchenoberkeulenrolle ""Baronesse""|False|True|True|True|False
Joghurt-Dressing|False|True|True|False|True
Karotten-Lauch-Gemüse à la créme|False|True|True|True|True
Kartoffelgratin|False|True|True|True|True
Panna-cotta mit Mangoschaum im Glas|False|True|True|True|True
Pfannengemüse mit Zucchini, Aubergine und Paprika|False|True|True|True|True
Putengeschnetzelte mit feiner Rahmsauce|False|False|True|True|True
Rahmsauce mit Champignons|False|True|True|True|False
Sauce Hollandaise hausgemacht|False|True|False|False|True
Spätzle in Butter gebraten|False|True|False|True|True
gemischter Salat|False|True|True|True|True

This is the used CSV

4

Wild guess on the first thing I see: “&” and “Ö” could mess up some things. When using special chars and spaces it’s usually recommended to put the content in " ".

First thing to try out: remove the & and see if it’s getting processed.

5

Screenshot 2025-03-22 105344
Screenshot 2025-03-22 105344905×484 24.6 KB

It actually reads that one, I don’t think that’s the issue, also it’d be kinda bad for me if I couldn’t use those characters since I need to use them later.

6

Ah okay, in your screenshot there is one more record compared to the sample you’ve posted. Can you share your whole workflow? You can copy the json and paste it here in the </> block.

7
8

Seems the quotes here causing the issue. If you will remove them, will it work?

9

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