---
title: "Excel import task to enhance automation"
canonical_url: "https://www.nutrient.io/guides/workflow-automation/faq/using-excel-to-enhance-your-automation/"
md_url: "https://www.nutrient.io/guides/workflow-automation/faq/using-excel-to-enhance-your-automation.md"
last_updated: "2026-06-09T10:25:14.576Z"
description: "Discover how to streamline workflows using Excel with Nutrient Workflow. Enhance efficiency and automate processes effortlessly."
---

# Optimize your workflows with Excel integration

In today's rapidly evolving business landscape, optimizing workflows and streamlining processes is critical, and harnessing the power of Excel in conjunction with a versatile platform like Nutrient Workflow can be a game-changer. As your organization seeks efficient solutions to enhance your operational efficiency, the seamless integration between Nutrient Workflow and Excel emerges as an indispensable tool to leverage your existing processes for capturing and sharing data within the organization and further automate through Nutrient Workflow.

## Excel import

Often, organizations will have procedures in place that result in a spreadsheet of data being passed around between different team members, updated, and emailed from person to person with no actual paper trail or tracking into the status of any one item. Instead of reinventing the wheel and building the process from scratch, Nutrient Workflow allows you to create a process in which you import that existing spreadsheet, map the cells to data fields on a web form, and then continue to further optimize and automate using Nutrient Workflow's powerful workflow development toolkit. This allows for a streamlined end-user experience and auditing and tracking of processes within your organization, meaning nothing ever gets lost in someone's inbox again.

**To configure the Excel Import task, there are a few simple steps to follow:**

1. Identify the format of the Excel spreadsheet you are looking to configure for import in your process (in our example, we have a parts inspection spreadsheet).![](@/assets/guides/workflow-automation/files/1769/step_1.580x0-is.png)

2. Design a simple form through the Nutrient Workflow platform that contains fields for each data element you want to capture from the spreadsheet.

3. In the Process Designer (Administration -> Processes), drag in an Excel Import task from the list of task types.![](@/assets/guides/workflow-automation/files/1769/step_3.580x0-is.png)

4. Configure the Excel Import task by providing the following:

   a. A template of what the imported spreadsheet will look like (you can use the example spreadsheet you used to develop your form!)\
   b. Mappings between the fields on your form and the cells in the spreadsheet![](@/assets/guides/workflow-automation/files/1769/step_4.580x0-is.png)

5. Hit "Save” and you're done!

In minutes, you can create a process that takes data from spreadsheets you're already using, move the data into our online platform, and use this data to drive workflow decisions.

## Excel batch

Many standard procedures within organizations end up involving tedious clerical work to enter and capture many records in a system. For example, your team may process new customers or leads in a CRM database and need to track the same essential information for each record, or you might have an employee onboarding process where dozens of users are coming in, and each needs to follow the same steps to get set up in your system. Instead of having to initiate a new process manually for each instance, there's a powerful workflow task that allows you to submit a single Excel sheet with the relevant data for each record. Nutrient Workflow will seamlessly capture each row of data as a new request in the system, eliminating any unnecessary keying in of data and clerical errors.

**To get started with the Excel Batch task, there's a few easy steps to set things up:**

1. Identify the Nutrient Workflow process that you want to automate with the Excel Batch and be sure this process has a form task as an initial step in the workflow chart.![](@/assets/guides/workflow-automation/files/1769/excel_batch_1.680x0-is.png)

2. You will also need to have an Excel sheet format ready to go, with each column representing a field on your Nutrient Workflow form and each row representing one instance of the process you are kicking off (in our example, we are initiating an employee onboarding process).![](@/assets/guides/workflow-automation/files/1769/excel_batch_2.png)

3. In the Processes administration menu (Administration -> Processes), add a new process that we will use to upload the Excel document for processing. Give it whatever name is relevant to your team/process.![](@/assets/guides/workflow-automation/files/1769/excel_batch_3.680x0-is.png)

