Intuit HelpIntuit
How to import tax data from a spreadsheet in ProConnect Tax
by Intuit•3• Updated 4 months ago
This article will help you determine what types of data you can import, and import spreadsheet data to your clients' tax returns.
Before you start:
- Only Excel files (.xls or .xlsx) or comma-separated value files (.csv) can be imported.
- Only the first worksheet in a file will be imported.
- We recommend using the quick start templates and data rules found below to organize your clients' data before importing.
Follow these steps to import data:
- Go to the Input Return tab.
- At the top right corner of your screen, click Import Data.
- From the picklist presented, under Tax Documents, select Upload files.
- Click Browse to navigate to the spreadsheet on your computer.
- Select the spreadsheet, and click Open.
- Click the Next button at the bottom right of your screen.
- On the Map data screen, click Select Heading to select the column header that matches your data.
- Repeat this step for all columns you wish to import.
- Click the Next button.
- On the Review & import screen, review all of the items that are going to be imported.
- To ignore a particular row, un-check the box on the left side of the row.
- To make other changes, click the Previous button at the bottom right of your screen.
- Once you're satisfied with the data, click the Import button.
Related topics
Sign in now for personalized help
Ask questions, get answers, and join our large community of Intuit Accountants users.
More like this
- Using Lacerte Data Conductor to import databy Intuit•2•Updated August 09, 2024
- Using the Schedule D Import Wizard in Lacerteby Intuit•33•Updated August 19, 2024
- How to import or export spreadsheet data in EasyACCTby Intuit•Updated May 24, 2024
- Common questions about Form 1040 Schedule D in ProConnectby Intuit•23•Updated December 13, 2023