Prompt Library

Spreadsheet sorcerer

Generate CSV spreadsheets with various types of data.

Copy this prompt into our developer Console to try it for yourself!

	Content
System	Your task is to generate a CSV spreadsheet containing the specified type of data. The spreadsheet should be well-organized, with clear column headers and appropriate data types for each column. Ensure that the data is realistic, diverse, and formatted consistently. Include a minimum of 10 rows of data, not counting the header row.
User	Create a spreadsheet containing information about books in a library. Include the following columns: Book ID, Title, Author, Genre, Publication Year, and Available Copies. Ensure that the data covers a variety of genres and publication years, and that the number of available copies varies between books.

Example output

Here is a CSV spreadsheet containing information about books in a library, based on your requirements:

Book ID,Title,Author,Genre,Publication Year,Available Copies
1,To Kill a Mockingbird,Harper Lee,Classic,1960,5
2,1984,George Orwell,Dystopian,1949,3
3,Pride and Prejudice,Jane Austen,Romance,1813,7
4,The Catcher in the Rye,J.D. Salinger,Coming-of-age,1951,2
5,The Hitchhiker's Guide to the Galaxy,Douglas Adams,Science Fiction,1979,4
6,The Da Vinci Code,Dan Brown,Mystery,2003,6
7,The Kite Runner,Khaled Hosseini,Historical Fiction,2003,3
8,The Alchemist,Paulo Coelho,Philosophical Fiction,1988,5
9,The Hunger Games,Suzanne Collins,Young Adult,2008,8
10,The Girl with the Dragon Tattoo,Stieg Larsson,Crime,2005,4
11,The Hobbit,J.R.R. Tolkien,Fantasy,1937,6
12,The Diary of a Young Girl,Anne Frank,Autobiography,1947,2
13,The Fault in Our Stars,John Green,Young Adult,2012,5
14,The Catcher in the Rye,J.D. Salinger,Coming-of-age,1951,3
15,The Curious Incident of the Dog in the Night-Time,Mark Haddon,Mystery,2003,4

API request

import anthropic

client = anthropic.Anthropic(
    # defaults to os.environ.get("ANTHROPIC_API_KEY")
    api_key="my_api_key",
)
message = client.messages.create(
    model="claude-sonnet-4-5",
    max_tokens=1000,
    temperature=0,
    system="Your task is to generate a CSV spreadsheet containing the specified type of data. The spreadsheet should be well-organized, with clear column headers and appropriate data types for each column. Ensure that the data is realistic, diverse, and formatted consistently. Include a minimum of 10 rows of data, not counting the header row.",
    messages=[
        {
            "role": "user",
            "content": [
                {
                    "type": "text",
                    "text": "Create a spreadsheet containing information about books in a library. Include the following columns: Book ID, Title, Author, Genre, Publication Year, and Available Copies. Ensure that the data covers a variety of genres and publication years, and that the number of available copies varies between books."
                }
            ]
        }
    ]
)
print(message.content)

Content

System

Your task is to generate a CSV spreadsheet containing the specified type of data. The spreadsheet should be well-organized, with clear column headers and appropriate data types for each column. Ensure that the data is realistic, diverse, and formatted consistently. Include a minimum of 10 rows of data, not counting the header row.

User

Create a spreadsheet containing information about books in a library. Include the following columns: Book ID, Title, Author, Genre, Publication Year, and Available Copies. Ensure that the data covers a variety of genres and publication years, and that the number of available copies varies between books.

import anthropic client = anthropic.Anthropic( # defaults to os.environ.get("ANTHROPIC_API_KEY") api_key="my_api_key", ) message = client.messages.create( model="claude-sonnet-4-5", max_tokens=1000, temperature=0, system="Your task is to generate a CSV spreadsheet containing the specified type of data. The spreadsheet should be well-organized, with clear column headers and appropriate data types for each column. Ensure that the data is realistic, diverse, and formatted consistently. Include a minimum of 10 rows of data, not counting the header row.", messages=[ { "role": "user", "content": [ { "type": "text", "text": "Create a spreadsheet containing information about books in a library. Include the following columns: Book ID, Title, Author, Genre, Publication Year, and Available Copies. Ensure that the data covers a variety of genres and publication years, and that the number of available copies varies between books." } ] } ] ) print(message.content)