Excel FINALLY Has Functions to Import Text & CSV Files (IMPORTTEXT & IMPORTCSV)

In this video, I'll show you two brand new functions in Excel that you can use to import data from text in CSV files.

These two new functions are - IMPORTTEXT and IMPORTCSV

To use these functions, you need to provide the file path that has the file on your system, or a web link from where you want to fetch the data.

The video covers a detailed overview of both functions, including all the arguments and some practical examples where these functions can be very useful.

➡️ Download Excel File: https://www.dropbox.com/scl/fi/83vqunbykns9pdeaofen0/IMPORTTEXT-and-IMPORTCSV.xlsx?rlkey=2fsp7brc76ocxt0jaz91i87um&dl=1

➡️ Text and CSV Files Used in this Video: https://www.dropbox.com/scl/fi/puhct7h5inqz8xtvkud7x/Example-Files-IMPORTTEXT-and-IMPORTCSV.zip?rlkey=d56bac3b6troi34mstn4ja83i&dl=1

00:00 Intro
00:25 IMPORTEXT & IMPORTCSV Overview
05:35 Delimiters in IMPORTTEXT
07:18 Practical Examples

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://trumpexcel.com/excel-vba-course/
✅ Free Power Query Course - https://trumpexcel.com/power-query-course/
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial #SumitBansal

Видео Excel FINALLY Has Functions to Import Text & CSV Files (IMPORTTEXT & IMPORTCSV) канала TrumpExcel