Moving your contacts from Gmail to a spreadsheet is one of those tasks that sounds like it should be complicated, but it’s actually a breeze once you know where the "Export" button is hiding!

Think of this as moving your digital address book into a neat, organized filing cabinet. Here is your step-by-step guide to getting it done.

Step 1: Head Over to Google Contacts

Gmail handles your emails, but Google Contacts is where your addresses actually live.

• Open your web browser and go to contacts.google.com.
• Make sure you are logged into the correct Gmail account.

Step 2: Choose Who to Export

You might want everyone, or just a specific group of people.

• To export everyone: You don’t need to click anything! Just look at the menu on the left side of the screen.
• To export a specific group: If you’ve organized people into "Labels" (like "Work" or "Family"), click that Label in the left sidebar first.

Step 3: Use the Export Tool

Now we’re going to package those contacts up into a file your computer can read.

1. On the left-hand menu, click on Export.Note: If you don't see it, look for a "Print" or "More" icon—sometimes Google hides it under a "Frequently contacted" list.
2. Note: If you don't see it, look for a "Print" or "More" icon—sometimes Google hides it under a "Frequently contacted" list.
3. A little window will pop up. Under "Export as," make sure you select Google CSV.
4. Click the blue Export button.
5. Your computer will download a file (usually named contacts.csv). You don't even need to open it yet!

Step 4: Move the List into Google Sheets

Now for the magic trick: turning that file into a spreadsheet.

1. Open a new Google Sheet.
2. In the top menu, click File and then select Import.
3. A window will pop up with several tabs. Click the Upload tab.
4. Drag that contacts.csv file you just downloaded into the window, or click "Browse" to find it in your Downloads folder.
5. On the next screen, for "Import location," choose Replace spreadsheet.
6. Click Import data.

You’re All Set!

Your Google Sheet should now be filled with names, emails, and phone numbers, all neatly organized into columns.

Friendly Hint: If the sheet looks a bit messy with a bunch of empty columns, don't worry! Google exports every possible detail (like "Notes" or "Job Titles"). You can simply right-click the top of any empty columns and select Delete Column to clean it up.