How to Easily Import External Data into Excel & Import Data from the Web 

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter Discover the latest enhancements to import data into Excel here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EOhSODFLqic.html

I must say I am impressed. I started working in excel two months ago, I thought I was a five on a scale from 1 to 10 but now I think I am a 2. The amount of knowledge that you have is astonishing. And the fantasy too. You have to have an immense knowledge of excel to use formulas as you do. How long have you been using it? Ps. After 13 hours of working it's 2:10 am and I am watching all of your videos. Thanks for sharing your knowledge.

This is all great stuff. You can connect to databases half way around the world and pull stuff into your spreadsheet. You can even do some macros that will rearrange the columns as needed and do calculations for you. Really powerful stuff.

I have interview on Thursday next week and this vlog has helped me enormously with the assessment I will have to complete. Thank you x.

Madam, I improved my self in excel because you’re videos. Thank you

You have identified an oft-underused aspect of Excel. Good job.

Wonderful. Usually we do only text to column; but the web import and other import is not something we use on recurring basis. This is therefore absolutely important video. Thanks for throwing light on the subject.

You are one of the best excel expert. You pick good topics and explain it very well. I'm growing fond of excel more and more, thanks to you!

Thank you,your teachings are great for New Beginners in Excel

I discovered you today and you answered my question straight away. Am about to test the data and My Word amd I glad I found you!

سلام خواهر عزیزم لیلا جان شما واقعا افتخار ما هستید .

Note that the "From Web" Import is only available on Windows, not Mac. Great video as always Leila.

Your slowly step by step briefing method helps me lot. Fast showing is just shows your skills but not understand many people. thanks for helping us...keep going with the slow method.

Can you do a video on importing data from a website you have to sign in before you can view the data?

Leila, u r such a darling! You just landed me to my exam room with a confident smile. Excellent job!!!

Thanks this helped a lot...

What a difference a few years makes...

Thanks a lot

Quite useful, Text to column does have many features as you have shown here and in other posts. Importing to excel was also handy but making changes in excel and re-export to system is often unexplored. Good one again

Respected Madam, Am fan of your videos and new idea thoughts… Am impressed valuable lessons… Really I tired lot and output was no result.. First off all am beginner of learner in excel... I need your help/idea in excel…. In work sheet1 I want two (2) things 1. Search box and display the output there from work sheet2/3/4 are etc. 2. Automatically transfer data and save the data from work sheet1 into work sheet2/3/4 are etc.. Whether it is possible to do like this I don’t know!! Am regularly watch your videos. I hope you and needful to me and who are following your's students of richest ideas and thoughts from your videos...

You are best

I thoroughly enjoy your excel training videos and appreciate that you began adding the excel file and step by step written instructions to refer to as a guide. I have a request. Many companies use quick books; however, the reporting is not as visually appealing. Is there a way for excel to connect directly to QB desktop (.QBB or .QBW source files) or online files in orders to make financial reporting and visualization to dynamic to easily prepare monthly financial reporting package? I watched your videos similar to this one, ability to connect to websites, and other excel files. But haven’t found anything that directly addresses my need. Any insight, instructional video or training would be greatly appreciated.

Thanks for the video. I need help on how to record the pulled data, that is periodically refreshed, on another sheet. For example, if I need to track a record of stock price movement automatically, how would I do that? If you already have a video on this, then please provide the link.

Thank you for this, really helpful

Thanks for the hot chili pepper. Cool!. (dichotomy 😎) Nice visual aid.

Thank you ma’am great content

Hey, I find this very helpful & you were very calm throughout the video and yeah, subscribed to your channel. Love

In Excel, sheet1 range B1:B200 contains many website links of zip files, download the zip file of all those links together and keep them in the same folder using vba, make a video for that.... Thanks

Hello ma'am can you show video web scraping and data scraping full video on RU-vid and use in which software easy to use

Wonderful, great job ضخمة بيم محد كماش لا

1:40 should be "highlight the cells" not 'highlight the column'. Great video.

Thanks leila.

