Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-13-2021, 10:12 PM
oscarlimerick oscarlimerick is offline Importing website data to excel-form columns Windows 8 Importing website data to excel-form columns Office 2013
Advanced Beginner
Importing website data to excel-form columns
 
Join Date: Jul 2020
Posts: 33
oscarlimerick is on a distinguished road
Default Importing website data to excel-form columns

Hello good people on the microsoft excel forum, I am trying to import data from a website into an excel spreadsheet. The initial website sample is attached as a jpeg below and titled "website for excel forum". If I select this data on the website and copy it to the clipboard and paste it into word, I get a document that looks like the attached docx titled "If i copy website items to word i get this". If I paste the same data into excel, it is not as neatly formatted and I get an excel sheet that looks like the attached xl file titled "if i copy website items to excel i get this"



What I really want though is to come up with a spreadsheet based on this data that loos like the attached spreadsheet "for excel forum"

Obviously I can enter all the data manually, but this is a small portion of a rather large list and I'm looking for a way to automate this more. I was thinking I need to use CSV or something, but I don't know how to go about this. Any suggestions? Many thanks
Attached Images
File Type: jpg website for excel forum.jpg (47.8 KB, 4 views)
Attached Files
File Type: docx if I copy website items to word i get this.docx (11.6 KB, 1 views)
File Type: xlsx if i copy website items to excel i get this.xlsx (8.4 KB, 1 views)
File Type: xlsx for excel forum.xlsx (9.9 KB, 1 views)
Reply With Quote
  #2  
Old 11-14-2021, 06:55 AM
p45cal p45cal is offline Importing website data to excel-form columns Windows 10 Importing website data to excel-form columns Office 2019
Expert
 
Join Date: Apr 2014
Posts: 537
p45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to behold
Default

1. We'd need the url of the website/web page, there are too many unknowns to do this from a picture of a web page.
2. As you seem to be using Excel 2013, have you downloaded the Power Query add-in? This is also known as Get & Transform data and is built-in to more recent versions of Excel.
3. Failing either of the above, it looks as though you might be able to do something with a macro on the Excel-pasted version; there seems to be a record per 4 rows, but we would need a larger sample to be sure of that consistency.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto populate form (data from excel) in Word based on drop down list selection (data from excel) wvlls Word VBA 1 03-22-2019 02:29 PM
Importing an Excel form into Access tracygleghorn Office 0 11-15-2016 08:43 AM
Importing website data to excel-form columns Word Forms - importing data from one form to another cliffoth Word 7 09-25-2014 05:17 PM
How to copy all data from a website to excel sheet? Plz plz plz plz plz help...urgent Sam123 Excel 0 07-19-2014 02:12 AM
Importing website data to excel-form columns Importing data from excel using a macro soma104 Word 1 04-14-2011 05:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft