In this tutorial, We will import external data from a simple CSV file containing customer payments. You can download the CSV file for this exercise.

Download the CSV File

  • Open a new workbook
  • Click on DATA tab on the ribbon
  • Click on From Text button
  • You will get the following window

Connecting Microsoft Excel to External Data Sources

  • Browse to the folder where you downloaded the CSV file
  • Select da.csv file
  • Click on Import button
  • You will get the following import text file wizard

Connecting Microsoft Excel to External Data Sources

  • Click on Next button

Connecting Microsoft Excel to External Data Sources

  • Select Comma on the Delimiters panel
  • Click on Next button

Connecting Microsoft Excel to External Data Sources

  • Click on Finish button

Connecting Microsoft Excel to External Data Sources

  • Click on OK button
  • You will get the following data

Connecting Microsoft Excel to External Data Sources

In some cases you may not get comma separated file, it could be Slash (\), Pipe (|) or other delimiter separated files. Let's take a look at how to deal with them.

Here is sample Slash (\) separated value file that you can download.

Download the Slash (\) separated CSV File

  • Open a new workbook
  • Click on DATA tab on the ribbon
  • Click on From Text button
  • Browse to the folder where you downloaded the file and Import it
  • You will get the following import text file wizard

Connecting Microsoft Excel to External Data Sources

  • Click on Next button

Connecting Microsoft Excel to External Data Sources

  • Now instade of selecting the Comma Delimiter, Select Other and set Slash (\) as delimiter on the Delimiters panel
  • Then click on Next Button.
  • Then click on Finish Button
  • Now Import data in Existing worksheet

You will get the folliwing data

Connecting Microsoft Excel to External Data Sources

 

YOU MIGHT LIKE:
Excel

Excel PDF

Excel is the most powerful tool to manage and analyze various types of Data. This eBook covers...