jupiter-to-contacts

Convert Excel contact spreadsheets to Google Contacts CSV format.

Installation

pip install -r requirements.txt

Usage

Command Line

# Default: reads ./examples/excel.xlsx, writes ./examples/google_contacts.csv
python main.py

# Custom paths and country
python main.py -i contacts.xlsx -o output.csv -c US

As a Python Module

from src.jupiter_to_contacts import convert_excel_to_google_csv

convert_excel_to_google_csv("input.xlsx", "output.csv", default_country="IT")

Using Individual Functions

from src.jupiter_to_contacts.phone import format_phone_number, get_country_code
from src.jupiter_to_contacts.converter import convert_excel_to_google_csv

# Format a phone number
formatted = format_phone_number("+39 333 1234567", "Italy", "IT")

# Get country code from country name
code = get_country_code("Italy")  # Returns "IT"

Input Format

The Excel file should contain columns for:

• First Name
• Last Name
• Email
• Phone (optional)
• WhatsApp (optional)
• Country (optional, defaults to IT)
• Birthdate (optional)

Each sheet in the Excel file becomes a contact group in Google Contacts.

Output

The output is a CSV file compatible with Google Contacts import.

Requirements

• Python 3.8+
• pandas
• phonenumbers
• openpyxl