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".

Select Ask ChatGPT on the enrichment store
Select Ask ChatGPT on the enrichment store

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.

Define variable
Define variable

You can add a System Prompt to help ChatGPT format its response.

Add System Prompt
Add System Prompt

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.

Create properties to store the results
Create properties to store the results

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.


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.

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.