Home

How do I import information from specific colimns from workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-710653%22%20slang%3D%22en-US%22%3EHow%20do%20I%20import%20information%20from%20specific%20colimns%20from%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-710653%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20find%20a%20simple%20way%20to%20import%20information%20from%20specific%20columns%20from%20one%20workbook%20into%20another.%20Maybe%20I'm%20missing%20something%20in%20the%20interpretations%20when%20I'm%20reading%20the%20answers%20on%20the%20web%2C%20but%20none%20are%20working.%20What%20I%20want%20to%20do%20is%20this%3A%3C%2FP%3E%3CP%3EI%20import%20data%20into%20Excel%20from%20my%20online%20program%20at%20work%2C%20but%20there%20are%26nbsp%3BSO%20many%20columns%20of%20info%20I%20don't%20need.%20So%2C%20I%20have%20been%20having%20to%20go%20through%20and%20delete%20each%20column%20until%20I%20have%20a%20working%20copy%20I%20can%20use.%20This%20can%20take%20as%20long%20as%2015%20minutes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIsn't%20there%20a%20way%20I%20can%20simply%20import%20selected%20columns%20of%20information%20from%20the%20downloaded%20workbook%20into%20a%20master%20workbook%20already%20created%20with%20only%20the%20columns%20I%20need%20without%20selecting%20each%20separate%20%22cell%3F%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20is%20the%20only%20program%20I%20have%20to%20work%20with%20and%20I%20just%20can't%20imagine%20it%20not%20being%20an%20easy%20process.%20I'm%20using%20Microsoft%20Office%20Professional%20Plus%26nbsp%3B2013.%20I%20would%20appreciate%20any%20help%20I%20can%20get%20with%20this%20and%20thanks%20so%20much%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-710653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-711221%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20import%20information%20from%20specific%20colimns%20from%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-711221%22%20slang%3D%22en-US%22%3EDo%20you%20have%20the%20option%20to%20download%20and%20install%20the%20PowerQuery%20add-in%3F%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D39379%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D39379%3C%2FA%3E%3CBR%20%2F%3EIf%20yes%2C%20try%20the%20option%20to%20import%20from%20workbook.%20From%20there%20you%20can%20define%20which%20workbook%2C%20which%20worksheet%20and%20if%20you%20click%20Transform%20data%20you%20can%20subsequently%20delete%20all%20columns%20you%20do%20not%20need.%20These%20steps%20are%20then%20saved%20so%20in%20future%20all%20you%20need%20to%20do%20is%20press%20Refresh%20All.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-721870%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20import%20information%20from%20specific%20colimns%20from%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721870%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much!%20I%20will%20try%20that%20today%20and%20see%20if%20it%20works.%20I%20appreciate%20your%20help%20and%20wish%20me%20luck.%3C%2FP%3E%3C%2FLINGO-BODY%3E
klaelmorris
New Contributor

Hello All,

I am trying to find a simple way to import information from specific columns from one workbook into another. Maybe I'm missing something in the interpretations when I'm reading the answers on the web, but none are working. What I want to do is this:

I import data into Excel from my online program at work, but there are SO many columns of info I don't need. So, I have been having to go through and delete each column until I have a working copy I can use. This can take as long as 15 minutes.

 

Isn't there a way I can simply import selected columns of information from the downloaded workbook into a master workbook already created with only the columns I need without selecting each separate "cell?"

 

Excel is the only program I have to work with and I just can't imagine it not being an easy process. I'm using Microsoft Office Professional Plus 2013. I would appreciate any help I can get with this and thanks so much in advance!

2 Replies
Do you have the option to download and install the PowerQuery add-in?
https://www.microsoft.com/en-us/download/details.aspx?id=39379
If yes, try the option to import from workbook. From there you can define which workbook, which worksheet and if you click Transform data you can subsequently delete all columns you do not need. These steps are then saved so in future all you need to do is press Refresh All.

@Jan Karel Pieterse Thank you so much! I will try that today and see if it works. I appreciate your help and wish me luck.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies