Using the Get Data Feature in Excel 2016

Excel has a great feature for importing data directly into your Excel worksheet.  You can import data from files (Excel, CSV, HTML), databases (Access, SQL), tables, Web, ODBC, etc., making it quicker and easier to share information.  Below are the step by step instructions for using the Get Data feature in Excel 2016.

Using the Get Data Feature
  1. Click the Data tab on the ribbon.Using the Import (Get Data) Feature in Excel 2016
  2. Navigate to the Get & Transfer Data group and click the Get Data drop-down arrow.Using the Import (Get Data) Feature in Excel 2016
  3. For this example, we are going to import from a CSV file. Click the From File button, then choose the From Text/CSV button.Using the Import (Get Data) Feature in Excel 2016
  4. Browse to the necessary file and select it.
  5. Once the file is listed in the File Name box, click Import.Using the Import (Get Data) Feature in Excel 2016
  6. The CSV file will open in a separate window. From here, you have many options available to you:Using the Import (Get Data) Feature in Excel 2016
    • File Origin – Click the drop-down arrow to choose another origin.
    • Delimiter – Click on the drop-down arrow to change the delimiter. Since our example is comma delimited we will leave as is.Using the Import (Get Data) Feature in Excel 2016
    • Data Type Detection – The default is Based on first 200 rows, but it can be changed to Based on entire data set or Do not detect data types.
    • Load button – Clicking Load will load the data as is into the current worksheet. For additional options, click the drop-down arrow and choose Load To.Using the Import (Get Data) Feature in Excel 2016
      • The Import Data dialog box will open.Using the Import (Get Data) Feature in Excel 2016
      • Use the Select how you want to view this data in your workbook to change the view from a Table.
      • If you are importing to an existing worksheet, click Existing worksheet and choose where to put the data.
      • Click Add this data to the Data Model if necessary.
      • Once you have set all the necessary options, click OK.
    • Click the Clean Data button if you need to clean up the data. Once you click the Clean Data button, the file will open in a Power Query Editor.   From this window, you can make any necessary changes, such as removing unnecessary rows and/or columns.Using the Import (Get Data) Feature in Excel 2016
      • For this example, we’ll highlight columns 1 and 2 and click the Remove Columns button to remove them.Using the Import (Get Data) Feature in Excel 2016
      • Once you have “cleaned up” the data, click the Close & Load button.Using the Import (Get Data) Feature in Excel 2016
      • This will load the data into the worksheet.Using the Import (Get Data) Feature in Excel 2016

As you can see, the Get Data feature is a very powerful, yet easy to use feature feature giving you many options for both choosing and manipulating your data.

Click the link to check out my YouTube video on Using the Get Data Feature in Excel 2016 — https://youtu.be/vhJJiO5-a8o

Leave a Reply

Your email address will not be published. Required fields are marked *