Use this article to help resolve import issues. For issues that are not identified in this article, please reach out to support@termsheet.com
Jump To:
General Notes
Date Fields
When manually entering any date for an import, it must be in one of the following formats (For CSV files):
- YYYY-MM-DD
- MM-DD-YYYY
- 2023-03-02T00:00:00Z (for database exported data)
When a file is saved/imported as an Excel file, the format is not important.
Imports to Update Existing Data
TermSheet allows for bulk updates to existing data through import. The TermSheet ID is the unique identifier that is mapped from the import to the existing record to ensure the changes are applied to the correct existing records.
To view any record's ID field, enable it in a report (via Report Builder) 
or in any View (in the object/module itself) then export the records. 
Non Importable Fields
Some fields are not able to be added/updated via import template. These include calculated fields and fields that have been hidden in the platform. To double check if a field is importable or not, visit Fields in Settings to review the Importable column. 
Deal Imports
Required Fields:
- Name
To import deals that connect existing properties to the deals, use the Property IDs and add those to the deal import.
When adding data to the workspace for the first time (new deal data) perform the Deal Import first, here you can include contacts, companies, properties, and other 'related-to' fields. Contacts, companies, and properties included in the deal import will be created in the system automatically (eliminating the need to do separate contact, company, property imports and then link the records together.)
Contact Imports
Required Fields: (at least one of any of the following)
- Phone
- Mobile
- First Name & Last Name (both columns must be included)
Company Imports
Required Fields:
- Name
Property Imports
Required Fields: (at least one of the following)
- Name
- Address
Custom Object Imports
Required Fields:
- Name
