Hey there! Let's break down how to fix this Node-RED CSV storage issue—this is a super common hiccup for new folks, so you’re not alone here.

1. First, nail down the correct file path #

A lot of the time, the problem boils down to wrong file paths. Node-RED uses its own working directory (not necessarily where you think it is) when resolving relative paths like ./data.csv.

To find out exactly where Node-RED is running from:

• Add a Function node to your flow, paste this code:

  console.log("Node-RED working directory:", process.cwd());
  return msg;
  

• Deploy the flow, then check the Node-RED logs (either in the terminal where you started it, or the "View Logs" option in the editor menu). The path printed is where relative paths will resolve to.

You can either:

• Use a relative path based on that working directory (e.g., if the working dir is /home/yourname/.node-red, ./my_data.csv will save there)
• Or use an absolute path (like /home/yourname/Documents/node_red_data.csv) to avoid confusion entirely.

2. Check file system permissions #

If you’re getting "directory not found" errors even with the right path, it’s probably a permissions issue. Node-RED runs under a specific user (e.g., node-red on Linux, or your own user if you started it manually), and that user might not have permission to read/write to your target directory.

Fixes:

• Save the file to Node-RED’s working directory (it definitely has permissions there)
• If you need to use a different directory, adjust permissions:
  On Linux/macOS, run this in the terminal (replace /path/to/your/dir with your actual directory):

  sudo chmod 775 /path/to/your/dir
  

  Or add the Node-RED user to the group that owns the directory.

3. Make sure you’re writing valid CSV (and appending correctly) #

Even if there’s no error, if you can’t find the file, double-check what you’re writing:

• The File node needs to have Append mode enabled (toggle it in the node settings). If it’s off, Node-RED will overwrite the file every time, and if the payload is empty, you might end up with a zero-byte file that’s easy to miss.
• Before sending data to the File node, use a CSV node to convert your payload into proper CSV format. If your payload is a JSON object or array, the CSV node will turn it into rows/columns that make sense. Without this, you might be writing raw JSON to the file, which won’t look like a standard CSV.

4. If you’re running Node-RED on a server/Docker #

If Node-RED is hosted on a remote server or in a Docker container, "local" means the server/container’s local storage—not your personal computer.

• For remote servers: Use an SFTP/SCP tool to connect to the server and navigate to the path you configured in the File node. That’s where your file will be.
• For Docker: If you want the file to show up on your local computer, you need to mount a local directory to the container when you start it. For example:

  docker run -d -p 1880:1880 -v /your/local/computer/directory:/data nodered/node-red
  

  Then set your File node path to /data/data.csv—the file will sync to your local /your/local/computer/directory folder.

内容的提问来源于stack exchange，提问作者yi luo