Page 80 - Penta Book's ICT Catalogue

TASK 5
Import and export data

A Comma-Separated Values (CSV) file is a simple file format that is widely used by

scientists and businessmen. As its name suggests, the values in each row of data are
separated by a comma or a tab. CSV files are used to transfer large amounts of data to

and from different companies or applications.

Sometimes, you will need to
import data from a CSV file to

Microsoft Excel. Let’s create a

CSV file. Open your Notepad
and type the following text.

Save the file under the name
contacts.csv

To open a CSV file in Excel: DIGITAL TEENS 2 MODULE 5

> Click the File tab 1 and 1 Computing and ICT . Sample Pages
then click Open. 2
> Click Browse 3 and from
the Open window select
Text Files from the drop-
down list . 4 8

> Select the CSV file you GRADE
want 5 and click Open. 6
4

2 5

3 6

Using the Open
command this way

the CSV file does not
change its format.

Penta Books 79