home | optimal demo | help & faq | feature tour | links | affiliates | contact us | get optimal
   
Your browser appears to have Javascript disabled.
Please enable Javascript in order to use this site.
(This site will not function properly for you without Javascript)

How do I export the Tracker records to an Excel spreadsheet? (viewed 5482 times)

You can export the Tracker records to a 'comma-delimited' or Microsoft Excel spreadsheet format by following these steps:

  1. Go to the Print and Export screen by clicking on the printer icon in the toolbar.
  2. Select Custody Tracker from the drop-down list next to the line that says Export records from.
  3. Select the month and year to export the records from.
  4. If you want to include the Tracker time stamps, place a checkmark in the Show timestamps for Tracker events checkbox.
  5. If you want, add a title. This title will appear at the top of the Export Results screen.
  6. Click the Export Records button. A new window will open with the exported results.
  7. To format the results for copying into Excel, copy the entire Export Results screen (press CTRL-A on your keyboard) and then press CTRL-C.
  8. (Optional) Open a text editor such as Notepad and paste everything into a blank page. Then select everything again (press CTRL-A on your keyboard) and then press CTRL-C. This step removes all formatting that Excel may try to use (tables, fonts, colors, etc).
  9. Open Excel and press CTRL-V on your keyboard. The results will be pasted into Excel formatted by row and column.
Note: This procedure also works for other exported data, such as the Child Support Tracker, Contacts List, etc.

Most Frequently Viewed FAQ Pages:
  1. Can I use any web browser with OPTIMAL? (25691 views)
  2. Can I get previous years in my OPTIMAL account? (Yes) (23194 views)
  3. What do I do first? (12892 views)
  4. How do I import SPARC Parenting Time Tracker into OPTIMAL? (11586 views)
  5. Can both parents use OPTIMAL? (Yes) (11481 views)
  6. What is a 'block' of parenting time? (11374 views)
  7. How do I use the OPTIMAL system? (11238 views)
  8. What exactly is OPTIMAL? (11205 views)
  9. What is the OPTIMAL toolbar? (10625 views)
  10. How can OPTIMAL help me? (10506 views)


 Home | About | Affiliates | Links | Contact | Privacy | Terms of Use     2003-2012 All Rights Reserved.
"ParentingTime" and "OPTIMAL" are trademarks of ParentingTime.net
OPTIMAL LOGIN
Username: 
Password: 
Forgot your password?