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 4580 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? (19899 views)
  2. Can I get previous years in my OPTIMAL account? (Yes) (19315 views)
  3. What do I do first? (11170 views)
  4. What is a 'block' of parenting time? (9881 views)
  5. How do I import SPARC Parenting Time Tracker into OPTIMAL? (9773 views)
  6. Can both parents use OPTIMAL? (Yes) (9765 views)
  7. How do I use the OPTIMAL system? (9735 views)
  8. What exactly is OPTIMAL? (9713 views)
  9. How can OPTIMAL help me? (9053 views)
  10. What is the OPTIMAL toolbar? (8836 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?