CSV to JSON Converter
Easily convert any CSV (Comma Separated Values) file or snippet to JSON (JavaScript Object Notation) with n8n, a low-code workflow automation tool.
CSV to convert
Alternatively, drop or .csv
file here
(max 2mb)
More workflows for CSV conversions
+5
Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel
How it works:
The workflow starts by sending a request to a website to retrieve its HTML content.
It then parses the HTML extracting the relevant information
The extracted data is storted and converted into a CSV file.
The CSV file is attached to an email and sent to your specified address.
The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use.
Set-up steps:
Change the website to scrape in the "Fetch website content" node
Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node)
Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node).
Mihai Farcas
+2
Upload Bulk Records from CSV - Airtable Interfaces
This workflow is a supporting automation to a common Airtable situation, that as of this writing, has no direct solution but has great demand.
Interfaces are your secret weapon for managing a variety of tasks – from sales funnels and task tracking to creating dynamic dashboards. But here's a common situation: how do you efficiently bulk upload records (like contacts, leads, or clients) from an interface with just a click? Once set up, you'll be able to upload CSV files directly to your tables from the Interfaces with ease.
Workflow Key Points:
1. Bulk Upload Functionality: Say goodbye to the limitations of standard Airtable interfaces. Now, you can upload multiple leads or contacts simultaneously, making your work swift and efficient.
2. Customizable Fields: Tailor the base to meet your specific data needs. This ensures seamless integration with your existing systems and simplifies data management.
Perfect for teams in e-commerce, CRM, or any sector where managing a high volume of leads or contacts is key. Our Airtable Base is designed to eliminate the tediousness of importing contacts. It makes large-scale data management straightforward, saving you precious time and hassle.
Get ready to streamline your operations and boost your productivity! 🚀💡
Sidetool
Import CSV from URL to Google Sheets
This workflow automatically imports data from a CSV file located at a specific URL and then updates the Google Sheets document with the provided data.
Below is a step-by-step description of what this workflow does:
The workflow is started manually using the "When you click 'Execute Workflow'" node.
The CSV file is then uploaded from the specified URL "https://opendata.ecdc.europa.eu/covid19/testing/csv/data.csv" using the "Upload CSV" node.
The "Import CSV" node accepts the uploaded CSV file and converts it into JSON formatted data.
The "Add Unique Field" node generates a unique key by combining the 'country_code' and 'year_week' fields from the JSON data, which will be further used in the Google Sheets document.
The 'Keep only DACH in 2023' node filters the data to keep only records where 'country_code' is either 'DE', 'AT', or 'CH' and 'year_week' starts with '2023'. Google's API has limitations on the speed of read and write operations, so only a subset of the data is taken.
The filtered data is loaded into the specified Google Sheets document via the 'Load to Spreadsheet' node. The operation is set to 'appendOrUpdate' and the document ID and sheet name are specified. Also, the previously generated 'unique_key' key is set as the key to match the columns.
n8n Team
Prepare CSV files with GPT-4
This workflow generates CSV files containing a list of 10 random users with specific characteristics using OpenAI's GPT-4 model. It then splits this data into batches, converts it to CSV format, and saves it to disk for further use.
The execution of the workflow begins from here when triggered manually.
"OpenAI" Node. This uses the OpenAI API to generate random user data. The input to the OpenAI API is a fixed string, which asks for a list of 10 random users with some specific attributes. The attributes include a name and surname starting with the same letter, a subscription status, and a subscription date (if they are subscribed). There is also a short example of the JSON object structure. This technique is called one-shot prompting.
"Split In Batches" Node. This node is used to handle the OpenAI responses one by one.
"Parse JSON" Node. This node converts the content of the message received from the OpenAI node (which is in string format) into a JSON object.
"Make JSON Table" Node. This node is used to convert the JSON data into a tabular format, which is easier to handle for further data processing.
"Convert to CSV" Node. This node converts the table format data received from the "Make JSON Table" node into CSV format and assigns a file name.
"Save to Disk" Node. This node is used to save the CSV generated in the previous node to disk in the ".n8n" directory.
The workflow is designed in a circular manner. So, after saving the file to disk, it goes back to the "Split In Batches" node to process the OpenAI output, until all batches are processed.
n8n Team
FAQs
What is CSV?
What is JSON?
Why convert CSV to JSON?
How do I convert a CSV file to JSON using an n8n converter?
What is n8n?
How was this CSV to JSON converter made?
Is this CSV to JSON converter free?
