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 5654 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? (26603 views)
  2. Can I get previous years in my OPTIMAL account? (Yes) (23864 views)
  3. What do I do first? (13336 views)
  4. How do I import SPARC Parenting Time Tracker into OPTIMAL? (11992 views)
  5. Can both parents use OPTIMAL? (Yes) (11913 views)
  6. What is a 'block' of parenting time? (11774 views)
  7. How do I use the OPTIMAL system? (11650 views)
  8. What exactly is OPTIMAL? (11607 views)
  9. What is the OPTIMAL toolbar? (11059 views)
  10. How can OPTIMAL help me? (10891 views)

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