Fields and Tables to Excel Wizard

Fields and Tables to Excel Wizard box shotThis standalone Act! addon executable opens Excel, and creates a separate spreadsheet for every table (entity) within an Act! database.

Tables included are; Contact, Group, Company, Activity, Notes, Histories, Opportunity and Secondary Contact. Each spreadsheet lists all the fields and the following columns:

  • Display Name -- The name that shows on a layout
  • Table Name -- The internal name of the Act! table
  • Column Name -- The actual internal name of the field
  • Data Type -- Character, date/time, number, annual event, etc.
  • Length -- Size of field
  • Pick List -- Name of drop down list
  • Is Custom -- Yes/No -- is it a custom field
  • Is Defined -- Yes/No -- is it
  • Is Primary -- Yes/No -- is it a primary field
  • Allow Edit -- Yes/No -- Allow editing
  • Allow Blank -- Yes/No -- Allow blank fields
  • Allow Null -- Yes/No -- Allow null fields
  • Create History -- Yes/No -- Create history when updated
  • Trigger on Focus -- Shows the path if a trigger exists
  • Trigger on Lost Focus -- Shows the path if a trigger exists
  • Trigger on Change -- Shows the path if a trigger exists
  • Default Value -- Shows the default value if present

This extract is helpful if you are working on XML reports or with reporting tools such as Crystal.

Fields and Tables to Excel Wizard screen shot

Click to view larger image

Patricia Egen Logo



Other products by Patricia Egen Consulting:

Advanced CopyFields Wizard
Addon that creates Advanced Copy/Replace/Swap menu items in Act!. You can copy, replace or swap ANY type field with ANY other type field. Exceptions -- you can not work with any Act! system fields.

Advanced Delete User Wizard
Advanced Delete User Wizard -- Allows the removal of users from an Act! database while retaining a historical reference to entries created by the user being deleted.

Company Wizard Plus
Act! plug-in that works on Contact Lists. All contacts selected will automatically be added to a Company record. If the company doesn‘t exist, it will be created. Any contacts with blank names or blank company fields are skipped.

Duplicate Remover Wizard Expert
Batch remove duplicate contacts and companies in Act!. Merge all documents, notes, histories, fields, groups, etc. Search on up to 6 fields for dups. FREE TRIAL

Fields and Tables to Excel Wizard
Standalone tool that reads an Act! database and dumps all field structures to an Excel spreadsheet. One sheet is created for all entities.

Mail Merge
Helps you create HTML templates and send them quickly to as many Act! contacts as you need to. Don't struggle with limited Merge tools. FREE TRIAL

Sales Automation Bundle
Sales Automation Bundle -- essential automation for all of you busy salespeople and sales administrators. This bundle features three outstanding products that work together beautifully. Automate: adding contacts to Act! from web forms, high volume email merging and sending and your correspondence, activities and decision-making. Save $187. FREE TRIAL

Sales Automation Manager
Perfect Followup... made easy! Sales Automation Manager (SAM) adds to Act! the power to automatically schedule activities and generate correspondence according to patterns (called "campaigns") that you define. FREE TRIAL

Secondary Contact Wizard
Tool to demote primary to secondary contact. You have the option to copy all the notes and histories from the demoted contact to primary contact. Gives you an option to delete the secondary or keep it as a primary.

Web Prospect
Enter contact information received from your Web site directly into Act! without re-typing. Define which Web fields correspond to which Act! fields. Web Prospect can be set up to enter related data from the Web into Act! Notes -- for example, products the customer is interested in, or where they saw your ad. Reads input from File, Clipboard or directly from Outlook folder. Creates new contact, or merges if Name and Company match. Supports FrontPage "Send to" Form data. Map any Web field to any Act! field or Notes/History. Auto-schedule followup activities. Works with Outlook 98 or 2000. FREE TRIAL

View Shopping Cart

$19.99 -- 1 User
Discount for 10+ copies

Compatible with:

  • Act! 7 / 2005 and Newer

Technical Support


Close Purchase Options

*If you are purchasing multiple copies, click the 'Buy Now' button below and at the next screen, change the quantity and press the 'Update Quantities' button. Your discount will show up in resulting screen.

All products have a 30-Day Money-Back Guarantee unless otherwise noted. All returned products are subject to a 10% restocking fee.

Fields and Tables to Excel Wizard

      Delivery Users Price    
     Download 1-10 each $19.99 Buy Now  
      11-50 each $18.00    
      51-99 each $17.00    

Close Purchase Options