What are the common CSV import issues? | HR Platform

CSV uploads are a powerful feature for quickly and easily importing data into your platform. However, there are some common errors that can arise when uploading a CSV. Here are a few examples and what they mean. 

Common CSV import errors

General issues
Adding spaces. Any cell that starts or ends with a space will cause an error in the upload.
Format errors.

When copying from Excel to CSV, the format changes. This also changes the data, most often with numbers that have leading zeros, such as BSBs and phone numbers.

You will need to reformat the column to a custom format that includes the zero.

Adding hyphens.

TFNs and BSBs are the most common to have added hyphens. There should not be hyphens in these sections.

Data missing from columns linked to other columns.

When inputting data into certain columns, you will need to fill out others. Examples are the super columns, banking columns, and tax columns.

If you do not have all the data, it is better to delete all these related columns before upload. You can come back instead when you have the data.

Deleting a column header.

Check that all headers are present and that there are not any data in a cell with no header.

Uploading the advanced spreadsheet when Payroll settings are turned off. The platform will not allow this action. You would need to delete all columns that disappeared along with payroll settings, and then upload.
A - F
ABN Incorrect number of digits.
Account BSB Columns
  • Hyphens being included.
  • Not 6 digits.
  • Including alpha characters.
  • Space between digits 3 and 4.
Account email Account emails can only be changed within the person’s profile, not via CSV. If you change someone’s account email in the CSV, you will create a new employee.
Account Number Columns
  • Spaces in the numbers.
  • Hyphens in the numbers.
  • Including alpha characters.
Additional Cost Centres
  • Adding ‌a cost centre before updating from Payroll. If it has been added to the Payroll platform and not re-synced to HR, HR will think it does not exist.
  • Not utilising the "|" symbol to separate multiple additional cost centres.
Allocated Percentage Columns Empty for those with multiple accounts.
Anniversary date [dd/mm/yyyy] Not in dd/mm/yyyy format.
Classification
  • Misspelling.
  • Inputting a combination that does not exist.
Company Landline
  • Leading zero being dropped.
  • Spaces being added.
Company Mobile
  • Leading zero being dropped.
  • Spaces being added.
Contract type [Permanent | Fixed term]
  • Misspelling.
  • Inputting a type that is not listed.
  • Leaving blank for Full-time or Part-time employment types.
Date of birth Not in dd/mm/yyyy format.
Employing Entity Misspelling.
Employment type [Full-time | Part-time | Casual]
  • Misspelling.
  • Inputting a type that is not listed.
End Date

Not in dd/mm/yyyy format.

ESA Details missing from one column that is related to the others.
Fixed Amount Columns Leaving empty.
G - L
Gender [Female | Male | Non-binary | Prefer not to say]
  • Misspelling.
  • Inputting a type that is not listed.
Home Phone
  • Leading zero being dropped.
  • Spaces being added.
Industrial Instrument
  • Misspelling.
  • Inputting a combination that does not exist.
Job Title Leaving empty.
M - R
Marital status [Single | Married | In a Relationship]
  • Misspelling.
  • Inputting a type that is not listed.
Nationality
  • Listing a nationality that is not listed.
  • Misspelling.
Pay category
  • Misspelling.
  • Inputting an option that does not exist in your platform.
Pay details - Effective from [dd/mm/yyyy]
  • Not in dd/mm/yyyy format.
  • Not updating this field when you are attempting to create a new salary line.
Pay Rate Template
  • Misspelling.
  • Inputting a combination that does not exist.
Pay schedule
  • Misspelling.
  • Inputting an option that does not exist in your platform.
Personal Mobile Number
  • Leading zero being dropped.
  • Spaces being added.
Primary Cost Centre
  • Adding ‌a cost centre before updating from Payroll. If it has been added to the Payroll platform and not re-synced to HR, HR will think it does not exist.
  • Not utilising the "|" symbol to separate multiple additional cost centres.
Primary Manager Email
  • Putting an email that is not the account email for the manager.
  • Putting the manager’s name instead of an email.
S - Z
Salary option [Annum | Month | Fortnight | Hour]
  • Misspelling.
  • Inputting a type that is not listed.
Secondary Manager Email
  • Putting an email that is not the account email for the manager.
  • Putting the manager’s name instead of an email.
SMSF Account Name Details missing from one column that is related to the others.
SMSF Account Number Details missing from one column that is related to the others.
SMSF BSB Details missing from one column that is related to the others.
SPIN/USI Pasted in incorrectly, causing error in cell.
Start Date

Not in dd/mm/yyyy format.

Super Account Name Details missing from one column that is related to the others.
Super Choice [Regulated | SMSF | Company nominated]
  • Misspelling.
  • Inputting an option that does not exist in your platform.
Super Fund ABN
  • Not enough digits.
  • Spaces being added.
Super Member Number Details missing from one column that is related to the others.
Tax File Number
  • Inputting asterisks instead of numbers (most common with Xero and MYOB clients).
  • Hyphens listed.
  • Spaces being added.
  • Less than 9 digits.
Team [separate multiple teams with '|'] Not utilising the "|" symbol to separate multiple teams.
Termination Date
  • Not in dd/mm/yyyy format.
  • Missing when termination type is populated.
Timesheets [Enabled | Disabled | EnabledForExceptions]
  • Misspelling.
  • Inputting a type that is not listed.
Title [Mr | Ms | Mrs | Miss | Dr | Mx]
  • Misspelling.
  • Adding a full stop at the end.
  • Inputting a type that is not listed.
Type [Employee | Contractor]
  • Misspelling.
  • Inputting a type that is not listed.

Related Articles

You have now read the most common CSV import errors and are wondering what you can do next. There are two content recommendations I would make, and they are:

Was this article helpful?
0 out of 1 found this helpful

Comments

0 comments

Article is closed for comments.