Is it possible to parse csv from a SFTP download operation?

Questions
, ,
#1

Describe the issue/error/question

Scenario: Download a csv format file from SFTP and parse it to find certain records and pass the filtered records to next node.

Please share the workflow

image
image1190×816 32.8 KB

image
image3286×1216 163 KB

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:0.177.0
  • **Running n8n via [Docker, npm, n8n.cloud, desktop app]:Docker,npm
#2

Hey @Deshdeep, it’s indeed possible to parse a downloaded CSV file, the Spreadsheet File node would do the job.

The file ending .001 from your screenshot suggests your file could be something else than a CSV though, so you might want to confirm this first.

#3

Hey Mate Appreciate your prompt response :raised_hands: It’s just the file name the format is .csv

1 Like
#4

Excellent, thanks so much for confirming!