Translate text between languages

How it works

What it covers

• Translate text using OpenAI models
• Create multiple language columns from one source
• Handle batch translation efficiently

What it uses

Install

terminal

$pip install pixeltable openai

Environment variables it names

OPENAI_API_KEY

Pixeltable calls

openai.chat_completions()pxt.create_table()add_computed_column()insert()

A look at the code

# Add Spanish translation column
spanish_prompt = (
    'Translate the following text to Spanish. Return only the translation, no explanations:\n\n'
    + content.text_en
)

content.add_computed_column(
    response_es=chat_completions(
        messages=[{'role': 'user', 'content': spanish_prompt}],
        model='gpt-4o-mini',
    )
)
content.add_computed_column(
    text_es=content.response_es.choices[0].message.content
)

One cell of the notebook, copied as it is. Open it in Colab for the rest.

• Extract named entities from text

  Identify and extract people, organizations, locations, dates, and other entities from text using LLMs.

  Updated Apr 10, 2026Open in Colab

• Ingest a web page

  Insert a URL as a document, then compare chunking strategies on it

  Recipe · Updated Sep 21, 2026

• Split documents into chunks for RAG

  Break PDFs and documents into searchable chunks for retrieval-augmented generation (RAG) pipelines.

  Updated Apr 10, 2026Open in Colab

• Extract text from PowerPoint, Word, and Excel files

  Transform office documents into searchable, analyzable text data.

  Updated Apr 10, 2026Open in Colab