If you have a spreadsheet (.xls .xlsx or google spreadsheet and more) in order to upload the contacts to Drove's CRM you'll need to convert the file to .csv
Creating CSV from Google spreadsheet
- open your spreadsheet in Google Drive
![01_-_file.png](https://support.drove.com/galleryDocuments/edbsnf6b29db683772c8ab0281529b2a1a862615fe46e5089e17b5d4a0b9c9adbe3d8212e7263db1f1106355b9b6f2537f210?inline=true)
- Click file then download as and Comma-separated values (.csv, current sheet)
![02_-_download_as.png](https://support.drove.com/galleryDocuments/edbsn126ddc3f4cf6ff27f352a9e3f45df49aaacb1d12c77d8693fff1b162fcf7280305bf8e311011a92e6f8b1ab06e9d623d?inline=true)
- Save the downloaded file and follow the next guide - how to upload CSV file to Drove
Creating CSV from Microsoft excel
Tip: We recommend downloading the template file and copying your contact information.
To download a CSV template file, click here.
In order for the platform to read the data it is important to give a suitable title for each column - name, email, phone.
![Untitled.png](https://support.drove.com/galleryDocuments/edbsn5a91973e3febfd4d7171130317697ed097f83d49f916ab22f2206770307b07fe3ffa7ff923c44bf6b98479f047fa0cf3?inline=true)
Continue - after you finish building the file you want to upload or download the file from Google Drive
1. Click "File"> "Save As"> Select a location to save the file to your computer.
2. ** Very important, please do not skip this step **
If you use other languages then English, you must verify that your CSV file is encoded in UTF-8 encoding otherwise the contact names will appear as question markers. To do this, select "File Type" "CSV-UTF8".
![csv.png](https://support.drove.com/galleryDocuments/edbsnc6e19050c9fa86b181356eb08749d02e17cdc22529a1866d466be4a1314e01fda90a2d45602a6c7492f84b18789242c2?inline=true)
3. Name the file and save.
4. To continue uploading your CSV to Drove click here
Related Articles
Import contacts to Drove with a CSV file
This guide will show you how to import contacts with a CSV file. Learn how to create a CSVfile from a spreadsheet. For other import methods, click here. To import contacts manually, navigate to your contacts tab on Drove Select +Import Contacts ...
How can I import contacts to my page?
At Drove, all your contacts are stored right on the platform, so they are always at your fingertips. At the top of your manager dashboard, you will find the ‘Contacts’ tab. Here you'll find all of your existing contacts. To upload new ones, you can ...
Manually import contacts to Drove
To import contacts manually, navigate to your contacts tab on Drove Select +import contacts Keep Typing email addresses manually selected and click next on the top right corner. Type or copy/paste email addresses in the text field. **Be sure to ...
Send newsletters from any campaign page
Drove allows you quickly and effortlessly to send unlimited newsletters, in one of the following ways: ⇨ Send a Newsletter from any page On the page admin options pick on the top right "promote by email" This will create a new newsletter based ...
Send a generic newsletter
To send a newsletter to your mailing list, click on "Newsletters" at the top of the page and then on Create mail. A new blank newsletter page will open. First, select the target audience of your email - you can send email to all contacts in your ...