Exporting MLS Reports for use in MS Office apps
-
- New Member
- Posts: 2
- Joined: Wed Dec 12, 2007 1:11 am
Exporting MLS Reports for use in MS Office apps
I am new to MLS (just called as the Ward Clerk). I know I can export membership data to .csv files that I can later import into Excel etc., but I would like to know if it is possible to use the "Print to a file" feature for any of the canned MLS reports the same way? What other programs (besides MLS itself) can read files with that file extension? For instance, I created an organizational chart for the entire ward and I want to be able to print the Members with calling (or without) and import those lists into Excel to make sure I have everyone slotted. The only way I can figure out to do that today is to scan in a printed list and use OCR software to convert the printed text to Word and then copy and paste it into Excel.
- thedqs
- Community Moderators
- Posts: 1042
- Joined: Wed Jan 24, 2007 8:53 am
- Location: Redmond, WA
- Contact:
-
- Senior Member
- Posts: 514
- Joined: Wed Jan 24, 2007 5:38 pm
- Location: Oregon City, OR
- Contact:
Copy and Paste MLS report data in delimited form
Bfolker wrote:I am new to MLS (just called as the Ward Clerk). I know I can export membership data to .csv files that I can later import into Excel etc., but I would like to know if it is possible to use the "Print to a file" feature for any of the canned MLS reports the same way? What other programs (besides MLS itself) can read files with that file extension? For instance, I created an organizational chart for the entire ward and I want to be able to print the Members with calling (or without) and import those lists into Excel to make sure I have everyone slotted. The only way I can figure out to do that today is to scan in a printed list and use OCR software to convert the printed text to Word and then copy and paste it into Excel.
In any of the MLS reports (canned and custom), if you click in the body of the report and do a control-shift-c, MLS places a delimited copy of the report data into the Windows clipboard. You can then paste the data directly into your spreadsheet.
-
- New Member
- Posts: 26
- Joined: Fri Oct 05, 2007 6:37 pm
- Location: Phoenix, Arizona
danpass wrote:In any of the MLS reports (canned and custom), if you click in the body of the report and do a control-shift-c, MLS places a delimited copy of the report data into the Windows clipboard. You can then paste the data directly into your spreadsheet.
This is one of the great mysteries of MLS that is worth its weight in gold. All stake clerks and computer specialists should spread this word to all ward clerks and assistant clerks. I learned about this by calling SLC and complaining that I couldn't export any list, and they told me about the CNTL-SHIFT-C combination. I use it all the time.
Jerry