# Phone Number Standardizer

This Python script processes your Excel file "aa phone numbers.xlsx" and standardizes phone numbers according to your specified rules.

## What it does:

- **Numbers starting with 6 or 9**: Adds +34 (Spain)
- **Numbers starting with 00**: Changes to + (removes 00)
- **Numbers starting with 47**: Adds + (Norway)
- **Numbers starting with 46**: Adds + (Sweden)  
- **Numbers starting with 45**: Adds + (Denmark)
- **Numbers starting with 49**: Adds + (Germany)
- **Numbers starting with 352**: Adds + (Luxembourg)
- **Numbers starting with 353**: Adds + (Ireland)

## How to use:

### Option 1: Easy way (Windows)
1. Make sure your Excel file is named "aa phone numbers.xlsx" and is in the same folder
2. Double-click `run_phone_standardizer.bat`
3. The script will process your file and create a new file with "_standardized" added to the name

### Option 2: Manual way
1. Install Python packages:
   ```
   pip install -r requirements.txt
   ```
2. Run the script:
   ```
   python phone_number_standardizer.py
   ```

## Output:
- Creates a new file: "aa phone numbers_standardized.xlsx"
- Shows progress and sample results
- Keeps your original file unchanged

## Example transformations:
- `612345678` → `+34612345678`
- `00 34 612345678` → `+34612345678`
- `47 12345678` → `+4712345678`
- `46 12345678` → `+4612345678`
- `45 12345678` → `+4512345678`
- `49 12345678` → `+4912345678`
- `352 12345678` → `+35212345678`
- `353 12345678` → `+35312345678`

## Requirements:
- Python 3.6 or higher
- pandas library
- openpyxl library

The script automatically detects phone columns in your Excel file and processes all of them.