Import Customer Data into QuickBooks (Online & Desktop) Using Excel or CSV
Import Customer
Follow the steps below to Populate Customers in QuickBooks Online or Desktop via Excel/CSV in zaptiva.
- Navigate to the URL: https://app.zaptiva.com/
- Log in to your Zaptiva account.
3. From the left-hand menu, click on Flow to navigate to the Flow list page.
4. On the Flow list page, click the Create Flow button to navigate to the Flow screen.
5. On the Create Flow page, rename the flow by clicking the pencil icon and confirm by clicking the check (✔) icon.
6. To create a flow, click the ‘+’ icon on the Start component. An Apps sidebar will appear, where you can select either CSV or Microsoft Excel as the input file, depending on your file type.
7. From the Operator sidebar, choose Read Excel (for Excel files) or Read CSV (for CSV files).
8. After selecting the component type from the Operator sidebar, the chosen component will be linked to the Start component.
9. Click the Read Excel/Read CSV component to open the Mapping sidebar and upload your input file. For Excel, select the required sheet; for CSV, you can also choose the CSV Text option.
10. After uploading, review your file headers under Headers, click Preview to check the file contents, and then click Save to save the component mapping.
11. To add another component, click the ‘+’ icon on the Read Excel/Read CSV component and select QuickBooks Online or QuickBooks Desktop from the Apps sidebar, depending on where you want to populate customers.
12. After selecting the app, choose Create Customers from the Operator sidebar. The Create Customer component will then connect to the Read Excel/Read CSV component.
13. Click the Create Customer component to open its mapping sidebar and select the correct connection (QuickBooks Online or QuickBooks Desktop account).
14. To map data, click the respective field in the component sidebar. A response popup will appear displaying the parent component’s data then select the appropriate field from the parent component to complete the mapping.
15. Map other mandatory fields as required in the same way and click Save to save the component mapping.
16. Next, On the top-right, click the Save icon to save the flow.
17. Then, click Run Once, followed by Preview and Run.
18. Next, review the preview of mapped data and click Run.
19. After clicking the Run button, the flow will start in QuickBooks Online. In the case of QuickBooks Desktop, you need to enable the Web Connector. During execution, you can monitor the dynamic status in the History sidebar, which shows progress component by component.
20. After completion, a History icon will appear on each executed component.
21. Finally, click the History icon of any component to view detailed input and output data in the History popup, with options to filter by success or failure.
Related Articles
Creating a connection to QuickBooks Desktop
To complete the connection from Zaptiva to QuickBooks using the QuickBooks Web Connector (QWC), please follow the steps below. 1. Connect 2. Install 1. Connect Click on “Connection” option in the left pane. Click on ‘Add Connection’ to open a prompt ...Creating a connection to QuickBooks Online
To complete the connection from Zaptiva to QuickBooks Online, please follow the steps below. Connect Click on “Connection” option in the left pane. Click on “Add Connection” which will prompt you for connection name. Let’s enter the name of the ...Zaptiva Release Notes
v2.12.1 Beta Release Date: Jan 28, 2026 MAJOR FEATURE: Enhancement to Aggregator component to handle Arrays type. Support for "Project" entity using GraphQL in QuickBooks Online Capability to add "description" on individual component- Backend. ...Deleting a connection to QuickBooks Online/QuickBooks Desktop
Delete connection to QuickBooks Online/Desktop Follow the steps below to delete an existing QuickBooks Online connection in Zaptiva: Navigate to the URL: https://app.zaptiva.com/ Log in to your Zaptiva account. Navigate to "Connections" from the ...Creating and Using a Quickbase Service Account for Pipelines
Creating and Using a Quickbase Service Account for Pipelines Purpose This article defines the recommended and supported process for creating and using a Quickbase Service Account in a customer’s Quickbase realm when implementing Pipelines. The ...