Skip to main content

Help! Microsoft Excel is eating up my CSV file leading 0's

Making sure your Employee ID 0's in front are not missing when you upload csv into StaffAny

Ops Support avatar
Written by Ops Support
Updated over 3 years ago

Do you have an issue when you upload a csv file into StaffAny, Microsoft Excel removes the front 0s of Employee IDs?

We have a quick 1-minute solution, please see below for the guide!

Problem

  • Staff has an Employee ID '007'.

  • After you edit and upload a My Team mass edit csv, his employee ID becomes just '7'.

After download and edit My Team CSV, it changes to '7'

Solution

There is a quick solution that involves editing the csv data on Google Sheets.

Step 1: Create a new Google Sheets

Step 2: Upload the csv file by clicking on File > Import > Upload > choose the newly downloaded StaffAny csv file

Step 3: Uncheck 'Convert text to numbers, dates and formulas. *this is important*

Step 4: Edit the google sheets accordingly.

Step 5: Download the file by going to File > Download > CSV

Full Video Walkthrough

Here's a video walkthrough of the whole process!

Did this answer your question?