LCR to Excel

Use this forum to discuss issues that are not found in any of the other clerk and stake technology specialist forums.
saraplease
New Member
Posts: 1
Joined: Thu Jan 27, 2022 5:56 pm

LCR to Excel

#1

Post by saraplease »

Can I export from LCR to Excel and if so, how?
eblood66
Senior Member
Posts: 3721
Joined: Mon Sep 24, 2007 9:17 am
Location: Cumming, GA, USA

Re: LCR to Excel

#2

Post by eblood66 »

No, there is no support for exporting LCR data.
jsinger61
New Member
Posts: 2
Joined: Sun Dec 27, 2020 12:42 pm

Re: LCR to Excel

#3

Post by jsinger61 »

I have been begging for this for a long time. There should be an option to print reports to a csv file just like there is for PDF. I would suggest you use the Feedback button on the Custom
Reports page and ask for this option on a monthly basis. If they get enough requests, maybe they will do it.
eblood66
Senior Member
Posts: 3721
Joined: Mon Sep 24, 2007 9:17 am
Location: Cumming, GA, USA

Re: LCR to Excel

#4

Post by eblood66 »

I'm afraid that is highly unlikely. Such exports were available maybe 10 years ago but they were explicitly removed. Legal and privacy issues were given as the reason (although no specific details were provided). So unless the relevant laws and/or privacy policies change, it is unlikely that the number of requests will make a difference.
davesudweeks
Senior Member
Posts: 2349
Joined: Sun May 09, 2010 9:16 pm
Location: Oklahoma, USA

Re: LCR to Excel

#5

Post by davesudweeks »

One thing you can do is provide feedback to request the specific custom report (similar to what you would like to create from a .csv file). I recommend you provide a business case for the report. I am no longer a clerk, but If I were and my leaders asked me to build some report that is not in LCR, I would respectfully ask them to show me how since the church doesn't provide the functionality that they are wanting.
russellhltn
Community Administrator
Posts: 32115
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: LCR to Excel

#6

Post by russellhltn »

davesudweeks wrote: Fri Feb 25, 2022 11:37 am One thing you can do is provide feedback to request the specific custom report (similar to what you would like to create from a .csv file). I recommend you provide a business case for the report.
This is a good idea. If possible, I'd tie the report to a task assigned in the General Handbook to strengthen your case.

If there is nothing in the Handbook and this is a self-assigned project of the local unit, it's less likely to get implemented.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
bjenks
New Member
Posts: 3
Joined: Mon Nov 08, 2021 4:41 am

Re: LCR to Excel

#7

Post by bjenks »

I'm not sure what you're trying to export, but I created a custom list (e.g., YSA), highlighted and copied the list, and pasted it into Excel using plain text. Needed minor formatting adjustments. This might be useful for some situations.
bjenks
New Member
Posts: 3
Joined: Mon Nov 08, 2021 4:41 am

Re: LCR to Excel

#8

Post by bjenks »

Someone can let me know if this use is discouraged by the church. If so, I'll let our mission know to stop requesting the files. :)
silus99
New Member
Posts: 46
Joined: Sun Mar 09, 2014 9:50 am
Location: Salem, OR

Re: LCR to Excel

#9

Post by silus99 »

The workaround that can be done is to use custom reports on the webpage itself. Design or open a custom report with the data you want. One the page where it displays the data, click and drag to highlight just the data and copy it. In Excel, right click on a cell and choose "Paste Special" and then select "Text". Sometimes it produces some weird results, but I find I can mess with the columns I include to correct it. I find that sometimes phone numbers without dashes cause issues.

This seems to work better than trying to convert or copy from a pdf.
weemanisme
New Member
Posts: 2
Joined: Thu Sep 17, 2015 10:57 am

Re: LCR to Excel

#10

Post by weemanisme »

HI @silus99,

What leadership role/calling has the permissions to use the custom reports? I have attempted to find the reports menu option you listed directions for and there are no options for me.

Thank you,
Halbop
Post Reply

Return to “General Clerk Discussions”