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 6128 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? (28855 views)
  2. Can I get previous years in my OPTIMAL account? (Yes) (25411 views)
  3. What do I do first? (14201 views)
  4. How do I import SPARC Parenting Time Tracker into OPTIMAL? (12904 views)
  5. Can both parents use OPTIMAL? (Yes) (12890 views)
  6. What is a 'block' of parenting time? (12673 views)
  7. How do I use the OPTIMAL system? (12515 views)
  8. What exactly is OPTIMAL? (12456 views)
  9. What is the OPTIMAL toolbar? (11990 views)
  10. How can OPTIMAL help me? (11762 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?