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: ua-cam.com/video/EOhSODFLqic/v-deo.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.
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.
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.
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
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.
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...
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.
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
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.
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
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
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 😉
@@LeilaGharani is there any excel tool to get automate specific data from gmail to spreadsheet . Like part from the mail........ order number, item number, price , feedback etc. Whenever get mail, automatic data pull in spreadsheet.
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
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.
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.
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 ?
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?
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.???
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?????
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.
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?
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?
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.
0:420: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.
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?
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..
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?
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.
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 ?
Have you tried using an ODBC? Many years ago I needed to import data from several different systems. A few of them were DOS, one was Oracle running on Unix and one was a COBOL and I think it was running on a Wang computer. I used ODBC and was able to adjust it for each different computer and it would import the data first thing when I opened the Excel file. True, none of them were MySQL but I have worked with MySQL and don't see shy the ODBC wouldn't work on it.
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
Hi Amr, Thanks for your comment. Glad you like the videos. I'm currently working on a comprehensive VBA online course. It will take a few more months to be ready. I'm also planning to post some VBA content here. Is there anything specific you're looking to learn? You can find a good introduction to Excel VBA here: ua-cam.com/users/ExcelVbaIsFun
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.
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: ua-cam.com/video/EOhSODFLqic/v-deo.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.
Thank you,your teachings are great for New Beginners in Excel
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.
You're welcome! I'm happy to hear the content here helps with the assessment. All the best for your interview!
You have identified an oft-underused aspect of Excel. Good job.
What a difference a few years makes...
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.
Agree: it's not used that often. Glad you like it Sachin.
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 for the kind comment. I'm glad you find the topics useful.
Madam, I improved my self in excel because you’re videos. Thank you
I'm VERY HAPPY to hear that! Many thanks for your comment & support.
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.
سلام خواهر عزیزم لیلا جان
شما واقعا افتخار ما هستید .
Thanks this helped a lot...
Leila, u r such a darling! You just landed me to my exam room with a confident smile. Excellent job!!!
I'm very happy to hear that! Good luck on your exam.
Thanks Leila. This is excellent and will be very helpful for me! Keep up the good work!
I'm glad you find this useful :)
You are such a great tutor, Thanks !!
You're welcome Ester.
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.
Thank Manash.
Can u pls send me your mail address... if any problem arise i send you. My mail id is smartmanash@gmail.com
Can you do a video on importing data from a website you have to sign in before you can view the data?
1:40 should be "highlight the cells" not 'highlight the column'. Great video.
Thank you for this, really helpful
Thanks a lot
Very useful data import tips for Excel
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
Glad you like it.
Thank you ma’am great content
Hello ma'am can you show video web scraping and data scraping full video on UA-cam and use in which software easy to use
saved me few hours. Kudos !
That's great! Thanks for sharing.
MANY THANKS FOR ALL THE THINGS I'VE LEARNED FROM YOU
Hey, I find this very helpful & you were very calm throughout the video and yeah, subscribed to your channel. Love
Thanks for subbing!
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.
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...
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.
Thanks leila.
excellent video, thanks alot for these easy to understand videos.
I'm happy to hear this Simoiya! Many thanks for your support.
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
Thanks for the hot chili pepper. Cool!. (dichotomy 😎) Nice visual aid.
😊
You are best
Thank you thank you!! You are making me smart!
You're very welcome. I'm glad to hear that :)
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.
Thanks - I hope you also find what you were looking for.
I like the tutorial!!
Great job. thanks.
You're welcome Mahmud.
In Excel any function to see data import source see and all activities done in Excel to see
Thanks Leila
Thank you for the video.
My pleasure.
Wonderful, great job
ضخمة بيم محد كماش لا
I understood it very well & thank you!!!!!!!
You're welcome Narth.
This what I need. ..
Thanks
Thanks in a million!
you save my ass for tomorrow meeting! thanks babe
Excellent Video, Thank you!
You're very welcome Esan.
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.
How to import data by function for example importxml and SAVE data automatically?
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
Hey.. i am learning from you via UDEMY also.
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
Very useful
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.
usefull video thank u
Glad you like it George.
Why by importing csv file into ERP software - all my data end up in one cell? I do choose the right delimitor
Thanks.
Can you show me how to make csv file
Do you have a video on how to import SharePoint list columns into a word doc stored in OneDrive for business
Hi there, is there any way I can import Excel spreadsheet into Xplan document vault?
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 😉
I'm glad the tutorial was helpful Bryan. I hope the stock market is treating you well :)
@@LeilaGharani is there any excel tool to get automate specific data from gmail to spreadsheet . Like part from the mail........ order number, item number, price , feedback etc. Whenever get mail, automatic data pull in spreadsheet.
We can use flash fill right??
very helpfully this video
Glad to hear that :)
I want copy two different documents
I want to copy the sheets of one excel project into the other with messing it up
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
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
export the paper packaging, paper bag, paper box, etc.
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.
Vielen Dank😍. Can you Show this with REST API. PLEASE. 🥺😍🥰
excellent video perfect and thank u
You're very welcome.
Would be good to see other sources like sql and nosql
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.
These options r not in my excel,which excel is used to do this???
How to import data from pdf file, plz make a video on that
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 ?
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?
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
Please consider adding timestamps to your videos
Thanks for the feedback! I do have timestamps for my newer videos. I just added it also for this one.
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.???
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?????
Will this work to import all Utube video url data from monthly filtered history to an EXCEL file ??
Appreciate yr confirmation
Thx
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.
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?
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?
and also pls upload the excel files with direct link where i/we download directly the video tutorial file without any hassle...
The file for this lecture is included in my online course on Udemy. If the files are on the site, I will put the direct link in the descriptions.
سلام. ممنون از آموزش خوبتون
شما ایرانی هستین؟
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.
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.
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?
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..
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?
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.
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 ?
Have you tried using an ODBC? Many years ago I needed to import data from several different systems. A few of them were DOS, one was Oracle running on Unix and one was a COBOL and I think it was running on a Wang computer. I used ODBC and was able to adjust it for each different computer and it would import the data first thing when I opened the Excel file. True, none of them were MySQL but I have worked with MySQL and don't see shy the ODBC wouldn't work on it.
We Indians follow British system and use "," as a thousand separator and "." as decimal seperator
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
Hi Amr, Thanks for your comment. Glad you like the videos. I'm currently working on a comprehensive VBA online course. It will take a few more months to be ready. I'm also planning to post some VBA content here. Is there anything specific you're looking to learn? You can find a good introduction to Excel VBA here: ua-cam.com/users/ExcelVbaIsFun
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.
I love that
Glad you liked it.