Source: https://docs.claude.com/en/resources/prompt-library/spreadsheet-sorcerer

Agent Skills are now available! Learn more about extending Claude's capabilities with Agent Skills .

Claude Docs home page

English

Search...

Ctrl K

Search...

Navigation

Prompt Library

Spreadsheet sorcerer

Home Developer Guide API Reference Model Context Protocol (MCP) Resources Release Notes

On this page

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

Python

TypeScript

AWS Bedrock Python

AWS Bedrock TypeScript

Vertex AI Python

Vertex AI TypeScript

Copy

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)

Was this page helpful?

YesNo

Philosophical musings Sci-fi scenario simulator

Assistant

Responses are generated using AI and may contain mistakes.