Tip of the Day (Legacy Staff) - exporting as a CSV All versions (at least since 5)
You can export the Name List and any Search List as a CSV file and then open that file in a spreadsheet program. I recommend that you use the free Open Office spreadsheet program and not MS Excel. Excel can't handle pre-1901 dates so you will have a problem sorting by columns. Even with Open Office you will have some issues with the date qualifiers (abt, bef, aft, bet, cir) but it will still go much better than in Excel. If you are going to export to a CSV file, don't bother setting the column widths before export. A CSV is very generic and no matter how you set the columns in Legacy you will have to adjust them when you open the file in a spreadsheet program. If you need more fields go to Row 2 (and 3) and set them there. If you are exporting to a CSV these fields will export correctly as additional columns not "rows." You will see the additional rows if you export in any other way. Michele Simmons Lewis, CG Legacy Family Tree [email protected] <mailto:[email protected]> www.legacyfamilytree.com <http://www.legacyfamilytree.com/> Certified Genealogist is a registered trademark and the designation CG is a service mark of the Board for Certification of GenealogistsR, used under license by Board certificants who meet competency standards.
-- LegacyUserGroup mailing list [email protected] To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/[email protected]/
