---
title: How to import data into quickclaim using MS Excel templates
description: This page describes the template, import steps and potential errors. Importing data into quickclaim using Excel is easy, but requires some MS Excel knowledge.
---
[Skip to content](https://wiki.quickclaim.io/knowledge/how-to-import-data-into-quickclaim-using-ms-excel-templates#main-content)
[More support](https://wiki.quickclaim.io/knowledge/kb-tickets/new?hsLang=en) [Support portal](https://wiki.quickclaim.io/support?hsLang=en)
[.png?width=512&height=100&name=Logo%20(side-by-side).png)](https://quickclaim.com.au/)
- [Existing Tickets](https://wiki.quickclaim.io/tickets-view)
- [Knowledge Base](https://wiki.quickclaim.io/knowledge)
- [PRODA](https://proda.humanservices.gov.au/prodalogin/pages/public/login.jsf)
- [Sign out](https://wiki.quickclaim.io/_hcms/mem/logout)
Open main navigation
Close main navigation
- [Existing Tickets](https://wiki.quickclaim.io/tickets-view)
- [Knowledge Base](https://wiki.quickclaim.io/knowledge)
- [PRODA](https://proda.humanservices.gov.au/prodalogin/pages/public/login.jsf)
- [Sign out](https://wiki.quickclaim.io/_hcms/mem/logout)
- [More support](https://wiki.quickclaim.io/knowledge/kb-tickets/new)
- [Support portal](https://wiki.quickclaim.io/support)
- [Contact us](mailto:support@quickclaim.com.au)
[Contact us](mailto:support@quickclaim.com.au)
How can we help you?
- There are no suggestions because the search field is empty.
1. [Knowledge Base](https://wiki.quickclaim.io/knowledge?hsLang=en)
2. [Getting Started](https://wiki.quickclaim.io/knowledge/getting-started?hsLang=en)
# How to import data into quickclaim using MS Excel templates
## This page explains the template, import steps, and potential errors when importing data into quickclaim using Excel. Importing data is straightforward, but some familiarity with Microsoft Excel is required.
 Instructions
Before proceeding with the import a user should have the data available for importing.
Below is the list of step by step import guide:
1. Log into the **[quickclaim billing app](https://billing.quickclaim.io/signin)**. For existing quickclaim users navigate to [**quickclaim app**](https://app.quickclaim.io/signin).
2. Navigate to the relevant section from the main menu on the left-hand side (e.g., Service Delivery or Participants).
3. Click on the ***“Import Data***” button.
4. In the pop-up window click on “Sample Excel file“
5. The downloaded file is a template that can be used for adding data to and importing it afterwards.
6. Please add your records to this file. You may copy-paste data from your source to this file following the provided data structure.
Do not rename columns! Do not delete columns!
Please note that if you put a symbol '#' into the first column (named DONOTIMPORT) - then the current row of data will not be imported.
Please note the second column (named ACTION) can only have the following values:
I - for inserting new records.
U - for updating existing records.
D - for deleting existing records.
7. Once you have inserted all the records that you would like to import (or update, delete) - proceed to the the uploading your file into the same window as described on the above step 4:
Just drag-and-drop your file into the dedicated area of the window and click “SUBMIT” button.
At this stage, the quickclaim validation system will check your uploaded data for any obvious inconsistencies and error.
8. On the next screen you should see statistics about the data you have uploaded. In case if some records are failing the validation check - the system will highlight it and they will not be imported.
You may choose to edit your file if you wish to fix inconsistencies (if any), or you may proceed with the import of the valid records.
9. Once import is finished - you should see your data immediately in the relevant section of the quickclaim app.
10. There is a "Import History" link on the top right corner of each page where you can view the detils of the import and download the imported files.
- [Getting Started](https://wiki.quickclaim.io/knowledge/getting-started?hsLang=en#main-content)
- [NDIS APIs](https://wiki.quickclaim.io/knowledge/getting-started?hsLang=en#ndis-apis)
- [Aged Care Web Services](https://wiki.quickclaim.io/knowledge/getting-started?hsLang=en#aged-care-web-services)
- [Accounts Receivable (AR) Module](https://wiki.quickclaim.io/knowledge/accounts-receivable-ar-module?hsLang=en)
- [NDIS](https://wiki.quickclaim.io/knowledge/ndis?hsLang=en#main-content)
- [Participants](https://wiki.quickclaim.io/knowledge/ndis?hsLang=en#participants)
- [Service Bookings](https://wiki.quickclaim.io/knowledge/ndis?hsLang=en#service-bookings)
- [Budget](https://wiki.quickclaim.io/knowledge/ndis?hsLang=en#budget)
- [Roster of Care](https://wiki.quickclaim.io/knowledge/ndis?hsLang=en#roster-of-care)
- [Service Delivery](https://wiki.quickclaim.io/knowledge/ndis?hsLang=en#service-delivery)
- [Claiming Workflow](https://wiki.quickclaim.io/knowledge/ndis?hsLang=en#claiming-workflow)
- [Invoicing Workflow](https://wiki.quickclaim.io/knowledge/ndis?hsLang=en#invoicing-workflow)
- [Support at Home](https://wiki.quickclaim.io/knowledge/support-at-home?hsLang=en#main-content)
- [Care Recipients](https://wiki.quickclaim.io/knowledge/support-at-home?hsLang=en#care-recipients)
- [Care Recipient 360](https://wiki.quickclaim.io/knowledge/support-at-home?hsLang=en#care-recipient-360)
- [Budget](https://wiki.quickclaim.io/knowledge/support-at-home?hsLang=en#budget)
- [Transactions](https://wiki.quickclaim.io/knowledge/support-at-home?hsLang=en#transactions)
- [Claims](https://wiki.quickclaim.io/knowledge/support-at-home?hsLang=en#claims)
- [Ready to Invoice](https://wiki.quickclaim.io/knowledge/support-at-home?hsLang=en#ready-to-invoice)
- [Statements](https://wiki.quickclaim.io/knowledge/support-at-home?hsLang=en#statements)
- [Tableau Analytics](https://wiki.quickclaim.io/knowledge/tableau-analytics?hsLang=en)
- [Settings](https://wiki.quickclaim.io/knowledge/settings?hsLang=en#main-content)
- [Registrations](https://wiki.quickclaim.io/knowledge/settings?hsLang=en#registrations)
- [Notifications](https://wiki.quickclaim.io/knowledge/settings?hsLang=en#notifications)
- [Releases](https://wiki.quickclaim.io/knowledge/releases?hsLang=en)
- [For Developers](https://wiki.quickclaim.io/knowledge/for-developers?hsLang=en#main-content)
- [API Getting Started](https://wiki.quickclaim.io/knowledge/for-developers?hsLang=en#api-getting-started)
- [Sandbox and Authentication](https://wiki.quickclaim.io/knowledge/for-developers?hsLang=en#sandbox-and-authentication)
- [Public API Reference](https://wiki.quickclaim.io/knowledge/for-developers?hsLang=en#public-api-reference)
- [Budget APIs](https://wiki.quickclaim.io/knowledge/for-developers?hsLang=en#budget-apis)
- [Errors and Limits](https://wiki.quickclaim.io/knowledge/for-developers?hsLang=en#errors-and-limits)
- [NDIS Rejection Codes](https://wiki.quickclaim.io/knowledge/for-developers?hsLang=en#ndis-rejection-codes)
- [Link](https://wiki.quickclaim.io/knowledge/link?hsLang=en#main-content)
- [Invoices](https://wiki.quickclaim.io/knowledge/link?hsLang=en#invoices)
- [Provider Remittance Advice](https://wiki.quickclaim.io/knowledge/link?hsLang=en#provider-remittance-advice)
- [Settings](https://wiki.quickclaim.io/knowledge/link?hsLang=en#settings)
- [Managing Payments](https://wiki.quickclaim.io/knowledge/link?hsLang=en#managing-payments)
[.png?width=113&height=24&name=quickclaim%20logo%20(high-res).png "Chill listening crop-3")](https://quickclaim.com.au)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, quickclaim