Wiki-Notes‎ > ‎(2) Communication‎ > ‎

CSV files (Jefferson Byrd)


A CSV (comma separated values) file is an especially formatted plain text file that stores spreadsheet or basic database-style information in a simplified format. A CSV file allows one record per line and each field within that record is separated by a comma or a tab. CSV files are often used as an easy way to transfer a large volume of spreadsheet or database information between programs. For example, email contacts from a spreadsheet may be imported as a contact list on an email server such as Gmail. 

How to Import Contacts Using a CSV File

1. Open the spreadsheet select File > Download as > Comma Separated Values.
2. Open Gmail.com and select Gmail > Contacts at the top left of the page.
3. Scroll to the bottom of the sidebar and select Import contacts.
4. Select the .CSV file from the hard drive. It will most likely appear in the Download folder.
5. The new contacts will appear in the address book as a Contact List.
6. To rename the Contact List, select More > Rename.

7. To create a second Contact List, select the contacts for the second group.
8. Select Groups > New Group and type a name for the new group.
9. To merge the contacts and eliminate duplicates, click the Find & Merge Duplicates warning that appears at the top of the page.

CSV files may also be used as a format to download and save the results classroom surveys. Once the survey is submitted, the data is captured on a spreadsheet in Google Drive. The spreadsheet may be downloaded as a .CSV file for manipulation in other programs. The .CSV file is useful as it is not software specific and can be read by most data processing software.

Comments