# Importing Contacts into a Spreadsheet (Excel, Google Sheets and iPhone Contacts)

How to import contacts into a spreadsheet from Excel, Google Sheets or an iPhone, and what each route needs before a player roster is usable.

Importing contacts into a spreadsheet means moving name and phone number fields out of a phone or contact app and into rows and columns, and the route depends on the tool you have. Excel reads a delimited file through Get Data, Google Sheets opens a CSV or vCard file through its Import command, and an iPhone shares contacts as vCard files. Each route produces a plain roster you can sort and edit, which is the starting point for a bracket, a schedule or a round sheet. 

## Exporting contacts as CSV or vCard 

Export contacts as a CSV file when the source app offers it, because a delimited text file opens in any spreadsheet. An iPhone shares selected contacts as a vCard file, and a vCard to spreadsheet step converts those cards into rows. Check that each card holds a full name and one phone number before you share it. A missing field becomes an empty cell that you have to fill by hand later. 

## Opening the file in Excel or Sheets 

Excel Get Data import reads a CSV file and lets you set the delimiter before the rows land on a sheet. Google Sheets Import opens a CSV or vCard file directly and converts the contact fields into columns. Both tools keep name and phone number fields as separate columns when the file labels them. Rename those columns to the player roster columns you want, such as player and contact number. 

## Cleaning the roster before the event 

A contact import often carries labels, extra numbers and duplicates that make a player roster awkward to use. Delete columns you do not need, split combined name fields, and confirm one row per person before you build anything on top of the sheet. A roster with duplicate rows produces duplicate entrants in a bracket. Keep a copy of the clean sheet as the source for every schedule and round update. 

## Questions about contact import into sheets 

### How do I import contacts from my phone to Excel? 

Importing contacts from a phone to Excel works by exporting the contacts as a CSV file and then loading that file with Excel Get Data. CSV stands for comma separated values, a text format that carries one contact per line. Set the file type to delimited during the import so the name and phone number fields land in separate columns. 

### How do I import iPhone contacts into a spreadsheet? 

An iPhone shares contacts as vCard files, so the import needs a spreadsheet that opens vCard or a converter that turns the cards into CSV rows. Google Sheets Import opens a CSV export most directly, and Excel accepts that same file. Select only the contacts you need before sharing, because the file carries every card you pick. 

### Can I import contacts into Google Sheets directly? 

Google Sheets Import accepts a CSV file and places each contact in its own row without extra software. Choose File then Import and pick the upload option, then confirm the separator the file uses. The result is a sheet of name and phone number fields you can rename into player roster columns. 

### What should I check after importing contacts into a spreadsheet? 

Check for duplicate rows, empty phone cells and combined name fields before you use the sheet for an event. One contact should occupy one row, so duplicates create extra entrants in a bracket. Splitting combined names and deleting unused columns gives a clean player roster. Save a copy of the cleaned sheet as the working source.
