/calendar/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
-
5/27/19
i want to import data from Excel / Calc-Sheet into my Calendar - but it is not working propperly 0 Recommended Answers 9 Replies 3 Upvotes
1 Recommended Answer
$0 Recommended Answers
i want to import  data from Excel / Calc-Sheet into my Calendar - but it is not working propperly 
well i have the data - 365 lines of text - one row for each day - with verses and quotes for the day - in three different languages. i have these data put into a booklet - a little offline calendar so far. But now i am willing to put them into my google-Calendar. But it d oes not work . Plz advice me what i have to do - and how to treat the data THAT THIS import will work 

Look forward to hear from you greetings Martin
All Replies (9)
5/27/19
Hi Martin, you'll need to set up the header row as described at

making sure your Start Date column is formatted MM/dd/yyyy. Since you only need all day events you'll just need a, Start Date column, not the End Date or Time columns. I'm not sure what you can do with your multiple "Description" columns though... You'd have to merge them into a single column I suppose.
Last edited 5/27/19
marked this as an answer
Helpful?
-
6/4/19
 i have reworked the data like you can see...can i do the upload like so!?  can i do the uplodad to the google calendar with this format!?love to hear from you.
marked this as an answer
Helpful?
-
6/4/19
see the calendar - i have reworked the format - but it does not work . i have no glue.. 

marked this as an answer
Helpful?
6/4/19
Hi Martin, no glue needed! I can't see your header file on that screenshot.... From what I can see you'll need to change the hyphen in the dates to a slash, so that - becomes /, for dates to be accepted. Another problem you might run into is commas in your titles, descriptions or locations which messes everything up. The solution iirc is to wrap text fields in double-quotes. Not forgetting to replace all double quotes with single quotes (or double single-quotes) first. Single-quotes being an apostrophe...
Last edited 6/4/19
marked this as an answer
Helpful?
-
6/12/19
hello and good day - i have reworked the dataset - but at the moment i am  not able to upload... see the set and the scructure..

the issue - with all the corrections  and with all the rework - i am still not abel to do the upload

Last edited 6/12/19
marked this as an answer
Helpful?
-
6/13/19
hello again - i try to work it out... 
can i run this sheme 


01/01/19 `Lukas 16,19-20 Es war ein reicher Mann, der kleidete sich in Purpur und kostbares Leinen` 
01/02/19 `Kolosser 3,13 Ertrage einer den andern und vergebt euch untereinander` 
01/03/19 `1. Petrus 5,10Der Gott aller Gnade, der euch berufen` 


all data in two columns or should i put it in one column
marked this as an answer
Helpful?
6/13/19
Hi Martin, you'll need 1 column called "Start Date", and one column called "Summary" which is the Title, and one called "Description" where you can put longer text. Each row should be like this, with double quotes:

"Start Date", "Summary", "Description"
01/01/2019, "Put Short Title Here", "Put Main Text Here"
01/02/2019, "Second Short Title Here", "Main Text Here"
...

If you want to put all the text in the title, and it's not too long, then just leave out the description column.
Last edited 6/13/19
marked this as an answer
Helpful?
-
7/7/19
hello dear all  good day - one question: 

would that be possible: 



If you are constrained to three columns, I'd go with

Date | Book:chapter:verse | Text

and I'd put the data into a conventional CSV format that can be opened directly by Excel - EG


"01/01/19","Lukas:16:19","Es war ein reicher Mann, der kleidete sich in Purpur und kostbares Leinen" "01/02/19","Kolosser:3:13","Ertrage einer den andern und vergebt euch untereinander" "01/03/19","1.Petrus:5:10","Der Gott aller Gnade, der euch berufen"

the issue is - that i have the whole dataset in a big calc-table: 
i need to export it into  csv data-set ... 

would that be all right!? 

love to hear from  you

regards 
martin
marked this as an answer
Helpful?
7/7/19
Hi Martin, that looks good to me - just make sure your first row contains the correct column names as I explained above, and export as CSV which should look like this :

"Start Date", "Summary", "Description"
"01/01/19","Lukas:16:19","Es war ein reicher Mann, der kleidete sich in Purpur und kostbares Leinen"
"01/02/19","Kolosser:3:13","Ertrage einer den andern und vergebt euch untereinander"
"01/03/19","1.Petrus:5:10","Der Gott aller Gnade, der euch berufen"
Last edited 7/7/19
marked this as an answer
Helpful?
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/calendar/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/calendar/profile/0?hl=en