How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Joseph Your Own Question
Joseph
Joseph, Computer Hardware Engineer
Category: Programming
Satisfied Customers: 7263
Experience:  Lead Technician
107060210
Type Your Programming Question Here...
Joseph is online now

I want to find a way to import menu headings from websites

Customer Question

I want to find a way to import menu headings from websites into a spreadsheet, into columns, along with the company name and url in separate columns
JA: What application are you using?
Customer: excel
JA: Have you installed any updates recently?
Customer: no
JA: Anything else you want the Microsoft Office Expert to know before I connect you?
Customer: no
Submitted: 19 days ago.
Category: Programming
Expert:  Joseph replied 19 days ago.

Hi, I am Joseph. Welcome to JustAnswer. I'm reviewing your question now and will post back with your reply soon.

If you have any more information about your question you would like me to know about, please send me another message. If I have all the details about the question, then I can give a more precise and accurate answer.

Expert:  Joseph replied 19 days ago.

I would be happy to help.  First, what version of Excel are you running?

Customer: replied 19 days ago.
The latest one on windows I think
Expert:  Joseph replied 19 days ago.
Office 365?
Customer: replied 19 days ago.
Expert:  Joseph replied 19 days ago.

What sites are you wanting to import data from?

Customer: replied 19 days ago.
100 different websites - I just want to import the menu headings they are using
Expert:  Joseph replied 19 days ago.

Do you have an example?

Customer: replied 19 days ago.
https://www.woodstockhomes.co.uk/
Expert:  Joseph replied 19 days ago.

And what part of the site?

Customer: replied 19 days ago.
on that site, the menu headings are: Home Development sAbout Us Woodstock Way Land News Contact
Customer: replied 19 days ago.
i want those menu headings imported
Expert:  Joseph replied 19 days ago.

You would need a third-party program to do this.

Expert:  Joseph replied 19 days ago.

https://www.windmill.co.uk/excel/excelweb.html#:~:text=From%20the%20Data%20menu%20depending,Excel%20will%20connect.

Customer: replied 19 days ago.
I also found that page on google
Expert:  Joseph replied 19 days ago.

Yes.

Customer: replied 19 days ago.
Never mind, thanks
Expert:  Joseph replied 19 days ago.

So now go to data and then click on Get and Transform and choose web.

Customer: replied 19 days ago.
I read the page, that isn't a solution
Customer: replied 19 days ago.
it's fine please close the question thanks
Expert:  Joseph replied 19 days ago.

Do you not want assistance?

Customer: replied 19 days ago.
I have already tried what's on that website, it doesnt' work
Expert:  Joseph replied 19 days ago.

Can you click on data and then get and transform?

Customer: replied 19 days ago.
it doesn't work
Expert:  Joseph replied 19 days ago.

Do you see that setting?

Customer: replied 19 days ago.
please just close this question I no longer want assistance, thanks
Expert:  Joseph replied 19 days ago.

As you wish.

Expert:  Joseph replied 18 days ago.

Thank you for reaching out and letting me help with your question. I wish you luck with your solution. Have a good day and stay safe!