Follow the steps below to have a successful import of your Gmail contacts:
- Go to your contact list in Gmail.
- Click on the ‘More’ button and than ‘Export’.
- Choose export format ‘Google CSV’ and click on ‘Export’.
- Your file will be downloaded on your computer. Keep in mind where it is placed.
- Open Microsoft Excel en choose a new sheet.
- Choose menu item ‘Data’ and select ‘Import external data > text’.
- Choose the Gmail .CSV file.
- As file type you select ‘Separate’ and click on ‘Next’.
- As separator you select ‘Comma’.
- Click on ‘Next’ and ‘Finish’.
- Open the data file in Excel or Numbers.
- Remove errors and weird punctuation like these * :::.
- Save the file on a place you remember in a minute.
- Open your SpinOffice.
- Go to Extra -> Import -> Contacts -> .CSV, XLS or .XLSX format
- Browse the file on your computer and select it.
- SpinOffice will show you what he found as data.
- You only have to match your columns with SpinOffice format.
- We help you with the matching.
- To have a successful match; the fields first name, surname and email address have to be filled.
SpinOffice guides you through the matching proces and gives you a signal when you can implement the import. This way we help you, we prevent failures in your data and you keep your database clean and up to date!