Thanks Leila. This is excellent and will be very helpful for me! Keep up the good work!

you save my ass for tomorrow meeting! thanks babe

Thanks Leila

saved me few hours. Kudos !

Do you have a video to show how to insert number of column/columns according to the specified number. e.g input data = 5, insert 5 columns automatically. If not, will you do one please

Hello. I enjoyed your lesson. I have a little problem. After importing the file and saving as csv file on my excel. The numbers I changed didn’t reflect on my work pad

You are such a great tutor, Thanks !!

Very useful data import tips for Excel

While importing data from excel it is using internet explorer as a default browser. Actually, I want to change it to chrome . is it possible.

Thanks for the upload - it´s a nice tutorial. I had some challenges when importing stock prices to Excel via an external data source (an American website) and the price was quoted with a comma as a thousand separator and a dot as the decimal and my Excel had a European setup. Like you described in the video I just used used "Text to columns" and stated under "advanced" that I wanted the dot as a thousand separator and the comma as the decimal. Problem solved 😉

Do you have a video on how to import SharePoint list columns into a word doc stored in OneDrive for business

Good job. Not exactly what I was looking for but you were very clear and I like the hot tip. I will watch for other videos as I continue to develop my process system.

Is there a video on importing data from text throug office 365? Because that's just totaly different and i cannot figure out how to get my data straight.

Hello Thank you for the awesome video. could i use this to copy stock data exported from a point of sale from one csv to another template for import to a new csv? Thanx

In Excel any function to see data import source see and all activities done in Excel to see

Thanks.

excellent video, thanks alot for these easy to understand videos.

MANY THANKS FOR ALL THE THINGS I'VE LEARNED FROM YOU

I like the tutorial!!

usefull video thank u

How to import data by function for example importxml and SAVE data automatically?

export the paper packaging, paper bag, paper box, etc.

Hello, I have a question. If we use data from web, & checkmark the box that says refresh data. Considering the example in the video will the stock market values in +/- get updated automatically ?

Hi there, is there any way I can import Excel spreadsheet into Xplan document vault?

Thank you for the video.

Great job. thanks.

Don't really care about what NOT to do or why. Care only about How to do something step by step. Skip to 1:15

Why by importing csv file into ERP software - all my data end up in one cell? I do choose the right delimitor

Thank you thank you!! You are making me smart!

Very useful

How do you trigger this process with a macro? I download a csv file daily from the web. The filename changes daily and has no extension. I perform the import manually by downloading the file to a local drive, then Data >> Import External Data >> Import Data >> browse to Downloads folder >> FileFilter = All Files (*.*) >> select file and click Open. I cannot get a macro to open the Select Data Source dialog box and default to the Downloads directory with FileFilter = (*.*) then allow the user to select the file to import. External Data Range Properties will also need to be specified as a new default. Maybe you've already posted a video on this? I have Excel 2003 with Visual Basic 6.5.

How to import data from pdf file, plz make a video on that

Can I ask if you can use the text to column or even format data extracted from a website without risking the data running awry whenever you refresh the extracted dataset?

Thanks in a million!

hi, would be possible to do the same with google sheets, I have data in my laptop every time I add more data to the workbook, I would like the google sheet get updated as well, vice versa.???

Hey.. i am learning from you via UDEMY also.

Will this work to import all Utube video url data from monthly filtered history to an EXCEL file ?? Appreciate yr confirmation Thx

4:22 How would we import a .txt file into Excel which has NO structure at all - no coma separators, just a bunch of spaces, but no logic to it. There could be columns in the data, but the import file doesn't separate the text that way - and also has a bunch of repeating headers at the top of each page? I am just curious. Thanks.

Can you show me how to make csv file

This what I need. .. Thanks

I understood it very well & thank you!!!!!!!

We can use flash fill right??

I want copy two different documents I want to copy the sheets of one excel project into the other with messing it up

Hi Leila I’m using Office 365. But when I tried to import the currencies web data (shown at the 10mins 33 mark in this video) the ‘navigator’ window in Excel wouldn’t let me highlight or copy the data. Do you know why that may be? Thanks in advance.

