After clicking Export, the contacts.csv file will be downloaded to your computer. Open file and review rows and make sure it is properly formatted.
Depending on application where you’ll use the file, some fields are mandatory. Check Gmail or Yahoo requirements for contacts importing.
Excel file with contacts details includes first name, last name, middle name, title, suffix, nickname, email, home phone, business phone, mobile phone, company, job title, department, etc
. There are more additional fields like school, hobby, birthday but they are not obligatory.