4. In the workflow designer, drag in an Excel Batch task and connect it to both the Start and End tasks.![](@/assets/guides/workflow-automation/files/1769/excel_batch_4.502x0-is.png)

5. In the task configuration for the Excel Batch task (right-click on task -> Configuration -> Configure Task), provide the following information:

   a. Upload a sample spreadsheet of data with the format of the rows and columns you use to import records (e.g., the spreadsheet from step 2).\
   b. Select the process being launched and the form on that process that is going to capture the data coming in from the Excel Batch task.\
   c. Provide a request name to be assigned when the task is launched.\
   d. Map the requester and client of the child requests as needed.\
   e. If the spreadsheet you are using has headers, be sure to select the “Skip first row of spreadsheet” checkbox.![](@/assets/guides/workflow-automation/files/1769/excel_batch_5.580x0-is.png)

6. Hit “Save” on the dialog and go to the Mappings tab. A list of the fields from the form you selected in the Settings tab should be displayed.![](@/assets/guides/workflow-automation/files/1769/excel_batch_6.580x0-is.png)

7. For each field you have data to capture, click the pencil icon and select the sheet and column that contains the data being pushed into the selected field![](@/assets/guides/workflow-automation/files/1769/excel_batch_7.580x0-is.png)

8. Be sure  to assign the Excel Batch task to a user responsible for uploading the spreadsheet into Nutrient Workflow (typically, this task is assigned to the requester of the process, but can be set to whoever is necessary for your team)![](@/assets/guides/workflow-automation/files/1769/excel_batch_8.580x0-is.png)

9. On the child process, go to the form task configuration of the form that you configured to receive data, and be sure to set the task to auto-complete when the process is launched as a child request.![](@/assets/guides/workflow-automation/files/1769/excel_batch_9.580x0-is.png)

You are now set up to begin processing batches of records in Nutrient Workflow! Any time you have a set of records that needs to be linked to individual processes in the system, all you have to do is kick off the Excel Batch process you created, upload a document with rows of data, and in seconds, your processes will be initiated and running!

## Final thoughts

Your organization is likely already leveraging the power of Microsoft Excel to capture business data and drive everyday decision-making. Instead of making users have to start from scratch and learn a new tool all over again to make these decisions, Nutrient Workflow gives your organization the power to integrate seamlessly with Excel to automate and streamline your workflows. With the Excel Import and Excel Batch task types, you can make a huge impact in enhancing efficiency, reducing errors, and promoting collaboration across your organization.

---

> Part of [Frequently asked questions](/guides/workflow-automation/faq.md)

## Related pages

