ChatGPT is perfect for translating your CSV/Excel files

ChatGPT is a language model developed by OpenAI. It grasps the contextual meaning of texts with nuances of grammar, syntax, and semantics.

This makes ChatGPT a perfect technology for translation. This level of precision is essential for translating legal documents, technical manuals, and other sensitive materials where accuracy is paramount.

ChatGPT/OpenAI's versatility shines through its ability to handle a wide range of languages and genres. It can seamlessly translate between over 100 languages, including major and minor tongues, ensuring that users can connect with people from all corners of the globe.

How much does it cost to translate with ChatGPT?

ChatGPT stands out not only for its linguistic prowess but also for its exceptional cost-efficiency. It is cheaper than Deepl or Google Translate for almost similar translation quality.

Datablist Enrichments work with a credit system. You receive credits with your monthly plan and you can buy non-expiring credits with top-ups.

Datablist ChatGPT/OpenAI translation enrichment costs 5 credits for 1000 characters.

A $20 top-up gives you 20,000 credits. A translation of 1000 characters costs $0,005. Or $5 for 1,000,000 characters.

A $150 top-up gives you 200,000 credits (25% discount). A translation of 1000 characters costs $0,00375. Or $3.75 for 1,000,000 characters.

Learn more about the Datablist Credits System.

How to translate a CSV/Excel file with ChatGPT?

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

Create a new collection and import your file.

Step 2: Select the "Translate with OpenAI/ChatGPT" enrichment

Click on the "Enrich" button in the header, and search for "Translate with OpenAI/ChatGPT".

Select Translate with OpenAI/ChatGPT on the enrichment store
Select Translate with OpenAI/ChatGPT on the enrichment store

Step 3: Select the target language and the column to translate

After selecting the enrichment, a drawer opens. The first step is to configure the target language for your translations.

Then, you need to select which column (=property) of your data to translate. Use the drop-down button with "Text to translate" to select one of your data columns.

Notes
This enrichment translates the text from one column. To translate several or call your columns, you have to run the enrichment several times. Once on each column.

Select target language
Select target language

Step 4: Define where to store the results

To avoid losing data, the translated texts will be stored in a new property. In the "Output" section, click on the "+" button to define a new property that will be used to store the translations.

Create a property to store the results
Create a property to store the results

Step 5: Run the translation

Once your configuration is fine. Click the "Run enrichment" button to process your data.

FAQ

How long does it take to translate my data with ChatGPT?

ChatGPT is slower to process text than Google Translate or Deepl. Datablist speeds translations by running parallel ChatGPT tasks.

And for a better user experience, this enrichment runs asynchronously. Once started, the data is sent to our servers that manage the calls to ChatGPT. You don't have to wait in front of your screen for it to finish. Just come back later to get your translated files.