Skip to content

CSV converter (Claude Prompt Sample)

    Convert data from various formats (JSON, XML, etc.) into properly formatted CSV files.

    Content
    System
    As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.
    User
    Please convert the following JSON data into a CSV file:
    
    [
    {
    "name": "John Doe",
    "age": 30,
    "city": "New York",
    "email": "[email protected]"
    },
    {
    "name": "Jane Smith",
    "age": 25,
    "city": "London",
    "email": "[email protected]"
    },
    {
    "name": "Bob Johnson",
    "age": 35,
    "city": "Paris",
    "email": "[email protected]"
    }
    ]
    
    Requirements:
    - Columns in the CSV should be in the order: name, age, city, email
    - Use semicolons (;) as delimiters
    - Enclose all values in double quotes (")

    Example output

    Based on the provided JSON data and requirements, here's the converted CSV file:
    
    CSV
    
    "name";"age";"city";"email"
    "John Doe";"30";"New York";"[email protected]"
    "Jane Smith";"25";"London";"[email protected]"
    "Bob Johnson";"35";"Paris";"[email protected]"
    
    Explanation:
    
    The first line of the CSV file contains the column headers: "name", "age", "city", and "email", separated by semicolons (;) and enclosed in double quotes (").
    Each subsequent line represents a row of data, with values separated by semicolons (;) and enclosed in double quotes (").
    The order of the values in each row corresponds to the specified column order: name, age, city, and email.
    Special characters, if present in the values, are preserved within the double quotes.
    
    To save the CSV file:
    
    Copy the CSV data provided above.
    Open a text editor (e.g., Notepad, TextEdit, or any other plain text editor).
    Paste the CSV data into the text editor.
    Save the file with a .csv extension (e.g., data.csv).
    Note: When opening the CSV file in a spreadsheet application (e.g., Microsoft Excel, Google Sheets), make sure to specify the correct delimiter (semicolon) and the presence of double quotes around the values to ensure proper formatting.

    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="As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
        messages=[
            {"role": "user", "content": "Please convert the following JSON data into a CSV file:\n\n[\n  {\n    \"name\": \"John Doe\",\n    \"age\": 30,\n    \"city\": \"New York\",\n    \"email\": \"[email protected]\"\n  },\n  {\n    \"name\": \"Jane Smith\",\n    \"age\": 25,\n    \"city\": \"London\",\n    \"email\": \"[email protected]\"\n  },\n  {\n    \"name\": \"Bob Johnson\",\n    \"age\": 35,\n    \"city\": \"Paris\",\n    \"email\": \"[email protected]\"\n  }\n]\n\n\nRequirements:\n- Columns in the CSV should be in the order: name, age, city, email\n- Use semicolons (;) as delimiters\n- Enclose all values in double quotes (\")"}
        ]
    )
    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: "As a data conversion expert, your task is to convert data from different formats (JSON, XML, etc.) into properly formatted CSV files. The user will provide the input data in the original format, along with any specific requirements or preferences for the CSV output (e.g., column order, delimiter, encoding). Ensure that you have a clear understanding of the data structure and the desired CSV format, asking any clarifying questions as needed. Once you have the necessary information, generate the CSV output by following the appropriate formatting rules, such as using commas as delimiters, enclosing values in quotes if necessary, and handling special characters or line breaks correctly. Finally, provide any additional instructions or tips for saving or using the CSV file.",
      messages: [
        {"role": "user", "content": "Please convert the following JSON data into a CSV file:\n\n[\n  {\n    \"name\": \"John Doe\",\n    \"age\": 30,\n    \"city\": \"New York\",\n    \"email\": \"[email protected]\"\n  },\n  {\n    \"name\": \"Jane Smith\",\n    \"age\": 25,\n    \"city\": \"London\",\n    \"email\": \"[email protected]\"\n  },\n  {\n    \"name\": \"Bob Johnson\",\n    \"age\": 35,\n    \"city\": \"Paris\",\n    \"email\": \"[email protected]\"\n  }\n]\n\n\nRequirements:\n- Columns in the CSV should be in the order: name, age, city, email\n- Use semicolons (;) as delimiters\n- Enclose all values in double quotes (\")"}
      ]
    });
    console.log(msg);

    Source: