Export as CSV

Discussions about the Calendar Tool at lds.org. Questions about the calendar on the classic site should be posted in the LUWS forum.
gpford5
New Member
Posts: 14
Joined: Thu Jan 10, 2013 11:04 am

Export as CSV

Postby gpford5 » Mon Mar 03, 2014 7:10 am

I would like to export the calendar as a csv file. Is this possible with the "new" calendar. (I want to edit the file before importing it into my personal [Google ] calendar. Thanks.

jdlessley
Community Moderators
Posts: 6522
Joined: Sun Mar 16, 2008 11:30 pm
Location: USA, TX

Re: Export as CSV

Postby jdlessley » Mon Mar 03, 2014 11:17 am

The Calendar is exported as an iCalendar File format (sync URL) using the Apple iCal button or an Outlook sync URL using the Microsoft Outlook button. There is no provision for a csv file.
JD Lessley
Have you tried finding your answer on the LDS.org Help Center page or the LDSTech wiki?

russellhltn
Community Administrator
Posts: 20729
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Export as CSV

Postby russellhltn » Mon Mar 03, 2014 11:23 am

gpford5 wrote:I want to edit the file before importing it into my personal [Google ] calendar.

Note: Excel completely mangles CSV files. It may not work for what you want even if you do get it in CSV format.

There are other calendar programs that can read/write iCal format that should be useable for editing.

But note that unless you do regular updates (like once a week), your imported calendar will be out of date.

You can also control what events are in your sync file by unsubscribing from calendars you are not interested in.
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

gpford5
New Member
Posts: 14
Joined: Thu Jan 10, 2013 11:04 am

Re: Export as CSV

Postby gpford5 » Tue Mar 04, 2014 8:59 am

Thank you all for your info.

I have used Excel.csv files, and have found they work for me...so far. In the past, when I could get a csv, I found it useful to be able to select what I wanted. For eg, I didn't want all youth activities, but did want the New Years Dance, for eg. Or, not all Stake President events, but did want Stake President Firesides.

Following webpage instructions, when I select sync to Outlook, I get...
webcals://www.lds.org/church-calendar/s ... xxxxxxxxxx

When I paste this in Chrome & IE, I get the message "- did not match any documents."
I removed the "webcals:" and got the same answer.

Any suggestions?
Last edited by russellhltn on Tue Mar 04, 2014 11:03 am, edited 1 time in total.
Reason: Remove personal link

russellhltn
Community Administrator
Posts: 20729
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Export as CSV

Postby russellhltn » Tue Mar 04, 2014 11:08 am

Please note that the URL is for your use only. It shouldn't be shared or posted in a public forum. It's been changed to take the ID number out of it.

If you change it to http://www.lds.org/..... and paste it in your browser, it should cause a file to be downloaded. However, once you do that, or attempt to do that, you can't do another for 9 minutes.

You might go to your subscription selections and make sure something is selected.
Have you searched the Wiki?

Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.


Return to “Calendar”

Who is online

Users browsing this forum: No registered users and 1 guest