Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Integrate data with other applications

Spreadsheet import overview

Use the Spreadsheet Import wizard to import data from a spreadsheet in .XLS or .XLSX file format. During the import process, you will map the spreadsheet columns to data in The application verifies the data based on the specified mappings.

Special information

  • You'll need to have Microsoft Excel installed on the computer you run the import on. Make sure that the spreadsheet is closed before you start the import process.
  • You can go to
    Setup
    ,
    File Locations
    , then select the
    Import Data
     tab to specify the default location for the spreadsheet files that you'll import in the
    Spreadsheet
     field.
  • You must format columns as Text in Microsoft Excel for non-segmented clients that contain subcodes in accounts.
  • Before you start the import process, verify that there are no blank rows between data records in the spreadsheet, because these will stop the import.
  • If the
    Worksheet to import
     dropdown list is blank, verify that the spreadsheet file type is
    XLS
     (not XLSX) and re-import the data. You may also want to close and restart the application to re-populate the drop-down list. You can also change the spreadsheet type from XLSX to XLS or vice versa, then re-import the data.
  • You can save mapping information from a prior import as a mapping template in the Column Mappings screen.
    • To save mapping information as a template, right-click in the
      Template
       field, select
      Add Template
       from the context menu, then enter the template name.
    • To change the name of a mapping template, select the template to rename, right-click in the
      Template
       field, select
      Edit Template
       from the context menu, and enter the new name.
    • To delete a saved mapping template, select the template to delete, right-click in the
      Template
       field, and select
      Delete Template
       from the context menu.
  • You will get invalid items flagged if there are any problems in the Column Mappings screen and/or any of the Data mapping screens.  In the Error Navigation section below the mapping grids, you can review the total number of errors found. Use the navigation buttons to move to each error and correct the data.
Setup data
  • Chart of Accounts
Transaction data
  • Account balances from QuickBooks
  • Account balances from Xero
  • Transactions

This article applies to:

  • Product: Workpapers CS
  • Subject: Integration, Import

Related content