About
In this article we will review how to import a CSV or Excel Workbook into another Excel Workbook.
Environment
Microsoft Excel locally installed on a Mac or Windows computer.
Hint: (This feature does not work on the Web based version of Excel. It only works on the locally installed version.)
Steps
- Open the Excel file you wish to import into.
- Click the Data tab.
- Click Get Data (Power Query)
- Choose the desired data source. Your choices are: Excel workbook, Text/CSV, XML, JSON, SharePoint Online list, OData, Blank table, and Blank query
- Once you click on your desired source, it will take you to a window where you can browse to open your file. Click Browse and your file explorer or finder window will open.
- Select your desired file and click Get Data.
- Note your selected file now shows under connection settings. Click Next at the bottom right to proceed.
- You will be presented with a preview of the data that will be imported. If all looks good, click Load at the bottom right to import.
- Your data will now show in a new tab of your workbook.
For more help, please contact ITS at its@manhattan.edu or 718-862-7973.