Workia makes it easy to import your data! Say goodbye to tedious copy and pasting and manual typing. 👋
You can directly import the bulk of your records on spreadsheets.
Where do I import my data?
There are two ways to access imports! Click on your Profile icon on the top right corner to open the drop-down menu, hover over "Settings" and click on the Imports setting to open the Imports screen.
You can also initiate an import on the People screen. You can find it just on the upper right side of the screen by clicking on the "Actions" button. Click on "Import Data" and a modal will open.
Setting up the import
An import file should be set up with column headers or associated fields, followed by the data in each row.
⚠️ Please ensure that the spreadsheet headers have no duplicates or else the import will not go through.
Importing case or employee data
To begin the import, click on the "Import Data" icon. In the modal, you can select an option(s) to choose which data will be imported into Workia.
Once you have selected the data types, select "Next", and then you will be directed to upload your spreadsheet.
⚠️ If your import data has multiple spreadsheets, you will be prompted to select a sheet from the file.
Once you upload your import file, you'll need to map your spreadsheet columns to the corresponding fields in Workia. Workia will try to map as much as it can as a starting point.
Add or remove data types
If you want to include additional data types in your import, simply click on the "+ Add" button on the left side of the modal, and a dropdown will appear in which you can select the additional data types for your import.
If you need to remove a data type, just click on the "X" icon beside the data type, this will clear it from the list and will be excluded from the overall import.
Import Options
On supported data types, you can select one of the options below to control how your records are imported
Only import new records: This will only add new records and will not affect any existing records.
Update existing records: This will only update records that already exist in Workia based on a matching case identifier.
Create and update records: This option will add new records and update existing ones simultaneously.
Mapping fields
Workia automatically maps your spreadsheet headers to corresponding fields, especially when the headers match or closely resemble the context of each column.
When selecting a field to import while mapping, Workia will display a preview of your data from your spreadsheet. Select the column or headers from your spreadsheet and match to the Workia fields.
📘 Help tips and warnings are provided to help you match your data correctly.
Once you are done selecting the data types and mapping, click on the "Import" button and your import will be processed.
Imports normally take a matter of seconds, so you can also refresh the people screen to see results.
To view the status of your import in more detail, click on "View Import" and it will redirect you to the Imports screen under Settings. You will find the status of your import and any errors that may have occurred while making the import.
💡Note: After the import is finished, users can also download rows with errors and warnings separate from the successful imports in one file.