Read CSV and Convert to JSON
detail.loadingPreview
Reads a CSV file, processes its content, and writes it as a JSON file.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow reads a binary CSV file from a specified path, processes it using a spreadsheet node, converts the data to JSON format, and then writes the resulting JSON data to a new binary file.
Key Features
- Reads CSV files.
- Processes spreadsheet data.
- Converts data to JSON.
- Writes JSON data to a file.
- Includes error handling.
How To Use
- Ensure you have a CSV file located at
/username/n8n_spreadsheet.csvor update thefilePathparameter in the 'Read Binary File' node. - Configure the 'Spreadsheet File' node if specific parsing options are required.
- The 'Move Binary Data' node is configured for
jsonToBinary, ensure this aligns with your data transformation needs. - The output JSON file will be saved at
/username/n8n_spreadsheet.jsonor update thefileNameparameter in the 'Write Binary File' node. - Execute the workflow manually using the 'On clicking 'execute'' node.
Apps Used
Workflow JSON
{
"id": "f6428fb4-7e2f-4716-96b4-fb5a46f44886",
"name": "Read CSV and Convert to JSON",
"nodes": 0,
"category": "File Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: f6428fb4-7e2f...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Integrations
- Convert To File + Split Out(96 workflows)
- Convert To File + Google Drive(83 workflows)
- Convert To File + Read Write File(52 workflows)
- Convert To File + Telegram(49 workflows)
- Convert To File + Schedule Trigger(48 workflows)
- Convert To File + Form Trigger(46 workflows)
- Read Write File + Split Out(37 workflows)
- Convert To File + Execute Workflow Trigger(37 workflows)
- Convert To File + Gmail(34 workflows)
- Convert To File + Google Sheets(33 workflows)
Related Workflows
Discover more workflows you might like
Convert Any Webpage to PDF and Save Locally
This n8n workflow provides a simple way to convert any public webpage URL into a PDF document. Once converted, the PDF file is automatically saved to your local disk, making it easy to archive or share web content offline.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.
Automate Shipment Tracking with Telegram and n8n
Streamline your logistics operations by automating shipment tracking with Telegram and n8n. This workflow allows drivers to easily share updates, and ensures timely notifications to your team.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.