+ Reply to Thread
Results 1 to 2 of 2

Import data from Google Spreadsheet to Excel

  1. #1
    Registered User
    Join Date
    08-20-2017
    Location
    England
    MS-Off Ver
    2013
    Posts
    5

    Import data from Google Spreadsheet to Excel

    Hey Guys,

    I'm looking to import data from a specific sheet in a Google Spreadsheet document to my Excel worksheet.

    Now I know that we can, in Google Spreadsheet do "Publish to the Web" then receive a link, but when I go to Excel and want to import data from web (Data -> From Web) then paste the link that I received from Google Spreadsheet - I got an error "Object doesn't support property or method "addEventListener" (if I ignore and refresh, the data is badly imported).

    On the other hand, if I copy the URL of the Google Spreadsheet document (without publishing to web) and paste that URL in Excel (data from web), then it works but it basically import everything from the G-spreadsheet (including editing options) + the number of rows is limited to 234 in Excel.
    It's nice but problematic if I want to import the data from one specific sheet and not all the Google Spreadsheet.

    Is there a way to import the data only from a specific sheet?

    Many thanks!

  2. #2
    Registered User
    Join Date
    08-20-2017
    Location
    England
    MS-Off Ver
    2013
    Posts
    5

    Re: Import data from Google Spreadsheet to Excel

    Anyone by any chance?

+ 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. Import data from ONE CELL from Google Spreadsheet Using VBA
    By ChipsSlave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2017, 08:21 AM
  2. Import from Excel to Google keeping formatting
    By DHFE in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 10-20-2016, 03:54 AM
  3. [SOLVED] How to import data from google spreadsheet?
    By xls_fan in forum Excel General
    Replies: 6
    Last Post: 07-24-2016, 02:07 AM
  4. Replies: 6
    Last Post: 01-29-2014, 08:32 AM
  5. discrepancy between Excel and Google spreadsheet import
    By Bniemeyer in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-26-2014, 05:53 PM
  6. google excel spreadsheet not auto-populating with formulas, but skipping row of data entry
    By dzm in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 9
    Last Post: 05-12-2013, 09:55 PM
  7. Error formatting when import data from google into excel
    By Jeferson11 in forum Excel General
    Replies: 5
    Last Post: 02-18-2013, 11:14 AM

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