Page 82 - Penta Book's ICT Catalogue

You can also import data from a CSV file into the existing or a new Excel worksheet.
Unlike the previous method, this is helpful because it does not simply open CSV in
Excel but data can be formatted and analyzed more easily.

Import data from a TXT or CSV file: Other than and commas,

in a CSV file, columns
> On the Data tab, in the Get & Transform Data group, may be separated by other
click From Text/CSV. 1
characters such as “;”or “.”
> Locate and click contacts.csv. 2 or a space.
> Click Import. 3 The contacts.csv window will appear.
> Click Load. 4 to import a delimited fi le.

1

2

3 DIGITAL TEENS 2 MODULE 5 Computing and ICT . Sample Pages

Delimiters defines 8
the character that
separates values in GRADE
your text file.

4

When you import
a csv file it is
automatically
coverted to a table.

SMART TIP

You can also convert to range by right-
clicking the table, and clicking Table. 81
Penta Books