Skip to content

Spreadsheet sorcerer (Claude Prompt Sample)

    Generate CSV spreadsheets with various types of data.

    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

    PythonTypeScript
    import anthropic
    
    client = anthropic.Anthropic(
        # defaults to os.environ.get("ANTHROPIC_API_KEY")
        api_key="my_api_key",
    )
    message = client.messages.create(
        model="claude-3-opus-20240229",
        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": "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)
    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-3-opus-20240229",
      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": "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);

    Source: