Hello,
Does anyone know of a way to import the data from this link into an excel so that all the data will be listed in columns. IE: Association name, contact, advisor, etc....
So far I have not found an efficient way to do this through importing the data.
http://studentlife.msu.edu/current_s...o/orgs_a_e.htm
Thank you in advance!!!
Try importing the data by a Web Query.
Go to Data --> Import External Data --> New Web Query.
Type the URL in the browser. Select the table you wish to import & click on Import. Once you are done with importing the data, you can alter the refresh time by going to Data Range Properties.
Let me know if it works for you.
Regards,
Karan
Karan,
Did you try that on the link the OP provided?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi JB,
I tried & it worked perfectly fine.
I have attached a workbook with the imported data. Check it out!!
Regards,
Karan
Using Karan's technique, (sorry I couldn't get that page to import at first, then it worked...)
The data imports into column A.
Then you can use worksheet formulas to create a columnized set of data. Sample attached.
ImportData-Reformat.xls
The colored cells show the INDEX/MATCH formulas. Each color is a different notable formula.
I copied C3:G3 down quite a ways.
Note the colored cells like C18... that cell generated an error so had to be slightly adjusted, then the table worked again until C38 where another adjustment was necessary. At C38, the entire row needed tweaking, then the original formulas worked again starting at C39.
This made it simply to get the formatted table with just a little visual-assist.
Now copy that data and PASTE SPECIAL > VALUES somewhere.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Here is the 2003 compatible version of the document.
Regards,
Karan
I think this is the main problem being addressed, the formatting, not the import part itself.Originally Posted by CaseyP
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
I'm actually in need of help with both the import and organization of the data. I forgot to mention that I'm using a mac version of excel, and am not familiar with creating a web query with a mac.
However, JB you are correct in that the main issue I'm having is the formatting of the info.
This is exactly what I was looking for, now i just need help on importing the web query into the mac version of excel.
Thanks a ton!
The document we provided already had an active import for the page you linked. Does the import routine not activate when you open the sample sheets?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
I am able to activate the document that you provided. It works great... Except, I now have several more web pages similar to that one in which i need to import with my mac.
Follow the instructions given for creating your own links.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks