ProConnect HelpProfile HelpIntuit

Export ProFile data into Excel with Classic Database

SOLVEDby IntuitUpdated October 20, 2023

Use the Export feature to work with ProFile data in another program. For example, you can import ProFile customer names and their EFILE/Print status into a text file, which can then be imported into another program for analysis, or to create a report.

Export to Microsoft Excel using the Classic Database

  1. Open ProFile.
  2. Select the Export... option from the Database drop-down menu in the top toolbar. The Export window displays.

  1. Select the Index button; the File Index window displays.
  2. Select the Browse button and navigate to the location where the customer files are stored.
  3. Select the folder containing the customer files and click the OK button; the file path displays in the field.
  4. Select the OK button; the customer data populates in the Export window.
  5. Select the Select All button. All client data is selected. To unselect specific customers, uncheck the box associated with the client name.

  1. Click the Options button; the Export Options window displays.
  2. Click the Add button; the Select Field window displays.

A picture of a computer screen with a picture of a person on it.

The following forms are available to select fields from:

  • Personal Info
  • T1 Jacket
  • T1 Schedules
  • Invoices
  1. Navigate to the desired heading. The available fields for export are listed within the heading.
  2. Select the field for export.
  3. Click the OK button. The field is added to the Export Options list.
  4. Repeat the selection of headings and fields as required. The selected headings and fields will be exported from ProFile.

Note: In some instances the specific desired field is not listed in the Select Field list. In this case, click the Pick button in the Export Options window and determine if the field is available and add.

In the case that the specific desired field cannot be found in the Add or Pick list, enter the field code manually in the Export Options window.

Deleting a field

If a field is not required for export:

  1. Select the field in the Export Options list.
  2. Click the Delete button; the field deletes from the list.

Organizing the order of fields

  1. Select an individual field listed in the Export Options list.
  2. Select the Up or Down arrow to move the selected field up or down in the order of fields.

This order is reflected when the data is exported.

Exporting data

  1. Click on the Format tab in the Export Options window.

  1. Click the folder icon at the end of the Export to File field; a folder explorer window displays.
  2. Navigate to the location to export the customer data.
  3. Right-click in the directory. A menu displays.
  4. Select the New option and Text Document from the subsequent menu. A new .txt document is created.

  1. Rename the file (for example, Export Data), select it and then click Open. In the field, rename the file extension to .xls  (for example,test.txt" is renamed to test.xls).
  2. Click the down-arrow on the Export Type drop-down menu.
  3. Select the Tab Delimited option.
  4. Click the Export Field Names checkbox to activate it.
  5. Click the OK button. When prompted, answer Yes to the question These options have been changed. Do you wish to save them to a file?
  6. Click the Export button. The ProFile customer data populates in the new file.

User-added image

Reviewing the exported data

  1. Navigate to the saved .xls file.
  2. Open the Excel document. If a warning window appears, select Yes button.

Was this helpful?

You must sign in to vote, reply, or post
ProFile Tax

Sign in for the best experience

Ask questions, get answers, and join our large community of Profile users.