Clio + Microsoft Excel

Create new matters in Clio from new rows in Microsoft Excel

When a new row is added in Microsoft Excel, this workflow creates a corresponding matter in Clio. This automation ensures that your law firm's case management is always updated with new Excel entries. It simplifies your data management, allowing you to focus more on important legal tasks.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this!
Create Matter
Creates a new matter.
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 IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
New Bill
Triggers when a new bill is created.
Trigger
Instant
Try It
New Calendar Entry
Triggers when a new calendar entry is created.
Trigger
Instant
Try It
- Contact Type
Trigger
Instant
Try It
New Matter
Triggers when a new matter is created.
Trigger
Instant
Try It
New Matter Note
Triggers when a new matter note is created.
Trigger
Polling
Try It
Task Status Updated
Triggers when the status of a task has changed.
Trigger
Instant
Try It
- Clio Contact ID #Required
- Company Name
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
Action
Write
- Matter
- Date of Communication
- SubjectRequired
- BodyRequired
- Type of CommunicationRequired
- Type of Recipient
- Type of Sender
Action
Write
- Expense Category
- Description
- DateRequired
- Price
- Matter
- Matter Note
- User
Action
Write
- ClientRequired
- Group
- Client Reference
- Matter DescriptionRequired
- Practice Area
- Originating Attorney ID#
- Responsible Attorney ID#
- Pending Date
- Open Date
- Close Date
- Location
- Status
- Billable
- Status
- Due At
- Destroy?
- Budget
- Include Expenses?
- Notification Threshold
- Notify Users?
Action
Write
- Prefix
- First nameRequired
- Middle name
- Last nameRequired
- Title
- Date of Birth
- Street
- City
- Province
- Postal Code
- Country
- Email Address
- Website
- Phone Number
- Instant Messenger
- Company
Action
Write
- Activity Category
- Description
- DateRequired
- Time
- Price
- Matter
- Matter Note
- User
Action
Write
- MatterRequired
- Client
- Client Reference
- Matter Description
- Practice Area
- Originating Attorney ID#
- Responsible Attorney ID#
- Pending Date
- Open Date
- Close Date
- Location
- Status
- Billable
- Status
- Due At
- Destroy?
- Budget
- Include Expenses?
- Notification Threshold
- Notify Users?
Action
Write
- DocumentRequired
- MatterRequired
Action
Write
- Invoice Number
- Matter Id
- Client Id
Action
Search
Find Contact by Custom Field
Find newest contact by custom field.
Action
Search
- Client EmailRequired
Action
Search
- Search Type
- Search ValueRequired
Action
Search
- Search Type
- Search ValueRequired
- Company NameRequired
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
Action
Search or write
- Search Type
- Search ValueRequired
- Prefix
- First nameRequired
- Middle name
- Last nameRequired
- Title
- Date of Birth
- Street
- City
- Province
- Postal Code
- Country
- Email Address
- Website
- Phone Number
- Instant Messenger
- Company
Action
Search or 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
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
New Activity
Triggers when a new activity is created.
Trigger
Instant
Try It
Bill State Updated
Triggers when the state of a bill has changed.
Trigger
Instant
Try It
New Communication
Triggers when a new communication is created.
Trigger
Instant
Try It
New Document
Triggers when a new document is created.
Trigger
Polling
Try It
- EventRequired
Trigger
Instant
Try It
New Task
Triggers when a new task is created.
Trigger
Instant
Try It
- Matter IDRequired
- Task Template ListRequired
- Notify AssigneesRequired
- Due At
Action
Write
- SummaryRequired
- Description
- Location
- Starts at:Required
- Ends at:Required
- All Day Event
- Send Email Notification
- CalendarRequired
- Contact Attendee
- Matter
Action
Write
- Company NameRequired
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
Action
Write
- NameRequired
- MatterRequired
Action
Write
- Note SubjectRequired
- Note DetailRequired
- MatterRequired
- Date
Action
Write
- NameRequired
- DescriptionRequired
- Type of AssigneeRequired
- Matter
- Task Due Date
- Task Priority
- Task Status
- Notify Assignee
- Notify Completion
- Statute of Limitations
Action
Write
- Clio Contact ID #Required
- Prefix
- First name
- Middle name
- Last name
- Title
- Date of Birth
- Email Address
- Street
- City
- Province
- Postal Code
- Country
- Website
- Phone Number
- Instant Messenger
- Company
Action
Write
- Task IDRequired
- Name
- Description
- Type of AssigneeRequired
- Matter
- Task Due Date
- Task Priority
- Task Status
- Notify Completion
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Search Type
- Search ValueRequired
Action
Search
- Search Type
- Search ValueRequired
Action
Search
Find Matter by Custom Field
Find newest matter by custom field.
Action
Search
- Search ValueRequired
Action
Search
- Search Type
- Search ValueRequired
- ClientRequired
- Group
- Client Reference
- Matter DescriptionRequired
- Practice Area
- Originating Attorney ID#
- Responsible Attorney ID#
- Pending Date
- Open Date
- Close Date
- Location
- Status
- Billable
- Status
- Due At
- Destroy?
- Budget
- Include Expenses?
- Notification Threshold
- Notify Users?
Action
Search or write

About Clio

Clio is a practice management platform that helps lawyers work more efficiently by making it easy to do tasks like tracking time, managing matters, and generating invoices.

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

Related categories

Similar apps

Related Zap Templates

Add new Clio calendar entries to Microsoft Excel as rows for seamless record-keeping

Create tasks in Clio from new rows in your Microsoft Excel table

Clio + Microsoft Excel

Create new matters in Clio from new rows in Microsoft Excel

New Row

New Worksheet

Add Row

Add Row to Table

Clear Column by Index

Create Workbook

Delete Worksheet

Update Row

Find Row

Get Cells in Range

Get Worksheet by ID

Find or Create Worksheet

New Bill

New Calendar Entry

New Contact

New Matter

New Matter Note

Task Status Updated

Update Company Contact

Create Communication

Create Expense Entry (Activity)

Create Matter

Create Person Contact

Create Time Entry (Activity)

Update Matter

Upload Document to Matter

Find Bill

Find Contact by Custom Field

Find Newest Matter by Client Email

Find Person Contact

Find or Create Company Contact

Find or Create Person Contact

New Row in Table

Updated Row

Add Row(s)

Clear Cells by Range

Clear Row by ID

Create Worksheet

Rename Worksheet

API Request (Beta)

Find Worksheet(s)

Get Row by ID

Find or Create Row

New Activity

Bill State Updated

New Communication

New Document

Matter Status Updated

New Task

Assign Task Template List

Create Calendar Entry

Create Company Contact

Create Matter Folder

Create Matter Note

Create Task

Update Person Contact

Update Task

API Request (Beta)

Find Company Contact

Find Matter

Find Matter by Custom Field

Find User

Find or Create a Matter

About Clio

Related categories

Similar apps

Zapier Interfaces

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip

Related Zap Templates

Related Zap Templates