LCR to Excel

Can I export from LCR to Excel and if so, how?

No, there is no support for exporting LCR data.

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.

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.

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.

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.

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.

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.

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.

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

weemanisme wrote: Sun May 01, 2022 9:18 am 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.

In LCR, Other -> Access Table will show which callings have access to which features. However, I don't see "custom" anywhere in the table. Do you perhaps mean custom reports in MLS?

rmrichesjr wrote: Sun May 01, 2022 11:15 am In LCR, Other -> Access Table will show which callings have access to which features. However, I don't see "custom" anywhere in the table. Do you perhaps mean custom reports in MLS?

The option is called 'Create Reports' in the 'Reports' section. I's only available to the bishopric, ward clerk (not assistants) and exec sec and similar callings at the stake level.

If you access LCR using the Chrome browser there is a Chrome extension that will copy a table on a website to Excel or Google Sheets. I’ve found it very helpful for this issue.

I believe only the ward clerk has the ability to create custom reports.

waltbristow wrote: Wed Jun 15, 2022 3:19 pm I believe only the ward clerk has the ability to create custom reports.

And the Bishop and his counsellors! Also the Exec Secretary!

bjenks wrote: Sat Feb 26, 2022 7:59 pm 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.

Thanks this was very useful

The way I do it that works quite well is to pull a list of expenses (under the expense summary tab) I want (say welfare provided for a specific family). Then I right mouse click and select Print, then save/print as a PDF. I then use a free pdf to Excel converter which converts it to Excel. This captures 95% of the data and requires minor formatting to make "whole".

Another way is to use the Data > Get Data > From File > From PDF function inside Excel

See https://www.howtogeek.com/770474/how-to ... oft-excel/

If you open the 'notes' app in windows, and highlight a data table in LCR, then paste it to 'notes', then copy that from notes into excel it will populate as a table.

cottrells wrote: Sat Jan 21, 2023 6:20 am Another way is to use the Data > Get Data > From File > From PDF function inside Excel

See https://www.howtogeek.com/770474/how-to ... oft-excel/

My is missing the attendance status with this method. Adobe pdf-to-Excel convertor works better, but it produces little images for the status instead of checkboxes.

tylersedwards wrote: Sat May 04, 2024 4:57 pm If you open the 'notes' app in windows, and highlight a data table in LCR, then paste it to 'notes', then copy that from notes into excel it will populate as a table.

Windows does not have a native app with such a name. Can you be specific in terms of where to copy the data table? From the pdf, the attendance status checks won't be able selected at all, so I doubt they would be copied.

I tried to copy/paste the LCT Create Report output in Firefox. It would not pick up the member's names or column headings but it would get the other date in the report. I switched over to Edge and then I was able to pick up and copy/paste all the information. FYI