claude-skills-toolkit

# Automating Data Entry in Excel with Claude Code

## Step-by-Step Guide

1. **Set Up Your Environment**: Ensure you have Claude Code installed and properly configured. You'll need the following Python libraries: `openpyxl` and `pandas`. Install them using pip if you haven't already.

```python
pip install openpyxl pandas
```

2. **Prepare Your Data**: Organize your data in a structured format, such as a CSV file. For this example, we'll assume you have a CSV file named `data.csv` with columns: `Name`, `Email`, and `Phone`.

3. **Write the Automation Script**: Use the following Python script to automate data entry into an Excel file.

```python
import pandas as pd
from openpyxl import Workbook

# Load the CSV file
csv_file = 'data.csv'
data = pd.read_csv(csv_file)

# Create a new Excel workbook
wb = Workbook()
ws = wb.active

# Write the header row
ws.append(['Name', 'Email', 'Phone'])

# Write the data rows
for index, row in data.iterrows():
    ws.append([row['Name'], row['Email'], row['Phone']])

# Save the Excel file
wb.save('output.xlsx')
```

4. **Run the Script**: Execute the script in your Python environment. This will generate an Excel file named `output.xlsx` with the data from your CSV file.

5. **Verify the Output**: Open the `output.xlsx` file to ensure the data has been correctly transferred.