Preparing Excel data for import into UltraTax CS statements

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

Change to CS Support service hours

Our Support department is closed on [[date]]. However, limited UltraTax CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline.

Links to our most popular tax processing topics are available in the Alerts and notices section on the right side of most pages.

Before you can import data from Excel (or another application) into UltraTax CS statements, you may need to take additional steps to prepare the information for processing.

Save the Excel spreadsheet containing the data you want to import to a local or network hard drive, or embed it in FileCabinet CS. If the spreadsheet was sent from a client as an attachment to an email message, use Excel to save the file to the hard drive.

Note: If the data is not in Excel format (it was created and saved in a application other than Excel), copy the data to the Windows Clipboard. To do this, open the spreadsheet file, highlight all the data to be imported, then choose Edit > Copy. Consult the help for the spreadsheet application for more information on copying a range of cells.

Formatting guidelines for Excel spreadsheets

Consider the following information when creating or formatting an Excel file that will be imported into an UltraTax CS statement. Also, review the examples of data that must be verified for information on formatting certain values.

Note: If the spreadsheet has column headings, include them in the range to copy so they will be available for reference when mapping columns in UltraTax CS.

Next step: Select the spreadsheet to import

Related topics

Importing Statement Data from Excel overview

Share This