How to run ChatGPT on each Excel or CSV line (in bulk)?
Running ChatGPT prompts in bulk can be a useful approach when you have a list of items and want to generate responses for each of them.
But ChatGPT's web interface is designed for interactive use, making it challenging to perform bulk operations directly on the chat interface.
With Datablist, you can write a prompt using variables. The prompt will then be run for each item and Datablist will take care of replacing the variables with your item's data.
And if you have used ChatGPT API, you know it can be challenging to deal with rate limits and parallelization. Datablist handles that for you and will retry unsuccessful calls.
Step-by-step guide
Step 1: Load your CSV or Excel file on Datablist
Create a free account and import your data file. Datablist is a powerful CSV editor. Perfect for opening large CSV files or Excel files with a list of items.
Create a new collection and import your file.
Step 2: Select the "Ask ChatGPT" enrichment
Click on the "Enrich" button in the header, and search for "Ask ChatGPT/OpenAI".
Step 3: Write your prompt with variables
After selecting the enrichment, a drawer opens. Write your prompt and use the characters {{ to add a variable. All your text-compatible properties (=fields) can be used as variables.
You can add a System Prompt to help ChatGPT format its response.
Step 4: Define where to store the results
ChatGPT returns a text for each item. You must define where this text will be stored. You can create a new property or map an existing property.
Step 5: Check the results on 10 items and run on all your data
To avoid mistakes and to let you experiment with different prompts, Datablist runs the prompts on 10 items first. You can see the results in real time. When the results match your expectations, click "Run" to process your remaining items.
FAQ
How much does it cost?
This enrichment is free to use. But you need to use your own OpenAI API Key and you will be charged directly by OpenAI.
Warning
You must have credits on your OpenAI balance. This enrichment won't work with a free OpenAI account without credits.
How to create an OpenAI API Key
Create an account on the OpenAI Platform. Then go to the API Keys page and click "Create new secret key".
Can I run ChatGPT on a large CSV?
Datablist opens large CSV files without breaking a sweat. Datablist is the perfect tool to run ChatGPT on a large CSV file.
Use cases
Running a ChatGPT prompt on a list of items can be beneficial in various scenarios where natural language processing is required. Here's a list of use cases:
Email intro for cold emailing
Generate initial drafts for emails. Use personal info from each contact profile to write a personalized email.
Language Translation
ChatGPT is perfect for translating phrases or sentences from one language to another with ease.
Data Cleaning
ChatGPT can be used to clean your Excel or CSV files. If can correct text cases, fix grammar and typos, normalize company names, etc.
Social Media Posts
Stay ahead of your social media schedule by generating posts for your social media accounts.
Product Catalog processing
Generate summaries from product descriptions, or generate descriptions from your product characteristics.