readme.md

The purpose of this is to take JSON data exported from Google Contacts (use a CSV to JSON converter to get it in this format), then properly format US phone numbers. Once done, convert back to CSV and reimport into Google Contacts.

I needed this while traveling.

convert.js

const exportedGoogleContacts = [...]

const updatedContacts = jonsContacts.map(contact => {
	let modifiedContact = {}
	Object.keys(contact).forEach(key => {
		const value = contact[key]
		if (!value) {
			return
		} else if (String(value).length > 10 && String(value).replace(/[^0-9\+]/g, '').length >= 10 && value.length < 20) {
			const formattedPhone = formatNumber(value);
			console.log(`converted ${value} to ${formattedPhone}`)
			if (!formattedPhone) {
				modifiedContact[key] = value
			} else {
				modifiedContact[key] = formattedPhone
			}
		} else {
			modifiedContact[key] = value
		}
	})
	return modifiedContact
})

console.log(JSON.stringify(updatedContacts))

function formatNumber(number) {
	// remove all non-numeric characters except +
	number = number.replace(/[^0-9\+]/g, '');
	// if there are no numbers
	if(number.length < 8) {
		return number;
	}
	// if the number starts with a plus, do nothing
	else if(number.charAt(0) == '+') {
		return number;
	}
	// if the number starts with a 1
	else if(number.charAt(0) == '1') {
		//add plus
		number = '+' + number;
		return number;
	}
	else {
		number = '+1' + number;
	}
	return number;
}