Triva isn't available right now.
Check out the support page for our phone number and hours
Solutions
-
Corporations
-
Governments
Success stories
-
A true competitive advantage
Law firm Zarin Baum’s embrace of generative AI as the natural next step in the evolution of legal work and their adoption of CoCounsel Legal has helped them achieve remarkable efficiency gains and improved client relationships.
-
Workflow transformation drives impact
Brinks, a global leader in secure logistics and security solutions, used CoCounsel to reimagine what was possible with AI tools, turning legal challenges into a competitive advantage.
-
The forefront of audit tech
A better auditing workflow solution was the answer to multiple challenges faced by The Mercadien Group. Find out how they achieved greater efficiency by embracing Cloud Audit Suite.
Questions? We are here to help.
Products
-
Tax, audit & accounting
Recommended products
-
CoCounsel Legal
Transform your work with the only AI legal solution uniting research, drafting, and document analysis in a single experience. Designed by legal experts and built on trusted content and advanced AI, CoCounsel Legal accelerates multistep work so you can better serve your clients and grow your business.
-
CoCounsel Tax
Transform your tax practice with CoCounsel Tax, an AI-powered assistant that combines trustworthy answers, automation, and firm knowledge into one seamless platform. Enhance efficiency, reduce risk, and improve client confidence with CoCounsel Tax.
-
CLEAR
Powerful software designed for law enforcement, compliance, risk, and fraud investigators. Conduct thorough investigations with ease using our intuitive online investigation software. Efficiently, prevent, detect, and solve crime.
Questions? We are here to help.
Purchase
-
Buy books
-
Contact sales
Resources
-
Product training
-
Product communities
-
Developers
Highlights
-
2026 SKILLS showcase
Join weekly sessions to experience in-depth demonstrations of the leading legal AI products while connecting with strategic law firm leaders in knowledge management, innovation, and AI.
-
Ghosts on the ledger
Payroll fraud is a major compliance risk. Learn how payroll analytics and AI-powered tools can help exorcise phantom employees and employers.
-
Future of professionals report 2025
The Thomson Reuters Future of Professionals Report 2025 reveals how AI continues to shape professional work — and what it takes to get ahead. This year’s report shows that increased efficiency, productivity, and cost savings top the list of benefits professionals attribute to AI, making it indispensable for organizations facing rapid change.
Import Spreadsheet - Step 2 of 2 dialog
Show all expandable content
Use this dialog to either create or update column mappings, to edit spreadsheet data before importing, and to prevent spreadsheet rows from being imported. Mapping columns establishes a link between the spreadsheet columns and the UltraTax CS statement dialog columns so that the data transfers to the appropriate location in the statement.
The data from Excel (or the Windows Clipboard) appears in a grid in this dialog. Each column in the Import Spreadsheet grid has a drop-down list at the top that is used to map that column. From each drop-down list, select the UltraTax CS statement dialog column that corresponds with the data in that spreadsheet column.
For important information on importing spreadsheet data into UltraTax CS statement dialogs, see Importing Statement Data from Excel. The overview provides a general outline of the import process and links to specific procedures detailing each step.
To open this dialog, choose Statement then Import Spreadsheet from within any UltraTax CS statement dialog.
Fields & buttons
Import data from
If you are importing from an Excel file, this field displays the file name and location of the spreadsheet that you specified in the
File
or FileCabinet CS
field in the Import Spreadsheet - Step 1 of 2 dialog.If you are importing from the Windows Clipboard, this field displays "Windows Clipboard" as the data source.
Column mapping name
Use this field to edit the name of the column mapping defined in this dialog. By default, UltraTax CS names the column mapping using the title of the current statement dialog.
Previous / Next buttons
Select the Previous and Next buttons to navigate among the columns in the Import Spreadsheet grid.
Omit row checkboxes
Mark the
Omit Row
checkbox to prevent a row from importing into the current statement dialog.note
To omit a
column
, leave the drop-down list at the top of the column blank. This prevents the grid column from being mapped to a statement dialog column, so any data in that grid column will be ignored during the import.Header rows
Each column in the Import Spreadsheet grid has a drop-down list at the top that is used to map that column. From each drop-down list, select the UltraTax CS statement dialog column that corresponds with the data in that spreadsheet column.
Once a column is mapped, the second header row will display the name of the statement dialog column that you specified using the drop-down list, indicating that the grid column has been mapped to that statement dialog column.
note
- If a mapped column contains data that is not appropriate for the statement dialog column you specified, UltraTax CS will display a red border around the cells that contain the invalid data. If you do not correct this data in the Import Spreadsheet grid, you will be prompted to correct it when you verify the imported information and complete the import process.
- You cannot select a statement dialog column that is calculated by UltraTax CS. For example, the Gain/Loss column in the statement dialog for Schedule D in the B&D Screen in UltraTax/1040 cannot be mapped because UltraTax CS automatically calculates this column. If you import cost/basis and sale price, UltraTax CS will automatically calculate the gain or loss in the Gain/Loss statement dialog column.
Import Spreadsheet grid
The Import Spreadsheet grid contains the data imported from either the Excel spreadsheet specified in the Import Spreadsheet - Step 1 of 2 dialog or from the Windows Clipboard. Use this grid to map each column to a statement dialog column and to edit or correct the data as necessary.
Each column in the Import Spreadsheet grid has a drop-down list at the top that is used to map that column. From each drop-down list, select the UltraTax CS statement dialog column that corresponds with the data in that spreadsheet column.
note
- If a mapped column contains data that is not appropriate for the statement dialog column you specified, UltraTax CS will display a red border around the cells that contain the invalid data. If you do not correct this data in the Import Spreadsheet grid, you will be prompted to correct it when you verify the imported information and complete the import process.
- You can prevent any row from importing into the statement dialog by marking the correspondingOmit Rowcheckbox.
- You can prevent any column from importing into the statement dialog by leaving the drop-down list at the top of the column blank. This prevents the grid column from being mapped to a statement dialog column, so any data in that grid column will be ignored during the import.
note
Tips
- You can resize this dialog to make the Import Spreadsheet grid easier to use. To do so, select and drag any edge or corner and "stretch" the dialog to the desired size.
- You can prevent any row from importing into the statement dialog by marking the correspondingOmit Rowcheckbox.
- You can prevent any column from importing into the statement dialog by leaving the drop-down list at the top of the column blank. This prevents the grid column from being mapped to a statement dialog column, so any data in that grid column will be left out of the import.
- You may also use the Data Verification dialog to import spreadsheet data into UltraTax CS statement dialogs.
This article applies to:
- PRODUCT: UltraTax CS,UltraTax CS