Morningstar AdviserLogic + Microsoft Excel

Create or update Morningstar AdviserLogic entities when new rows are added in Microsoft Excel

Streamline your data management process between Microsoft Excel and Morningstar AdviserLogic with this efficient workflow. Whenever a new row is created in your Excel document, it immediately results in creating or updating an entity in Morningstar AdviserLogic. This integration eliminates manual data entry, enhancing productivity, reducing errors, and ensuring your financial records in AdviserLogic are always up-to-date.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this!
Create or Update Entity
Updates the existing entity, otherwise creates a new entity.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

New or Updated Client
Triggers when a client is created or updated.
Trigger
Polling
Try It
- External ID
- Subject
- Description
- StartDate
- EndDate
- Attendees
- Location
- Invitee Response
- Invitee Type
- Event Importance
- Event Visibility
- Event Status
- Event Organizer
- IsAllday
- Recurrence-DaysOfWeek
- Recurrence-FirstDayOfWeek
- Recurrence-Interval
- Recurrence-Type
- Recurrence-DayOfMonth
- Recurrence-Index
- Recurrence-Month
- Recurrence-NumberOfOccurences
- Recurrence-TimeZone
- Recurrence-StartDate
- Recurrence-EndDate
- Recurrence-RangeType
Action
Write
- First NameRequired
- Last NameRequired
- Date of BirthRequired
- GenderRequired
- External IDRequired
- Client ID
- Full Name
- Occupation
- Client Start Date
- Job Title
- Notes
- Phone (Home)
- Phone (Mobile)
- Phone (Work)
- Fax
- Email (Home)
- Email (Work)
- Address (Line 1)
- Address (Line 2)
- Address (Suburb)
- Address (PostCode)
- Address (Country)
- Address (State)
- Facebook
- Skype
- LinkedIn
- Twitter
- Source
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
New Diary Event
Triggers when a new event is added to your diary. Only triggers for events in the next 2 months.
Trigger
Polling
Try It
- External ID
- Subject
- Description
- StartDate
- EndDate
- Attendees
- Location
- Invitee Response
- Invitee Type
- Event Visibility
- Event Status
- Event Organizer
Action
Write
- External IDRequired
- Entity IDRequired
- SourceRequired
- Record ID
- Parent ID
- Company Name
- TFN
- Acn
- Abn
- Notes
- Corporate Trustee
- Entity TypeRequired
- Member ID
- Trustee Name
- Trustee
- Director
- Share Percentage
Action
Write

About Morningstar AdviserLogic

Morningstar AdviserLogic is a financial planning and business management solution that positions advisers to engage and impress clients while efficiently running their business and helping them meet compliance obligations.

Learn more

Related categories

CRM (Customer Relationship Management)

Similar apps

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more

Morningstar AdviserLogic + Microsoft Excel

Create or update Morningstar AdviserLogic entities when new rows are added in Microsoft Excel

Supported triggers and actions

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

Find or Create Row

New or Updated Client

Add/Update AdviserLogic Diary Event From Microsoft Outlook Ca...

Create or Update Client

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet

Find or Create Worksheet

New Diary Event

Add/Update AdviserLogic Diary Event From Microsoft Google Cal...

Create or Update Entity

About Morningstar AdviserLogic

Related categories

Similar apps

Zapier Interfaces

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip