# Spreadsheet sorcerer

Generate CSV spreadsheets with various types of data.

---

> Copy this prompt into the developer [Console](/dashboard) 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

<CodeGroup>
    ```python Python
    import anthropic

    client = anthropic.Anthropic(
        # defaults to os.environ.get("ANTHROPIC_API_KEY")
        api_key="my_api_key",
    )
    message = client.messages.create(
        model="claude-opus-4-6",
        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)
    ```

    ```typescript TypeScript
    import Anthropic from "@anthropic-ai/sdk";

    const anthropic = new Anthropic({
      apiKey: "my_api_key" // defaults to process.env["ANTHROPIC_API_KEY"]
    });

    const msg = await anthropic.messages.create({
      model: "claude-opus-4-6",
      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."
            }
          ]
        }
      ]
    });
    console.log(msg);
    ```

    ```python AWS Bedrock Python
    from anthropic import AnthropicBedrock

    # See https://docs.claude.com/claude/reference/claude-on-amazon-bedrock
    # for authentication options
    client = AnthropicBedrock()

    message = client.messages.create(
        model="anthropic.claude-opus-4-6-v1",
        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)
    ```

    ```typescript AWS Bedrock TypeScript
    import AnthropicBedrock from "@anthropic-ai/bedrock-sdk";

    // See https://docs.claude.com/claude/reference/claude-on-amazon-bedrock
    // for authentication options
    const client = new AnthropicBedrock();

    const msg = await client.messages.create({
      model: "anthropic.claude-opus-4-6-v1",
      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."
            }
          ]
        }
      ]
    });
    console.log(msg);
    ```

    ```python Vertex AI Python
    from anthropic import AnthropicVertex

    client = AnthropicVertex()

    message = client.messages.create(
        model="claude-sonnet-4@20250514",
        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)
    ```

    ```typescript Vertex AI TypeScript
    import { AnthropicVertex } from "@anthropic-ai/vertex-sdk";

    // Reads from the `CLOUD_ML_REGION` & `ANTHROPIC_VERTEX_PROJECT_ID` environment variables.
    // Additionally goes through the standard `google-auth-library` flow.
    const client = new AnthropicVertex();

    const msg = await client.messages.create({
      model: "claude-sonnet-4@20250514",
      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."
            }
          ]
        }
      ]
    });
    console.log(msg);
    ```
</CodeGroup>