+ Reply to Thread
Results 1 to 2 of 2

Bulk Import From Web Pages

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    london
    MS-Off Ver
    Excel 2013
    Posts
    133

    Bulk Import From Web Pages

    Hello all


    We're trying to import all cell brands and models from this site:
    https://www.phonemodelslist.com/list...manufacturers/

    There are dozens of brands/pages like this one (the first):
    https://www.phonemodelslist.com/acer/

    And the part that interests us is the data in the table which contains all the phone models.

    How can we get all this data fast/in bulk?

    Here is the list of urls:
    https://www.phonemodelslist.com/acer/
    https://www.phonemodelslist.com/alcatel/
    https://www.phonemodelslist.com/allview/
    https://www.phonemodelslist.com/amazon/
    https://www.phonemodelslist.com/apple/
    https://www.phonemodelslist.com/archos/
    https://www.phonemodelslist.com/asus/
    https://www.phonemodelslist.com/benq/
    https://www.phonemodelslist.com/blackberry/
    https://www.phonemodelslist.com/blu/
    https://www.phonemodelslist.com/celkon/
    https://www.phonemodelslist.com/coolpad/
    https://www.phonemodelslist.com/dell/
    https://www.phonemodelslist.com/energizer/
    https://www.phonemodelslist.com/gigabyte/
    https://www.phonemodelslist.com/gionee/
    https://www.phonemodelslist.com/haier/
    https://www.phonemodelslist.com/honor/
    https://www.phonemodelslist.com/hp/
    https://www.phonemodelslist.com/htc/
    https://www.phonemodelslist.com/huawei/
    https://www.phonemodelslist.com/icemobile/
    https://www.phonemodelslist.com/infinix/
    https://www.phonemodelslist.com/intex/
    https://www.phonemodelslist.com/karbonn/
    https://www.phonemodelslist.com/kyocera/
    https://www.phonemodelslist.com/lava/
    https://www.phonemodelslist.com/leeco/
    https://www.phonemodelslist.com/lenovo/
    https://www.phonemodelslist.com/lg/
    https://www.phonemodelslist.com/maxon/
    https://www.phonemodelslist.com/maxwest/
    https://www.phonemodelslist.com/meizu/
    https://www.phonemodelslist.com/micromax/
    https://www.phonemodelslist.com/microsoft/
    https://www.phonemodelslist.com/motorola/
    https://www.phonemodelslist.com/nec/
    https://www.phonemodelslist.com/nokia/
    https://www.phonemodelslist.com/o2/
    https://www.phonemodelslist.com/oppo/
    https://www.phonemodelslist.com/orange/
    https://www.phonemodelslist.com/panasonic/
    https://www.phonemodelslist.com/pantech/
    https://www.phonemodelslist.com/philips/
    https://www.phonemodelslist.com/plum/
    https://www.phonemodelslist.com/posh/
    https://www.phonemodelslist.com/prestigio/
    https://www.phonemodelslist.com/qmobile/
    https://www.phonemodelslist.com/sagem/
    https://www.phonemodelslist.com/samsung/
    https://www.phonemodelslist.com/sharp/
    https://www.phonemodelslist.com/siemens/
    https://www.phonemodelslist.com/sony-ericsson/
    https://www.phonemodelslist.com/spice/
    https://www.phonemodelslist.com/t-mobile/
    https://www.phonemodelslist.com/tecno-mobile/
    https://www.phonemodelslist.com/telit/
    https://www.phonemodelslist.com/toshiba/
    https://www.phonemodelslist.com/unnecto/
    https://www.phonemodelslist.com/verykool/
    https://www.phonemodelslist.com/vivo/
    https://www.phonemodelslist.com/vodafone/
    https://www.phonemodelslist.com/wiko/
    https://www.phonemodelslist.com/xiaomi/
    https://www.phonemodelslist.com/xolo/
    https://www.phonemodelslist.com/yezz/
    https://www.phonemodelslist.com/zte/

    (I have excel 2010, without powerquery)
    Last edited by nicoan; 12-27-2019 at 05:49 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Bulk Import From Web Pages

    Hi there. Perhaps you could let us know what you've done so far to achieve this? Then we can help with whatever's leaving you stuck.

    Regards
    Tim
    Last edited by harrisonland; 12-27-2019 at 07:08 PM.

+ 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. How to import bulk text files to excel cells
    By drhema in forum Excel General
    Replies: 10
    Last Post: 06-01-2022, 10:35 AM
  2. Google Calendar bulk import tool with recurring events.
    By Hindrik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2016, 09:12 AM
  3. [SOLVED] Bulk import. (Copy Data from one sheet to a main sheet with conditions)
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 12:24 AM
  4. Best Way to Bulk Import a Few Hundred CSV Files
    By Videoman22 in forum Access Tables & Databases
    Replies: 0
    Last Post: 07-06-2013, 04:29 PM
  5. Problem in Bulk import of Excel data into SQL
    By sridevi kumaravel in forum Excel General
    Replies: 0
    Last Post: 10-25-2012, 07:58 AM
  6. Replies: 5
    Last Post: 02-19-2010, 04:22 AM
  7. How can I import data into Excel from web pages
    By hemer in forum Excel General
    Replies: 1
    Last Post: 04-06-2006, 02:20 PM

Tags for this Thread

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