Skip to content

README.md

Latest commit

 

History

History
66 lines (45 loc) · 1.31 KB

README.md

File metadata and controls

66 lines (45 loc) · 1.31 KB

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