Excel: How to Best Import External Data into Excel & Import data from the Web to Excel
Complete Excel Power Query course: https://courses.xelplus.com/p/excel-power-query
*** Note: On XelPlus you will get additional bonuses that are not available on other platforms. Check the course landing page for more info.
If you'd like to learn the newest version of this feature check out Power Query.
Time Stamps
00:00 How To Properly Import Data to Excel
01:16 How To Use Text to Columns in Excel
03:27 How To Import Data from CSV / TXT files to Excel
09:52 How To Import Data from The Web to Excel
Excel has various tools that can help you easily clean up your raw data for further analysis. Apart from using formulas and formatting, there are two useful Excel features that let you easily clean up. One method is text to columns feature and the other to import external data.
The Get External Data tool can be used to import and analyse data from other systems. This tool is also useful for importing data to run your dashboards or do further analysis using pivot tables, etc. Usually you can get data extracts from any system (e.g. “.dat” or “.csv” from Oracle, “.xml” files from SAP, etc.). These can be imported into Excel.
Importing External Data also gives you control over the decimals and thousand separator, especially if you’re dealing with international companies. In the US, the decimal is dot and the comma is a thousand separator and in most European countries it’s the other way round, where the comma is a decimal and the dot a thousand separator. It’s always safest to Import it properly with the Excel Data Import wizard!
After importing press Ctrl + T to create a table out of it. You can create a pivot table off this one, and when you do, even if you add more data to it, the pivot reflects the new data.
Importing Data from the Web / Internet into Excel – creating web queries that refresh automatically:
In Excel you can also import data directly from the web. You basically create a web query which you set to refresh automatically based on your preference.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Excel: How to Best Import External Data into Excel & Import data from the Web to Excel канала Leila Gharani
*** Note: On XelPlus you will get additional bonuses that are not available on other platforms. Check the course landing page for more info.
If you'd like to learn the newest version of this feature check out Power Query.
Time Stamps
00:00 How To Properly Import Data to Excel
01:16 How To Use Text to Columns in Excel
03:27 How To Import Data from CSV / TXT files to Excel
09:52 How To Import Data from The Web to Excel
Excel has various tools that can help you easily clean up your raw data for further analysis. Apart from using formulas and formatting, there are two useful Excel features that let you easily clean up. One method is text to columns feature and the other to import external data.
The Get External Data tool can be used to import and analyse data from other systems. This tool is also useful for importing data to run your dashboards or do further analysis using pivot tables, etc. Usually you can get data extracts from any system (e.g. “.dat” or “.csv” from Oracle, “.xml” files from SAP, etc.). These can be imported into Excel.
Importing External Data also gives you control over the decimals and thousand separator, especially if you’re dealing with international companies. In the US, the decimal is dot and the comma is a thousand separator and in most European countries it’s the other way round, where the comma is a decimal and the dot a thousand separator. It’s always safest to Import it properly with the Excel Data Import wizard!
After importing press Ctrl + T to create a table out of it. You can create a pivot table off this one, and when you do, even if you add more data to it, the pivot reflects the new data.
Importing Data from the Web / Internet into Excel – creating web queries that refresh automatically:
In Excel you can also import data directly from the web. You basically create a web query which you set to refresh automatically based on your preference.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
Видео Excel: How to Best Import External Data into Excel & Import data from the Web to Excel канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Get Latest Stock Data in Excel & Create Your Own Stock PortfolioL-system VR180 metadata testEasily Import Data from Web to Excel (2 Practical Examples)Excel Picture Lookup: 5 easy steps for dynamic images4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!)Import Series - Import CSV TXT File into ExcelSearchable Drop Down List in Excel (Very Easy with FILTER Function)How to Convert PDF to ExcelThis Excel Chart will grab your attention (Infographic template included)Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)SUPER EASY Excel Data Entry Form (NO VBA)Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)MS Excel - Import Live Data From Web to ExcelHow to easily automate boring Excel tasks with Power Query!Excel MOD Function - Easy Explanation & Practical Examples of MOD for WorkProperly Convert PDF to ExcelLearn Macros in 7 Minutes (Microsoft Excel)