How to Import Data in Excel

If you have a file that has a different format such as Access, Web and Text, you can use Excel to open them. Please see below how to open a Text file:

Step 1: Click the Data Tab from the ribbon;

Step 2: Click "From Text/CSV" in the "Get & Transform Data" section;

Step 3: Browse and select the file on your computer;

Step 4: Click "Transform Data" in the new window;

Step 5: Click "Close & Load" in the data model;

Step 6: The text data will appear in the Excel.

Leave a Reply