Hello Ma'am.. Is it possible to download excel file from web automatically and save it in a specific folder via macro or power query or with any other features?????

and also pls upload the excel files with direct link where i/we download directly the video tutorial file without any hassle...

while i copy paste data from our company's ERP to Excel spreadsheet it does not work. Neither Vlookup, nor SUM formula are working. can you help me

Vielen Dank😍. Can you Show this with REST API. PLEASE. 🥺😍🥰

0:42 0:52 technically speaking, "decimal separator" should have been used instead of "decimal" since decimal is a number whereas decimal separator is a symbol. however, i think "decimal separator" is a misnomer, since "thousands separator" is also a separator in a decimal. so, "decimal separator" should be renamed to "integer-fractional separator", as that term indicates where the separator is in the number.

Excellent Video, Thank you!

Would be good to see other sources like sql and nosql

How do I separate 1 column address into Street column, City Column, ZIP, STATE. One time I received a lot data more than 200 rows and the whole address was put in 1 column, I could leave like that in a emergency, but I need to split the address column mentioned above. I spend 2 hours to figure out or clean the address, what a mess. Example: 201 17th Street, apt 15, Anaheim, CA. i had to multiply the colums and search and replace. When it's between commas its easier to split, when street and city has no commas, difficult to clean by searching and replacing.

What if the data is a formula, how do I import them as formulas? I am having the same issue with workbook connections where everything is raw data? Anyone can help with this please?

Hello, I have a VLOOKUP function that sources a separate file (Workbook), which gets rolled/saved daily with a NEW Date. I am using IDIRECT to change the Daily Roll date forward, in my VLOOKUP, daily. The limitation of this technique, requires to have both Workbooks open, for VLOOKUP to function. Is there a way to use IMPORT DATA functionality, for FileNames that change Daily? Effectively, I am attempting to eliminate the need to open multiple workbooks, to perform the VLOOKUP. I want to perform the VLOOKUP from tables, that update, when the data changes. Is there an effective way to direct IMPORT DATA functionality to change the source, on a Daily Basis?

I wanted to import "column to comma" link into excel. Tell me if it is possible to edit that imported sheet and put my column wise data to convert into comma data?

I have imported custom ribbons on my Excel having Macros. I would like to change or modify the references to the ribbon button. Could you advise how can I change?

informative as always.... Excel 2016 for some reason doesn't provide a way of importing data from mysql ..most of the other databases are offered like (SQL server and oracle) is there a way of importing data to mysql by establishing a connection to the mysql database ?

Do I need to load an external data source in excel in order to use it in a data validation drop down list? Currently my external data is set to "Connection only" however when I try set the source of a data validation list to "=dbLIST", (the name I gave to the data source) it doesn't load the list for me & when I try define a name first in excel and refer that name to the data source and then use that name as the source for the data validation list it throws an error and the list won't load.

Hi ..hope u doing well..if I want to import data from a file whose extension is .pc how will I do it.. cos excel is not giving any such option to import data from these kind of files..

very helpfully this video

These options r not in my excel,which excel is used to do this???

What happen if web page require login? please help I'm stuck here. i cant go further due to login. I have a password and id both with me. Thanks in advanced.

Hi Mam... Can you make a video in Excel which is related with vba macros where cursor automatic move from one sheet to another program, software, application in pc. Please make it.

Hi Leila, I have problem to import the data from my company web site which it has login page please help me how to import a data behind a login page and I am using Excel 365 Thank you in advance

I want to download some data from web on the report which updates on weekly basis.. But the problem here is I can not select the table while on that page. Can you suggest me how to manually select the table from a given link. Also what if the data is too large that it does not fit in one page? Your answers will be very helpful Thanks for video & thanks in advance for reply.

excellent video perfect and thank u

Thanks for your efforts, Laila. Your way of how you introduce information is really interesting.. Do you have any videos or courses on into to Excel VBA or VBA for beginners?? Thanks for the help :) Amr

Please consider adding timestamps to your videos