[Solved] Import Google Sheets spreadsheet

Discuss the spreadsheet application
Post Reply
Mick Berg
Posts: 16
Joined: Thu Dec 10, 2009 10:32 pm

[Solved] Import Google Sheets spreadsheet

Post by Mick Berg »

I am trying to import the data from a Google Sheets spreadsheet into Calc. I am able to paste the url of the spreadsheet into the Calc dialog box but then Calc tells me it doesn't exist. I also don't understand what is meant by the data range. Has anyone done this and can give me some guidance?
Thanks
Michael
Last edited by MrProgrammer on Sun Jul 28, 2024 7:11 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
OpenOffice 3.1 on Windows XP
User avatar
robleyd
Moderator
Posts: 5504
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Importing a Google Sheets spreadsheet

Post by robleyd »

Perhaps try downloading the spreadsheet to your local computer and then use File | Open from within Calc.
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.3.2; SlackBuild for 26.2.3 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
Mick Berg
Posts: 16
Joined: Thu Dec 10, 2009 10:32 pm

Re: Importing a Google Sheets spreadsheet

Post by Mick Berg »

Thanks! Much easier!
Michael
OpenOffice 3.1 on Windows XP
Post Reply