Page 1 of 1

Exporting Organization Chart for Import to Excel

Posted: Thu Mar 05, 2015 10:19 am
by bballrob
Is there a way to export a report containing auxiliary presidency information FROM THE LEADER AND CLERK RESOURCES WEBSITE that can be easily imported into Excel?

Re: Exporting Organization Chart for Import to Excel

Posted: Thu Mar 05, 2015 11:22 am
by kisaac
bballrob wrote:Is there a way to export a report containing auxiliary presidency information FROM THE LEADER AND CLERK RESOURCES WEBSITE that can be easily imported into Excel?
I like using MLS custom reports for more control....
And, "easily imported" depends on several factors...

You can call up the report you need in LCR (either each organization's report, or the "callings by organization" if you want multiple organizations.) I can do it this way on my desktop "IBM compatible:" (Do we still say that? Or, is it now a "non-mobile non-Apple device?")
Copy the information
  • left mouse "click and hold" while dragging to select the whole list, or just the parts you need
  • once selected, release the mouse and choose "copy" from menu or right mouse click
Paste the information in excel
  • In your choice of cells, paste (right mouse click or other menu,) choosing paste options CAREFULLY (probably using "text" or "destination formatting" options is what you are seeking, try "paste special if problems)
  • Clean-up the data you don't want or need in excel be deleting columns, etc
Your mouse clicks may be different!
you might also find my description in this thread for a similar method, but using the adobe reader PDF of a report to help you copy and paste:
Re: Unfilled calling report