Export WordPress data to a CSV file

Go to Workflow
0 views
Built by Ravi Patel Ravi Patel
Created on June 15, 2026

Description

Quick Overview
This workflow manually exports all records from a WordPress site, converts the returned JSON into a CSV file, and saves the CSV to disk on the n8n server.

How it works
Starts when you manually click Execute in n8n.
Fetches all available items from your connected WordPress site via the WordPress API.
Converts the WordPress JSON response into a CSV file.
Writes the generated CSV to the n8n server as data.csv.

Setup
Add WordPress API credentials in n8n (site URL, username, and an Application Password).
Choose the WordPress resource to export in the WordPress node and confirm the data shape matches what you want in the CSV.
Update the output file path/name in the file-writing step and ensure the target directory is writable on your n8n host (for example /home/node/.n8n/data.csv).

Nodes Used (1)

Wordpress
n8n-nodes-base.wordpress