- [Connect Nutrient Workflow to an external SQL Server database](/guides/workflow-automation/faq/adding-sql-server-db-to-nutrient-workflow.md)
- [Add tables to email notifications easily](/guides/workflow-automation/faq/adding-tables-to-email-notifications.md)
- [Streamline task management with the Form Assigner](/guides/workflow-automation/faq/assign-future-tasks-with-the-form-assigner.md)
- [Changing milestone task names in project management](/guides/workflow-automation/faq/can-i-change-the-name-of-a-milestone-task-on-a-process-in-production.md)
- [Customize your login screen with these easy tips](/guides/workflow-automation/faq/can-i-change-the-login-screen.md)
- [Migrating requests in workflow automation processes](/guides/workflow-automation/faq/can-i-migrate-a-group-of-requests-from-one-version-of-a-process-to-an-updated-version.md)
- [Preventing request ID creation until task completion](/guides/workflow-automation/faq/can-we-prevent-a-new-request-id-from-being-created-until-a-task-completed.md)
- [Authenticate HTML forms with SAML securely](/guides/workflow-automation/faq/can-we-authenticate-with-saml-when-hosting-html-forms-outside-the-nutrient-workflow-portal.md)
- [Streamline file uploads to SharePoint with Nutrient Workflow](/guides/workflow-automation/faq/can-nutrient-workflow-pass-files-into-sharepoint.md)
- [Mastering the coalesce technique for workflows](/guides/workflow-automation/faq/coalescing-data-ai-an-advanced-nutrient-workflow-technique.md)
- [Streamline onboarding with ad-hoc related requests](/guides/workflow-automation/faq/creating-ad-hoc-related-requests.md)
- [Master table maintenance with Nutrient Workflow processes](/guides/workflow-automation/faq/creating-a-table-maintenance-process.md)
- [Customize your Nutrient Workflow logo with ease](/guides/workflow-automation/faq/custom-logo.md)
- [Do disabled users receive notifications in Nutrient Workflow?](/guides/workflow-automation/faq/do-notifications-get-sent-out-to-users-that-have-been-disabled.md)
- [Document generation vs. PDF generator in workflow automation](/guides/workflow-automation/faq/document-generation-vs-pdf-generator.md)
- [Maximize task management with Nutrient Workflow's solutions](/guides/workflow-automation/faq/does-nutrient-workflow-support-leap-year-dates.md)
- [Understanding task resets and user reassignments](/guides/workflow-automation/faq/does-the-user_recent_activity-store-data-when-a-user-resets-or-re-assign-a-task.md)
- [Embed Outlook and Google calendars in your dashboard](/guides/workflow-automation/faq/embedding-calendars-in-dashboards.md)
- [Efficiently extract grid data for custom tables](/guides/workflow-automation/faq/how-can-i-extract-grid-data-to-add-it-to-custom-tables.md)
- [Enhance Nutrient Workflow security with two-factor authentication](/guides/workflow-automation/faq/does-nutrient-workflow-support-two-factor-authentication.md)
- [Paste spreadsheet rows into a grid](/guides/workflow-automation/faq/how-can-i-paste-spreadsheet-rows-into-line-items.md)
- [Access your private database server easily](/guides/workflow-automation/faq/how-do-i-access-my-private-database-server.md)
- [Enable AUTH for secure Nutrient Workflow and Redis setup](/guides/workflow-automation/faq/how-do-i-enable-auth-for-nutrient-workflow-to-redis-communication.md)
- [Submit a help ticket at the Nutrient Workflow support site](/guides/workflow-automation/faq/how-do-i-submit-a-support-ticket.md)
- [Force users to change passwords on next login](/guides/workflow-automation/faq/how-do-i-force-a-user-to-change-their-password-on-the-next-login.md)
- [Easily prefill contact search fields in forms](/guides/workflow-automation/faq/how-do-i-prefill-in-a-contact-search.md)
- [Schedule a process](/guides/workflow-automation/faq/how-do-i-schedule-a-process.md)
- [Make your process lines straight with grid option](/guides/workflow-automation/faq/how-do-i-make-the-lines-in-a-process-straight.md)
- [Enhance local communication in your application](/guides/workflow-automation/faq/how-do-i-force-local-communication-within-the-application.md)
- [How to limit file attachment size in Nutrient Workflow](/guides/workflow-automation/faq/how-do-i-limit-the-allowed-max-file-attachment-size.md)
- [Editing request details in active workflows](/guides/workflow-automation/faq/how-do-you-edit-request-description-and-other-fields-after-the-workflow-has-started.md)
- [Clear browser cache for smooth workflow](/guides/workflow-automation/faq/how-to-clear-your-browser-cache.md)
- [Import active directory users with ADSync easily](/guides/workflow-automation/faq/how-do-i-import-active-directory-users-into-nutrient-workflow-using-adsync.md)
- [Master dynamic task and request naming effectively](/guides/workflow-automation/faq/how-to-configure-dynamic-task-and-request-names.md)
- [Edit request names seamlessly with dynamic names](/guides/workflow-automation/faq/is-there-a-way-to-edit-the-name-of-a-request-after-it-has-been-submitted.md)
- [Understanding user concurrency in Nutrient Workflow](/guides/workflow-automation/faq/how-is-user-concurrency-determined-for-my-installation.md)
- [How to reset your Nutrient Workflow password easily](/guides/workflow-automation/faq/i-forgot-my-password.md)
- [Automate your report from a set starting date](/guides/workflow-automation/faq/i-would-like-to-set-a-report-to-run-from-a-set-date-say-1-1-15-through-the-current-day-today-how-can-i-set-my-report-to-do.md)
- [Understanding time_out configuration in workflow automation](/guides/workflow-automation/faq/is-there-any-negative-impact-if-we-change-the-time_out-configuration-on-a-task-in-a-process-in-status-production.md)
- [Understanding account lockout rules in Nutrient Workflow](/guides/workflow-automation/faq/is-there-any-way-to-configure-account-lockout-rules.md)
- [Understanding the Nutrient Workflow and PSPDFKit acquisition](/guides/workflow-automation/faq/pspdfkit-acquisition.md)
- [Streamline task assignments with Assigner tasks](/guides/workflow-automation/faq/using-assigner-tasks.md)
- [Understanding requesters vs. recipients in workflows](/guides/workflow-automation/faq/the-difference-between-a-requester-and-a-recipient.md)
- [Upgrade your select list fields for better forms](/guides/workflow-automation/faq/upgrading-select-list-fields.md)
- [Best practices for testing workflows in Nutrient Workflow](/guides/workflow-automation/faq/what-are-best-practices-for-testing-in-nutrient-workflow.md)
- [Optimize your workflow with Microsoft Nutrient Workflow integration](/guides/workflow-automation/faq/nutrient-workflow-integrate-microsoft-products.md)
- [Key steps for successful Nutrient Workflow load balancing](/guides/workflow-automation/faq/what-do-i-need-to-change-when-i-load-balance-nutrient-workflow.md)
- [Enhance your subscription with admin coaching support](/guides/workflow-automation/faq/what-is-admin-coaching.md)
- [Understanding character limits for form inputs](/guides/workflow-automation/faq/what-character-limits-apply-to-the-form-input-fields.md)
- [Discover Nutrient Workflow's browser compatibility](/guides/workflow-automation/faq/what-browsers-does-nutrient-workflow-support.md)
- [What Does 'Create a Copy of this Request' Do?](/guides/workflow-automation/faq/what-does-aucreate-a-copy-of-this-request-au-do.md)
- [What is 'Submit on Behalf of:' when starting a new request?](/guides/workflow-automation/faq/what-is-submit-on-behalf-of-when-starting-a-new-request.md)
- [Best practices for archiving request data](/guides/workflow-automation/faq/what-is-the-best-practice-for-archiving-request-data-eg-attachments.md)
- [Fixing missing fields in form data settings](/guides/workflow-automation/faq/why-are-fields-from-my-form-not-showing-up-in-data-configurations.md)
- [Expert advanced technical support for Nutrient Workflow](/guides/workflow-automation/faq/what-is-advanced-technical-support-ats.md)
- [Future logging features for workflow automation](/guides/workflow-automation/faq/when-a-nutrient-workflow-administrator-performs-a-task-resets-or-redo-completion-is-there-a-logging-table-where-this-information-is-st.md)
- [Understanding the iapprove master root account](/guides/workflow-automation/faq/what-is-the-iapprove-account.md)
- [Streamline workflows with the PDF Generator Task](/guides/workflow-automation/faq/what-is-the-pdf-generator-task.md)
- [What is the difference between Monitor and Manage Requests?](/guides/workflow-automation/faq/what-is-the-difference-between-monitor-and-manage-requests.md)
- [Understanding Nutrient Workflow log files for troubleshooting](/guides/workflow-automation/faq/where-are-the-logs-for-my-onpremise-installation-what-do-they-contain-and-what-should-i-look-out-for.md)
- [Essential guide to workflow versioning](/guides/workflow-automation/faq/when-to-version-a-production-workflow.md)