Loading local csv - issue

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 ?

1 Like

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! :blush:

1 Like

Oh, I try to do this flow for a week and Thank you very much. :grinning:

thank you for your helping :grinning:

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?

1 Like

@Caesar_Lastowski

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