Need Assistance on how to import data from a webpage to exce

milanpatel17

New Member
Joined
Sep 14, 2013
Messages
9
Hello All,

I am trying to copy and paste data from a website to excel which is taking very much time. Is there any other way to paste the data quickly?

What i am using is first pasting data into notepad and than copy from notepad and paste again in excel.

Please guide me if there is any better way.

Also, If i want to get the data from Notepad to excel by using macro, what would be the code?

Thanks in advanced.

Milan Patel
 

drsarao

Well-known Member
Joined
Sep 9, 2009
Messages
1,112
I think you are trying to get text only from the site.
Try this:
Copy from website.
Go to excel --> Right click on the cell where you want the data.
Click "Paste Special" on the context menu which appears.
Select "Text".
"OK"
 

milanpatel17

New Member
Joined
Sep 14, 2013
Messages
9
Thanks, Mr. Rao.

That was really helpful. I am wondering if you can guide me to do one more step.

After pasting data from site it looks like

https://www.websitename.com
79 84 56 57

Means website name in one row and its data in 2nd row. Than a blank row and another site and its data.

I need website name and its data in one row like

https://www.websitename.com 79 84 56 57

How do I do that?

Any help would be appriciated !!

Regards,
Milan Patel
 

drsarao

Well-known Member
Joined
Sep 9, 2009
Messages
1,112
"Paste special" will paste data as it found in the web site. You will have to move it manually.
If the data is a lot then you can try using VBA to copy paste data to same row and then delete the row.
You can use the macro recorder and make your own program.
 

Forum statistics

Threads
1,082,323
Messages
5,364,580
Members
400,809
Latest member
formulasataglance

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top