stake YW list
-
- New Member
- Posts: 19
- Joined: Wed Dec 22, 2010 12:10 pm
stake YW list
Is there a way to export the stake YW list as an Excel file instead of a pdf file?
I have tried the online converters and all the data doesn't line up in the correct columns.
Thanks
Jeff Worthington
Peoria Il stake clerk
I have tried the online converters and all the data doesn't line up in the correct columns.
Thanks
Jeff Worthington
Peoria Il stake clerk
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
Re: stake YW list
I've had very good results by simply doing the following:jworth1 wrote:Is there a way to export the stake YW list as an Excel file instead of a pdf file?
I have tried the online converters and all the data doesn't line up in the correct columns.
- In LCR, go to the Membership > Member List
- Apply whatever filters you want
- Sort however you want by clicking on the appropriate column header
- In the browser, select the entire table (including column headers), then copy to clipboard (Ctrl+C on Windows)
- In Excel (or another spreadsheet), go to a blank sheet and then do Paste Special and choose Text
- Adjust column widths and formatting as desired
-
- New Member
- Posts: 19
- Joined: Wed Dec 22, 2010 12:10 pm
Re: stake YW list
I will try that but it used to be that you could export files in .xls format. Most leaders like to have that option to resort that data. So, will that be an option also off of lds.org like the option in MLS?
-
- Senior Member
- Posts: 2859
- Joined: Sun Jul 01, 2007 6:06 pm
- Location: Plattsmouth, NE
Re: stake YW list
I am wondering if you need to use Text to Columns to separate the pasted data into separate columns. When I paste the data, it all goes into a single column.
Dana Repouille, Plattsmouth, Nebraska
-
- New Member
- Posts: 19
- Joined: Wed Dec 22, 2010 12:10 pm
Re: stake YW list
When I tried to convert the pdf file to xls online, some of the data didn't get put in the right columns so that didn't work for me at all.
Not sure what you mean "text to columns"...
Not sure what you mean "text to columns"...
- mlh78
- Member
- Posts: 249
- Joined: Mon Dec 14, 2009 1:03 pm
- Location: Texas, USA
Re: stake YW list
Once a month, I simply export all of the MLS data (created in a custom report) to Excel. I spruce up the headings a bit, and copy in some custom formulas to give some more data (e.g., is temple recommend expired, are they prospective elders, and a few others). Then when I get requests from auxiliaries and others, I can super easily create a custom report that I can send to them in Excel.
-
- New Member
- Posts: 19
- Joined: Wed Dec 22, 2010 12:10 pm
Re: stake YW list
Would you be willing to share that custom report criteria?
- mlh78
- Member
- Posts: 249
- Joined: Mon Dec 14, 2009 1:03 pm
- Location: Texas, USA
Re: stake YW list
Sure. I don't set any criteria, so that it grabs everyone. Then you can simply select all of the information, but I select just the following (in this order):jworth1 wrote:Would you be willing to share that custom report criteria?
Preferred name
Ward/Branch
Move In Date
Record Number
Sex
Birth Date
(I insert a column in Excel that converts the birth date to age based on the current date)
Baptism Date
Confirmation Date
(I insert a custom column in Excel that says if they are a Man, Woman, Infant, Child, Priest age, Teacher age, Deacon age, Laurel age, Mia-Maid age, or beehive age)
Is Convert
Priesthood Office
Ordination Date
Ordained By
(I insert a custom column in Excel that says if they are a prospective elder)
Is Endowed
Endowment Date
Temple Recommend Expiration Date
(I insert a custom column in Excel that determines if their recommend is current)
Is Returned Missionary
Mission Language
Mission Country
Sealing to Parents
Is Married
Spouse Name
Marriage Date
Is Sealed to Spouse
Sealing to Spouse Date
Is Sealed to Prior Spouse
Is Widowed
Has Children
Household Position
Head of House and Spouse
Home Teachers
Birthplace
Birth Country
Is Accountable
Contact E-Mail
Contact Phone Number
Address Street 1
Address Street 2
Address - City
Address - State
Address - Postal Code
Stake Geo Code
Is Registered for Seminary/Institute
Callings with Date Sustained
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
Re: stake YW list
Are you talking about Leader and Clerk Resources? I don't recall that ever being an option for membership lists.jworth1 wrote:I will try that but it used to be that you could export files in .xls format.
If you follow my steps, you end up with an excel file that allows for resorting, filtering, formatting, etc.jworth1 wrote:Most leaders like to have that option to resort that data.
I have no idea. You can certainly request it by using the Feedback link.jworth1 wrote:So, will that be an option also off of lds.org like the option in MLS?
But personally, I find my copy/paste technique to be just as easy as an export would be. In just a few seconds, I have a spreadsheet.
- Biggles
- Senior Member
- Posts: 1608
- Joined: Tue May 27, 2008 5:14 am
- Location: Watford, England
Re: stake YW list
How will you achieve this once MLS is retired?mlh78 wrote:Once a month, I simply export all of the MLS data (created in a custom report) to Excel. I spruce up the headings a bit, and copy in some custom formulas to give some more data (e.g., is temple recommend expired, are they prospective elders, and a few others). Then when I get requests from auxiliaries and others, I can super easily create a custom report that I can send to them in Excel.