Home

Help to import data directly to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-760092%22%20slang%3D%22en-US%22%3EHelp%20to%20import%20data%20directly%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-760092%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20seen%20examples%20online%20to%20be%20able%20to%20import%20data%20directly%20into%20excel.%20Examples%20of%20these%20which%20i%20am%20hoping%20to%20use%20include%20stock%20prices%2C%20commodity%20prices%20and%20interest%20rates.%20I%20have%20found%20websites%20which%20are%20able%20to%20supply%20the%20information%2C%20however%20i%20have%20not%20been%20able%20to%20master%20the%20import%2Fmacro.%20I%20am%20aiming%20to%20import%20a%20large%20data%20set.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anyone%20able%20to%20assist%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-760092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-762854%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20import%20data%20directly%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762854%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EImporting%20Data%20into%20Excel%20can%20be%20done%20in%20so%20many%20ways%20using%20different%20tools%20from%20Basic%20to%20Power%20Query.%20All%20these%20tools%20are%20available%20on%20the%20Data%20Tab%20of%20the%20Ribbon.%3C%2FP%3E%3CP%3EThis%20is%20more%20than%20a%20Full%20Day%20course.%20Can't%20be%20cover%20in%20this%20reply.%3C%2FP%3E%3CP%3EHowever%2C%20I%20am%20attaching%203%20different%20examples%20from%20my%20YouTube%20Channel%26nbsp%3B%20where%20I%20use%20Power%20Query%20and%20Stock%20Data%20Types.%20You%20are%20free%20to%20explore%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dten9JNWmjQA%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dten9JNWmjQA%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DjEr3uj1ljQ8%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DjEr3uj1ljQ8%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DdXQtcU44I_0%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DdXQtcU44I_0%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773113%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20import%20data%20directly%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20mean%20linked%20data%20types%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.howtoexcel.org%2Fgeneral%2Fdata-types%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.howtoexcel.org%2Fgeneral%2Fdata-types%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780298%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20import%20data%20directly%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780298%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20was%20interesting%20and%20helpful%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Hi,

 

I have seen examples online to be able to import data directly into excel. Examples of these which i am hoping to use include stock prices, commodity prices and interest rates. I have found websites which are able to supply the information, however i have not been able to master the import/macro. I am aiming to import a large data set.

 

Is anyone able to assist?

3 Replies
Highlighted

@calof1 

Hi,

Importing Data into Excel can be done in so many ways using different tools from Basic to Power Query. All these tools are available on the Data Tab of the Ribbon.

This is more than a Full Day course. Can't be cover in this reply.

However, I am attaching 3 different examples from my YouTube Channel  where I use Power Query and Stock Data Types. You are free to explore:

https://www.youtube.com/watch?v=ten9JNWmjQA

 

https://www.youtube.com/watch?v=jEr3uj1ljQ8

 

https://www.youtube.com/watch?v=dXQtcU44I_0

 

Hope that helps

Nabil Mourad

 

When you have a workbook with lots of worksheets it's very useful to create an Index of All Sheet Names and be able to Navigate to any of these worksheets an...
Currency Exchange rate are now dynamically extracted at run time with the new enhancements of the stocks data type. In this project we combine some of the be...
In this tutorial I want to show you some of the magic of Power Query...I'll be importing from a website a list of Countries and their capitals, Clean and trans...
Highlighted

Thanks@nabilmourad 

 

This was interesting and helpful

Related Conversations
IF formula with variable column value to plug into equation
Lilac in Excel on
0 Replies
Calculate the points for irregular dates
chaehyun in Excel on
9 Replies
Need help with IF statements!?!
JBulmer in Excel on
3 Replies
Trying to make cells with arrows
tokkebi in Excel on
1 Replies
Problem with Mail Merge in Word, using Excel database
crunchyjax in Excel on
0 Replies