+ Reply to Thread
Results 1 to 2 of 2

Import function in Google Sheets

  1. #1
    Registered User
    Join Date
    10-26-2014
    Location
    Hull, England
    MS-Off Ver
    N/A
    Posts
    3

    Import function in Google Sheets

    Hello,

    I am trying to import data into cells from a website.

    I need the name of the product and 3 prices.

    Example is from here: https://uk.webuy.com/product.php?sku=711719248675

    Is anyone able to help me with this. I've been trying to do it for days with the IMPORTXML function.

    Please see sample below:
    Capture.PNG

    A1 - Is this target url --> https://uk.webuy.com/product.php?sku=
    A2 - This is the Barcode/SKU which needs to be attached on the end of the URL on A1. There will be many Barcode/SKU's on the sheet
    B2 - Product Name from the example page is Gran Turismo 6
    C2 - Value of product
    D2 - Value of product
    E2 - Value of product

    Essentially. What I need is all the fields to update when a barcode is entered in the A column. I'll be having around 30 barcodes in this A column and then I need the names and prices to show up beside them.
    Last edited by Bielbo; 10-26-2014 at 08:37 PM. Reason: Refinement

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Import function in Google Sheets

    You need something like this in B2:

    =ImportXML(A1&A2,"//div[@class='productDetails']//table[1]")
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need 'continue' function. how to update to new google sheets?
    By eusair in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 10-15-2014, 11:36 PM
  2. discrepancy between Excel and Google spreadsheet import
    By Bniemeyer in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-26-2014, 05:53 PM
  3. How can I import Google results number to Excel?
    By pinkpantherksa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2012, 07:59 PM
  4. Google Earth lat./long. import to Excel
    By PCAg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2012, 10:47 AM
  5. Replies: 0
    Last Post: 08-12-2010, 07:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1