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
- Click the Data tab on the ribbon.
- Navigate to the Get & Transfer Data group and click the Get Data drop-down arrow.
- For this example, we are going to import from a CSV file. Click the From File button, then choose the From Text/CSV button.
- Browse to the necessary file and select it.
- Once the file is listed in the File Name box, click Import.
- The CSV file will open in a separate window. From here, you have many options available to you:
- 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.
- 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.
- The Import Data dialog box will open.
- 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.
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