Hi, testing n8n rn and I can’t seem to load a simple csv file, which is pretty annoying.
The flow looks like this and is supposed to take in the csv, clean the data & output a cleaned dataset (again i csv)
I’m currently stuck at csv extraction which looks like this;
I spent some time with AI assistant but and he wants me to ensure that binary data is toggled on but there’s no toggle of this sort.
Can you help me ?
what setting do u have on extract from file plz?
Hey! I’ve run into this exact issue before — in my case, it seemed like the original CSV file had something odd going on.
What worked for me was opening the CSV in Excel (or another spreadsheet app), then saving it again as a new CSV file. After that, it loaded just fine.
Hope that helps! 
Oh, I try to do this flow for a week and Thank you very much. 
thank you for your helping
This is my extractor settings:
However, the issue is that Read from Disc doesn’t work as it should (no output). I resaved the file as @Gon mentioned but it didn’t help. Ofc I tried loading from different locations, with different names and triple checked the path to file.
Any ideas on what might help?
Did you manage to fix it? btw this could be because of how ure instance is hosted, are you using dockers? because this path will be /home/node/.n8n/ by default, if you want to access local files and using dockers you need to specify differently.
Let me know if you still need help
Samuel
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
