--- title: Import Transactions via CSV or XLSX File description: Managing your own Transaction Imports can be completed in a matter of just a few steps and a little bit of organization ahead of time. --- [Skip to content](https://support.thinkaidium.com/v2-import-transactions-with-uploaded-csv-file#main-content) English Show submenu for translations [Sign in](https://support.thinkaidium.com/_hcms/mem/login?redirect_url=https%3A%2F%2Fsupport.thinkaidium.com%2Fv2-import-transactions-with-uploaded-csv-file&hsLang=en) [![Logo-Green-Positive@4x](https://support.thinkaidium.com/hs-fs/hubfs/Logo-Green-Positive@4x.png?width=184&height=35&name=Logo-Green-Positive@4x.png)](https://lendware.ai/) Open main navigation Close main navigation - English Show submenu for translations - [Sign in](https://support.thinkaidium.com/_hcms/mem/login?redirect_url=https%3A%2F%2Fsupport.thinkaidium.com%2Fv2-import-transactions-with-uploaded-csv-file) - Contact us Contact us How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://support.thinkaidium.com/?hsLang=en) 2. [Transactions](https://support.thinkaidium.com/transactions?hsLang=en) 3. [More Functions](https://support.thinkaidium.com/transactions?hsLang=en#more-functions) # Import Transactions via CSV or XLSX File ## Managing your own Transaction Imports can be completed in a matter of just a few steps and a little bit of organization ahead of time. You can easily import your transactions into Lendware with a CSV or XLSX file. These file types are standard and supported by most spreadsheet programs like Excel, Google Sheets, and Apple Numbers. If you’re exporting from another system, use the “Download,” “Export,” or “Save As” function to get your file in CSV or XLSX format. We recommend using our [Transaction Import Template](https://support.thinkaidium.com/hubfs/KB%20Files/Data%20template/Aidium%20Data%20Template.xlsx?hsLang=en) to organize your data before importing. 🚧  When importing dates, to ensure all dates are imported as expected, it's high suggested including the full year, for example: 1/1/1947 and 2/2/2002 --- ### Importing Walk-Through 1. #### Upload the File In the **Transactions** section, click the three vertical dots at the top-right and select **Upload CSV**. A popup will ask you to select the user the transactions will be assigned to. You can upload on behalf of any team member. Then, choose your file either by: - Drag-and-dropping it into the window, or - Clicking **Select file** to open your file browser. ![chrome_4XfJabhtfY](https://support.thinkaidium.com/hs-fs/hubfs/KB%20Files/Transaction%20page/chrome_4XfJabhtfY.gif?width=644&height=355&name=chrome_4XfJabhtfY.gif) 2. #### Map the Fields After uploading your file, Lendware will display a preview of your data. The **first row is automatically treated as headers**. You’ll complete the mapping in two steps: **2.1 Review and Confirm Each Mapping Choice** Lendware will try to auto-map your columns to the correct transaction fields. You can: - Hover over each column to preview the values. - Use the dropdown to select the appropriate Lendware field. - Adjust any fields that weren’t mapped correctly. Click **Continue** once everything is mapped. ![chrome_6cGyZ5hJiD](https://support.thinkaidium.com/hs-fs/hubfs/KB%20Files/Transaction%20page/chrome_6cGyZ5hJiD.gif?width=644&height=371&name=chrome_6cGyZ5hJiD.gif) **2.2 Map Incoming Values to Valid Options** Some fields (e.g., **Property State**, **Transaction Type**) require matching values from a predefined list. You’ll be prompted to map each unique value to a valid Lendware option. **Example:** **Property State** – 3 of 3 values mapped - - **CA** → CA - California - **TX** → TX - Texas - **NY** → NY - New York ![chrome_AOUa5rfFvu](https://support.thinkaidium.com/hs-fs/hubfs/KB%20Files/Transaction%20page/chrome_AOUa5rfFvu.gif?width=644&height=371&name=chrome_AOUa5rfFvu.gif) 3. **Final Review** The final step shows three tabs: - **All**: All records - **Valid**: Records ready to import - **Invalid**: Records with errors You can: - Edit any field directly - Delete selected rows - Download selected data Once reviewed, click **Import Data** to complete the import. ![chrome_w9xSMiQQB4](https://support.thinkaidium.com/hs-fs/hubfs/KB%20Files/Transaction%20page/chrome_w9xSMiQQB4.gif?width=644&height=371&name=chrome_w9xSMiQQB4.gif) 4. #### Completion After submitting, you'll receive a success message. If any errors occurred, you’ll get an email with details so you can re-import corrected data. ![chrome_gGSxG4guaz](https://support.thinkaidium.com/hs-fs/hubfs/KB%20Files/Transaction%20page/chrome_gGSxG4guaz.jpg?width=670&height=459&name=chrome_gGSxG4guaz.jpg)   ### Mapping Transaction Fields If your column names don’t match Lendware’s fields, or if your file has no headers, you’ll need to map fields manually. - Lendware will show previews of your data. - Use the dropdown to link each column to the appropriate field. > Adding headers in your spreadsheet ahead of time will make this process much faster. ❌ If you exit the import process before submission, **you’ll need to start over**. There is no save-and-return feature at this time. ✅ However, during the mapping phase, you can **exit to upload a different file** or **go back to adjust mappings** without restarting the full process. 👍  This concludes the importing walk-through.   ---   - [Automations](https://support.thinkaidium.com/automations?hsLang=en#main-content) - [Introduction](https://support.thinkaidium.com/automations?hsLang=en#introduction) - [Advanced](https://support.thinkaidium.com/automations?hsLang=en#advanced) - [Initial Setup](https://support.thinkaidium.com/automations?hsLang=en#initial-setup) - [Build Specific Contact Automations](https://support.thinkaidium.com/automations?hsLang=en#build-specific-contact-automations) - [Contacts](https://support.thinkaidium.com/contacts?hsLang=en#main-content) - [Contact Detail Page](https://support.thinkaidium.com/contacts?hsLang=en#contact-detail-page) - [Contacts Page](https://support.thinkaidium.com/contacts?hsLang=en#contacts-page) - [Filters](https://support.thinkaidium.com/contacts?hsLang=en#filters) - [More Functions](https://support.thinkaidium.com/contacts?hsLang=en#more-functions) - [Beta Features](https://support.thinkaidium.com/beta-features?hsLang=en#main-content) - [Marketing Forms & Sites](https://support.thinkaidium.com/beta-features?hsLang=en#marketing-forms-sites) - [Custom Fields](https://support.thinkaidium.com/custom-fields?hsLang=en) - [Email and Text Messages](https://support.thinkaidium.com/email-and-text-messages?hsLang=en#main-content) - [Email](https://support.thinkaidium.com/email-and-text-messages?hsLang=en#email) - [Opt-in / Opt-out](https://support.thinkaidium.com/email-and-text-messages?hsLang=en#opt-in-opt-out) - [In-app Calling](https://support.thinkaidium.com/email-and-text-messages?hsLang=en#in-app-calling) - [Communications](https://support.thinkaidium.com/email-and-text-messages?hsLang=en#communications) - [Text Message](https://support.thinkaidium.com/email-and-text-messages?hsLang=en#text-message) - [Enterprise Administration](https://support.thinkaidium.com/enterprise-administration?hsLang=en#main-content) - [Integrations](https://support.thinkaidium.com/enterprise-administration?hsLang=en#integrations) - [Teams / Users / Login](https://support.thinkaidium.com/enterprise-administration?hsLang=en#teams-users-login) - [Enterprise Management](https://support.thinkaidium.com/enterprise-administration?hsLang=en#enterprise-management) - [EAM - Enterprise Automation Management](https://support.thinkaidium.com/enterprise-administration?hsLang=en#eam-enterprise-automation-management) - [How-to Videos](https://support.thinkaidium.com/how-to-videos?hsLang=en#main-content) - [Dashboard](https://support.thinkaidium.com/how-to-videos?hsLang=en#dashboard) - [Email and Texting](https://support.thinkaidium.com/how-to-videos?hsLang=en#email-and-texting) - [Imports](https://support.thinkaidium.com/how-to-videos?hsLang=en#imports) - [Contacts](https://support.thinkaidium.com/how-to-videos?hsLang=en#contacts) - [Transactions](https://support.thinkaidium.com/how-to-videos?hsLang=en#transactions) - [Tasks](https://support.thinkaidium.com/how-to-videos?hsLang=en#tasks) - [Training Sessions](https://support.thinkaidium.com/how-to-videos?hsLang=en#training-sessions) - [Integrations](https://support.thinkaidium.com/how-to-videos?hsLang=en#integrations) - [Admin Settings](https://support.thinkaidium.com/how-to-videos?hsLang=en#admin-settings) - [Automations](https://support.thinkaidium.com/how-to-videos?hsLang=en#automations) - [User and Team Settings](https://support.thinkaidium.com/how-to-videos?hsLang=en#user-and-team-settings) - [Integrations](https://support.thinkaidium.com/integrations?hsLang=en#main-content) - [Point of Sale](https://support.thinkaidium.com/integrations?hsLang=en#point-of-sale) - [Identity Providers](https://support.thinkaidium.com/integrations?hsLang=en#identity-providers) - [Loan Origination Systems](https://support.thinkaidium.com/integrations?hsLang=en#loan-origination-systems) - [Lead Sources](https://support.thinkaidium.com/integrations?hsLang=en#lead-sources) - [Gifting Experiences](https://support.thinkaidium.com/integrations?hsLang=en#gifting-experiences) - [Lendware Predict](https://support.thinkaidium.com/lendware-predict?hsLang=en) - [Lendware - Support Articles](https://support.thinkaidium.com/lendware-support-articles?hsLang=en) - [Marketing](https://support.thinkaidium.com/marketing?hsLang=en#main-content) - [Forms](https://support.thinkaidium.com/marketing?hsLang=en#forms) - [Playbooks](https://support.thinkaidium.com/playbooks?hsLang=en#main-content) - [Events](https://support.thinkaidium.com/playbooks?hsLang=en#events) - [Loan Milestones](https://support.thinkaidium.com/playbooks?hsLang=en#loan-milestones) - [Retargeting](https://support.thinkaidium.com/playbooks?hsLang=en#retargeting) - [Integrations](https://support.thinkaidium.com/playbooks?hsLang=en#integrations) - [Introduction](https://support.thinkaidium.com/playbooks?hsLang=en#introduction) - [User and Team Settings](https://support.thinkaidium.com/user-and-team-settings?hsLang=en#main-content) - [User Settings](https://support.thinkaidium.com/user-and-team-settings?hsLang=en#user-settings) - [Notifications](https://support.thinkaidium.com/user-and-team-settings?hsLang=en#notifications) - [Team Settings](https://support.thinkaidium.com/user-and-team-settings?hsLang=en#team-settings) - [Integrations](https://support.thinkaidium.com/user-and-team-settings?hsLang=en#integrations) - [Tasks](https://support.thinkaidium.com/tasks?hsLang=en#main-content) - [Introduction](https://support.thinkaidium.com/tasks?hsLang=en#introduction) - [Cross-team Tasks](https://support.thinkaidium.com/tasks?hsLang=en#cross-team-tasks) - [Transactions](https://support.thinkaidium.com/transactions?hsLang=en#main-content) - [Transactions Page](https://support.thinkaidium.com/transactions?hsLang=en#transactions-page) - [Transaction Slide-out](https://support.thinkaidium.com/transactions?hsLang=en#transaction-slide-out) - [More Functions](https://support.thinkaidium.com/transactions?hsLang=en#more-functions) - [Filters](https://support.thinkaidium.com/transactions?hsLang=en#filters) [![Logo-Green-Positive@4x](https://support.thinkaidium.com/hs-fs/hubfs/Logo-Green-Positive@4x.png?width=172&height=32&name=Logo-Green-Positive@4x.png "Logo-Green-Positive@4x")](https://support.thinkaidium.com/?hsLang=en) 2060 Broadway suite 200, Boulder, CO 80302 [mailto:support@thinkaidium.com](mailto:support@thinkaidium.com) Copyright © 2025, Aidium