Save as CSV (Text Tutorial)

To upload a list to VerticalResponse it needs to be saved in Comma Separated Values (.csv) format. Below you’ll find instructions on how to save spreadsheets, databases and contact lists as CSV using a number of different programs. If the program you’re using is not listed below, use the help and documentation provided within that program to find out how to save as CSV.

Jump to:
Microsoft Excel

Outlook Express
Outlook ‘03 and ‘07
Hotmail, Gmail, Yahoo
ACT!
Filemaker Bento
Apple Numbers
Apple Mail / Address Book
Salesforce

Microsoft Excel

1. Go to File
2. Click “Save As”
3. Use the Format drop down menu to choose Comma Separated Values (.csv)
4. Give your file a name and choose where on your computer you’d like to save it
5. Click Save

Outlook Express Address Book

1. Go to File
2. Click Export
3. Select “Address Book”
4. Choose to create and save a Text File (Comma Separated Values)
5. Click “Export”

Outlook ‘03 and ‘07 Address Book

1. Go to File
2. Click Import and Export
3. Select Comma Separated Values (Windows) and click “Next”
4. Select the “Contacts” folder and click “Next”
5. Give your file a name and choose where on your computer you’d like to save it
6. Click Next and then Finish

Hotmail, Gmail, or Yahoo Address Book?

Use our simple Web Address Book Import Tool to create your list.

ACT!

1. Open the ACT! Database that contains the records you want to export
2. Go to “File”
3. Select “Data Exchange”
4. Click “Export”
5. This will open the “Export Wizard.” From here, use the “File Type” drop down menu to choose “Text-Delimited”
6. Select the “Browse” button for Filename and Location
7. Enter a name for your file in the File Name box and use the “Save as Type” drop down to select “Text - Delimited (.csv)”
8. Click “Save” and then click “Next”
9. Select “Contact Records Only” and click “Options.” This will open the Export Options dialog box
10. From within the “Select Field Separator” box, check “Comma”
11. From within the “Do You Want to Export Field Names” box, check “Yes, export field names”
12. Click “OK” and then click “Next”
13. Now select which contact records you’d like to export “Current Record” will only export the single record you have selected. “Current Lookup” exports all the records that match your current lookup. “All Records” exports the entire database
14. Click “Next”
15. Choose which fields you want to export as part of your list. Be sure to include email addresses or - as you might expect - you won’t be able to send out an email
16. Click “Finish” to export the file

Filemaker Bento

1. Go to File
2. Click “Export”
3. Select the “Text” option
4. Choose whether you want to export “All records” or “Only current records.” And whether you want to include “All table view fields” or “Only fields displayed in table view”
5. Use the Format drop-down menu to select Comma separated (csv)
6. Click Next
7. Name your File and click “Export”

Apple Numbers

1. Go to File
2. Click “Export”
3. Choose CSV
4. Select Unicode (UTF-8) from the Text Encoding drop down
5. Click “Next”
6. Name your File and click “Export”

Apple Mail / Address Book

The Apple Address Book cannot export records to a CSV file - it can only export records as vcards. As a result you’ll need to download a utility that can either create CSV files from the address book or convert vcards to CSV. The download page on Apple’s website provides access to several such utilities that may work for you. Take a look at this page and search for some variation of “address book csv.”

http://www.apple.com/downloads/macosx/

Salesforce

Salesforce users should use VerticalResponse for AppExchange. This integrates your VerticalResponse account directly with your Salesforce lead & contact records. There is no additional fee for using the Salesforce version of our application.