Loadshedding Issues. We are experiencing intermittent downtime with our phone lines. Click here to contact support.

[how to] Open a CSV file in Excel?

icon csv

CSV, or comma-separated values, is a common format for storing and transmitting content including contacts, calendar appointments and statistical data. Excel reads CSV files by default but in most cases when you open a CSV file in Excel, you see scrambled data that’s impossible to read.

This article shows how easy it is to properly open CSV files in Excel and view them without the need to convert anything.

1. Open a new Excel document and navigate to the Data tab.excel sheet data tab

2. Click “From Text”.excel import from text function

3. Navigate to the CSV file you wish to open and click “Import”.import csv file to excel

4. From the newly-opened window, choose “Delimited”. Then click “Next”.text import wizard in excel 1st step delimited

5. Check the box next to the type of delimiter – in most cases, this is either a semicolon or a comma. Then click “Next”.text import wizard in excel

6. Click “Finish”.excel text import wizard complete

That’s it; you have just imported a CSV file to Excel!csv contacts in excel

Sign up for a free trial!

WANT TO TRY OUT BULKMAIL?
THE FREE ACCOUNT GIVES YOU 100 FREE CREDITS TO TEST DRIVE THE APPLICATION
(LIMITED TO 20 EMAIL ADDRESSES).

About Us

It's never been easier to build your own newsletter or select and customise a free template with BulkMail email service.

Try out the best bulk email software today, create your email campaign and send bulk email.

Contact Us

Click here to send us a message.

Office Hours
Mon-Thur 09h00 - 16h00
Fri 09h00 - 13h00

Office
+27 (0)21 100 4433

Address
Unit 105, 1st Floor
Newlands Quarter
Cnr. Dean & Main Street
Newlands, 7700, Cape Town