Importing Schedule into Google Sheets
#1
Tech Support (Parent and Student Access)/Importing Schedule into Google Sheets
Can I import the schedules into Google Sheets so I can edit them?
Reply
#2
Tech Support (Parent and Student Access)/RE: Importing Schedule into Google Sheets
I haven't tried yet, but you should be able to open the ODT file format in sheets.

Edit: Tried, doesn't open ODT format, searching for other options for you.
I currently use LibreOffice, which is free software, to edit this file type.

Edit 2: If you go to Google Docs, you can click File > Open > go to Upload tab, and drop in the .doc file format of the schedule.
It's not Sheets, but it gets it editable in Google.
Taryn & Stuart
Three children: Our firstborn in heaven (2016), Margaret (2018), and Elizabeth (2021)
Reply
#3
Tech Support (Parent and Student Access)/Importing Schedule into Google Sheets
I import the .doc format into Google Docs. None of the formats (.doc,
.odt, or .pdf) is set up for Sheets. But .doc uploads nicely into Google Docs.
Kathy 
For we are God’s handiwork, recreated in Christ Jesus, that we may do those good works which God predestined for us, that we should walk in them.
The following 2 users Like lklivingston's post:
  • HannahA, Mariel
Reply
#4
Tech Support (Parent and Student Access)/Importing Schedule into Google Sheets
You can then copy paste it from Google docs into Google sheets. You have to fix a little bit of the formatting, but not much.
The following 1 user Likes daniella's post:
  • HannahA
Reply
#5
Tech Support (Parent and Student Access)/RE: Importing Schedule into Google Sheets
I find editing a .doc or .odt directly in a word processor (libre Office or Google docs) works better than using a spreadsheet. You can see what you're doing, easily cut and paste and resize and so on - and also you know how it will print when the time comes.
Claire - Tasmanian mum sharing one of God's garden beds with four other 'Son-flowers' - DH (husband of 22 years), Little Bear  (DS 18yo, AO Year 11/12 - his LAST YEAR!!), Miss Muffet (DD 16 yo, AO Year 11) and Mouse (DS 13yo, AO Year 7 - 3 teenagers, yikes!).
"A child of any age should be a well-read person for his age." - Charlotte Mason
The following 1 user Likes Subversive Gardener's post:
  • HannahA
Reply
#6
Tech Support (Parent and Student Access)/RE: Importing Schedule into Google Sheets
Ha ha, I am the opposite. I cannot work with the schedules in .doc. I almost immediately get frustrated enough to start grumbling, so every year, I copy the schedule into a spreadsheet. I actually feel I can see everything better and have more control on how it prints in a spreadsheet. It takes a little to format everything, but I've done it enough that it takes me almost no time at all.

And then making all of my edits is soooo much easier. But I've been using spreadsheets for my personal and school schedules since college, so I am fairly comfortable with them, whereas tables in word documents drive me wild.

Not trying to convince anyone else to use spreadsheets; just offering another perspective.
Second Generation Homeschooler w/ one daughter, Year 4.5 or something. It's complicated.
and two daughters, one son, and at least three more babies in heaven.
https://awdowner.com
The following 4 users Like Sammie2's post:
  • amerebreath, HannahA, Primeperiwinkle, Subversive Gardener
Reply
#7
Tech Support (Parent and Student Access)/RE: Importing Schedule into Google Sheets
That really is interesting! I'm very comfortable with spreadsheets, too. I just find for this purpose the word processor works better. I wish we could sit side-by-side and watch each other's process and see what we both do!
Claire - Tasmanian mum sharing one of God's garden beds with four other 'Son-flowers' - DH (husband of 22 years), Little Bear  (DS 18yo, AO Year 11/12 - his LAST YEAR!!), Miss Muffet (DD 16 yo, AO Year 11) and Mouse (DS 13yo, AO Year 7 - 3 teenagers, yikes!).
"A child of any age should be a well-read person for his age." - Charlotte Mason
The following 2 users Like Subversive Gardener's post:
  • Primeperiwinkle, Sammie2
Reply
#8
Tech Support (Parent and Student Access)/Importing Schedule into Google Sheets
I’m another spreadsheet gal (someone bought me a shirt that says “I’ve got a spreadsheet for that! ). I just copy it from the google doc over to google sheets. It’s really not to big of a hassle. I also separate the terms into separate tabs….so much you can do!
Soli Deo Gloria,
Sarah DS (Y7), DS (Y5), DD (Y3), DS (Y1), DD (4)
The following 4 users Like SarahLee33's post:
  • amerebreath, HannahA, jadegreen, Sammie2
Reply
#9
Tech Support (Parent and Student Access)/RE: Importing Schedule into Google Sheets
(04-06-2025, 06:51 AM)SarahLee33 Wrote: I’m another spreadsheet gal (someone bought me a shirt that says “I’ve got a spreadsheet for that! ). I just copy it from the google doc over to google sheets. It’s really not big of a hassle. I also separate the terms into separate tabs….so much you can do!

That's what I do. I have two tabs for each term. One for the AO readings, and another for the things that cycle like picture study and personal choices like math and piano.
Second Generation Homeschooler w/ one daughter, Year 4.5 or something. It's complicated.
and two daughters, one son, and at least three more babies in heaven.
https://awdowner.com
The following 1 user Likes Sammie2's post:
  • jadegreen
Reply
#10
Tech Support (Parent and Student Access)/Importing Schedule into Google Sheets
I also prefer using sheets to docs! Tables in documents drive me crazy
The following 2 users Like daniella's post:
  • amerebreath, Sammie2
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  AO Website Schedule Errors (Not Chart Errors) lklivingston 9 24,060 05-18-2025, 12:48 PM
Last Post: Elizziebeth
  Google Docs? mlangworthy 1 2,385 04-26-2025, 01:36 AM
Last Post: Elizziebeth
  Book of Golden Deeds misplaced in schedule StewartFamily 1 2,783 03-16-2025, 08:45 AM
Last Post: AnneWhite
  AmblesideOnline website Year 12 Schedule not showing Term 3 Chrystal 2 5,830 08-16-2024, 01:23 AM
Last Post: Lani
  Printing Issues with Y7 Lite PDF Schedule blingbloom 1 7,153 06-01-2023, 05:56 AM
Last Post: lklivingston
  Trouble opening ODT schedule in something besides Microsoft Word CottageSchool 3 14,479 12-09-2021, 12:31 PM
Last Post: CottageSchool
  trouble editing ODT schedule charts CottageSchool 2 8,805 07-14-2020, 04:01 AM
Last Post: CottageSchool
  Curious - Google? Jessie 1 5,996 06-10-2019, 10:37 AM
Last Post: lklivingston
  Schedule Bookmark Template or Tutorial? carolandreescu 0 3,821 01-17-2017, 10:10 PM
Last Post: carolandreescu
  Google docs year 7 file Janice 11 29,227 05-17-2016, 07:36 AM
Last Post: Linz{at}home



Users browsing this thread: 1 Guest(s)