---
title: "Bulk Upload: Resolving Date Format Issues"
---

[Skip to content](https://guide.sprout.ph/bulk-upload-resolving-date-format-issues#main-content)

[![Sprout Logo-3](https://guide.sprout.ph/hs-fs/hubfs/Sprout%20Logo-3.png?width=200&height=78&name=Sprout%20Logo-3.png)](https://guide.sprout.ph/?hsLang=en)

Open main navigation

Close main navigation

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Sprout](https://guide.sprout.ph/?hsLang=en)
2. [Sprout HR](https://guide.sprout.ph/sprout-hr?hsLang=en)
3. [Bulk Uploads](https://guide.sprout.ph/sprout-hr?hsLang=en#bulk-uploads)

# Bulk Upload: Resolving Date Format Issues

### **Overview**

When using Bulk Upload templates, the date format in the file may be affected by your Computer/ Laptop's regional settings. Although the template is designed to use the **MM/DD/YYYY** format, spreadsheet applications such as Excel may automatically display or convert dates based on your device's configured date format. 

---

### Why This Happens?

The Bulk Upload Template follows the standard date format:  
**MM/DD/YYYY**

However, if your computer/ laptop's  regional settings use a different format, such as:  
**DD/MM/YYYY**

 

Excel may automatically interpret or display dates according to your local settings. This can result in dates appearing differently in the template and may cause incorrect values to be uploaded. 

---

### **How to Prevent Date Format Issues **

To avoid discrepancies in date formatting during bulk uploads, you may follow either of the options below:

#### **Option 1: Adjust the Bulk Upload Template**

Manually update the date entries in your bulk upload file to match your computer’s current date format.

#### **Option 2: Update Your Device Date Format**

Change your computer or laptop’s regional date settings to: **MM/DD/YYYY**

This ensures consistency between your system settings and the required bulk upload format.

---

### Correcting Uploaded Dates 

If incorrect date formats have already been uploaded, you can correct them using either of the following:

- Update the employee records directly via the **Employee Profile**
- Re-upload corrected data using the **Bulk Upload Template**

---

### **Additional Information**

For a more detailed guide on bulk uploading employee information, you may refer to:  
[**A Comprehensive Guide on the Bulk Upload (Employee Information)**](https://guide.sprout.ph/a-comprehensive-guide-on-the-bulk-upload-employee-information?hsLang=en)

---

### **Summary**

Date format issues in bulk uploads are typically caused by mismatched system regional settings. Ensuring alignment between your device settings and the required **MM/DD/YYYY** format will help prevent upload errors and data inconsistencies.

*Want real-time responses? Explore* [*Sidekick*](https://sidekick.sprout.ph/)*, your 24/7 guide for product inquiries!*  

- [News & Updates](https://guide.sprout.ph/news-updates?hsLang=en#main-content)
  
  
  
  
  
    - [BIR](https://guide.sprout.ph/news-updates?hsLang=en#bir)
    - [DOLE](https://guide.sprout.ph/news-updates?hsLang=en#dole)
    - [FAQs](https://guide.sprout.ph/news-updates?hsLang=en#faqs)
- [Sprout Payroll Infographics](https://guide.sprout.ph/sprout-payroll-infographics?hsLang=en#main-content)
  
  
  
  
  
    - [Infographics](https://guide.sprout.ph/sprout-payroll-infographics?hsLang=en#infographics)
- [Sprout Keeper](https://guide.sprout.ph/sprout-keeper?hsLang=en#main-content)
  
  
  
  
  
    - [FAQs](https://guide.sprout.ph/sprout-keeper?hsLang=en#faqs)
- [Sprout Benefits](https://guide.sprout.ph/sprout-benefits?hsLang=en#main-content)
  
  
  
  
  
    - [Sprout Pulse](https://guide.sprout.ph/sprout-benefits?hsLang=en#sprout-pulse)
    - [Sprout Wellness](https://guide.sprout.ph/sprout-benefits?hsLang=en#sprout-wellness)
- [Performance Management](https://guide.sprout.ph/performance-management?hsLang=en#main-content)
  
  
  
  
  
    - [Frequently Asked Questions](https://guide.sprout.ph/performance-management?hsLang=en#frequently-asked-questions)
    - [Learning Management](https://guide.sprout.ph/performance-management?hsLang=en#learning-management)
    - [New Features](https://guide.sprout.ph/performance-management?hsLang=en#new-features)
    - [Setup](https://guide.sprout.ph/performance-management?hsLang=en#setup)
- [Sprout Sidekick](https://guide.sprout.ph/sprout-sidekick?hsLang=en#main-content)
  
  
  
  
  
    - [Sprout Concierge](https://guide.sprout.ph/sprout-sidekick?hsLang=en#sprout-concierge)
    - [Sidekick Central](https://guide.sprout.ph/sprout-sidekick?hsLang=en#sidekick-central)
    - [Payslip Agent](https://guide.sprout.ph/sprout-sidekick?hsLang=en#payslip-agent)
    - [Concierge Agent](https://guide.sprout.ph/sprout-sidekick?hsLang=en#concierge-agent)
    - [Sprout Info Agent](https://guide.sprout.ph/sprout-sidekick?hsLang=en#sprout-info-agent)
    - [Compliance Agent](https://guide.sprout.ph/sprout-sidekick?hsLang=en#compliance-agent)
    - [Attendance Agent](https://guide.sprout.ph/sprout-sidekick?hsLang=en#attendance-agent)
    - [Records Agent](https://guide.sprout.ph/sprout-sidekick?hsLang=en#records-agent)
    - [Helpdesk](https://guide.sprout.ph/sprout-sidekick?hsLang=en#helpdesk)
    - [Sidekick](https://guide.sprout.ph/sprout-sidekick?hsLang=en#sidekick)
- [Sprout Ecosystem](https://guide.sprout.ph/sprout-ecosystem?hsLang=en#main-content)
  
  
  
  
  
    - [User Management](https://guide.sprout.ph/sprout-ecosystem?hsLang=en#user-management)
    - [FAQs](https://guide.sprout.ph/sprout-ecosystem?hsLang=en#faqs)
    - [What's Happening Widget](https://guide.sprout.ph/sprout-ecosystem?hsLang=en#whats-happening-widget)
- [Sprout Onboarding Module](https://guide.sprout.ph/sprout-onboarding-module?hsLang=en#main-content)
  
  
  
  
  
    - [Users](https://guide.sprout.ph/sprout-onboarding-module?hsLang=en#users)
- [Sprout HR Infographics](https://guide.sprout.ph/sprout-hr-infographics?hsLang=en#main-content)
  
  
  
  
  
    - [HR Infographics](https://guide.sprout.ph/sprout-hr-infographics?hsLang=en#hr-infographics)
- [Sprout Insight](https://guide.sprout.ph/sprout-insight?hsLang=en#main-content)
  
  
  
  
  
    - [Frequently Asked Questions (FAQs)](https://guide.sprout.ph/sprout-insight?hsLang=en#frequently-asked-questions-faqs)
    - [HR Dashboards](https://guide.sprout.ph/sprout-insight?hsLang=en#hr-dashboards)
    - [Payroll Dashboards](https://guide.sprout.ph/sprout-insight?hsLang=en#payroll-dashboards)
- [Sprout Finances](https://guide.sprout.ph/sprout-finances?hsLang=en#main-content)
  
  
  
  
  
    - [Finances Admin Dashboard](https://guide.sprout.ph/sprout-finances?hsLang=en#finances-admin-dashboard)
    - [Sprout ReadyCash](https://guide.sprout.ph/sprout-finances?hsLang=en#sprout-readycash)
    - [Sprout ReadyWage](https://guide.sprout.ph/sprout-finances?hsLang=en#sprout-readywage)
    - [DAT File](https://guide.sprout.ph/sprout-finances?hsLang=en#dat-file)
    - [Sprout ReadyCash - Netbank](https://guide.sprout.ph/sprout-finances?hsLang=en#sprout-readycash-netbank)
- [Sprout Mobile App](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#main-content)
  
  
  
  
  
    - [Approval Center](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#approval-center)
    - [Attendance](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#attendance)
    - [Clock In Features](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#clock-in-features)
    - [Employee Directory](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#employee-directory)
    - [FAQs](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#faqs)
    - [Login](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#login)
    - [My Request](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#my-request)
    - [Payroll](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#payroll)
    - [Finances](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#finances)
    - [Artificial Intelligence](https://guide.sprout.ph/sprout-mobile-app?hsLang=en#artificial-intelligence)
- [Sprout Payroll](https://guide.sprout.ph/sprout-payroll?hsLang=en#main-content)
  
  
  
  
  
    - [13th Month](https://guide.sprout.ph/sprout-payroll?hsLang=en#13th-month)
    - [Adjustment Report](https://guide.sprout.ph/sprout-payroll?hsLang=en#adjustment-report)
    - [Adjustments](https://guide.sprout.ph/sprout-payroll?hsLang=en#adjustments)
    - [Audit Trail](https://guide.sprout.ph/sprout-payroll?hsLang=en#audit-trail)
    - [BIR Forms](https://guide.sprout.ph/sprout-payroll?hsLang=en#bir-forms)
    - [Company Profile](https://guide.sprout.ph/sprout-payroll?hsLang=en#company-profile)
    - [DAT/Bank Files](https://guide.sprout.ph/sprout-payroll?hsLang=en#dat-bank-files)
    - [Demographic](https://guide.sprout.ph/sprout-payroll?hsLang=en#demographic)
    - [Employees](https://guide.sprout.ph/sprout-payroll?hsLang=en#employees)
    - [FAQs](https://guide.sprout.ph/sprout-payroll?hsLang=en#faqs)
    - [Final Pay](https://guide.sprout.ph/sprout-payroll?hsLang=en#final-pay)
    - [General Payroll Setup](https://guide.sprout.ph/sprout-payroll?hsLang=en#general-payroll-setup)
    - [Modification](https://guide.sprout.ph/sprout-payroll?hsLang=en#modification)
    - [Monthly Summary](https://guide.sprout.ph/sprout-payroll?hsLang=en#monthly-summary)
    - [New Hire Proration](https://guide.sprout.ph/sprout-payroll?hsLang=en#new-hire-proration)
    - [Other Statutory-Related Reports](https://guide.sprout.ph/sprout-payroll?hsLang=en#other-statutory-related-reports)
    - [Pag-Ibig/HDMF Reports](https://guide.sprout.ph/sprout-payroll?hsLang=en#pag-ibig-hdmf-reports)
    - [Password Management](https://guide.sprout.ph/sprout-payroll?hsLang=en#password-management)
    - [Payroll Runs](https://guide.sprout.ph/sprout-payroll?hsLang=en#payroll-runs)
    - [Payroll Scenarios](https://guide.sprout.ph/sprout-payroll?hsLang=en#payroll-scenarios)
    - [Payroll Summary](https://guide.sprout.ph/sprout-payroll?hsLang=en#payroll-summary)
    - [Payroll Transactions](https://guide.sprout.ph/sprout-payroll?hsLang=en#payroll-transactions)
    - [Payroll Users](https://guide.sprout.ph/sprout-payroll?hsLang=en#payroll-users)
    - [PhilHealth Reports](https://guide.sprout.ph/sprout-payroll?hsLang=en#philhealth-reports)
    - [Processing](https://guide.sprout.ph/sprout-payroll?hsLang=en#processing)
    - [RBAC](https://guide.sprout.ph/sprout-payroll?hsLang=en#rbac)
    - [Report Logs](https://guide.sprout.ph/sprout-payroll?hsLang=en#report-logs)
    - [Setup](https://guide.sprout.ph/sprout-payroll?hsLang=en#setup)
    - [SSS Reports](https://guide.sprout.ph/sprout-payroll?hsLang=en#sss-reports)
    - [Statutory](https://guide.sprout.ph/sprout-payroll?hsLang=en#statutory)
    - [Tax Computation](https://guide.sprout.ph/sprout-payroll?hsLang=en#tax-computation)
    - [YTD Report](https://guide.sprout.ph/sprout-payroll?hsLang=en#ytd-report)
    - [YTD Report - Adjustments](https://guide.sprout.ph/sprout-payroll?hsLang=en#ytd-report-adjustments)
- [Sprout HR](https://guide.sprout.ph/sprout-hr?hsLang=en#main-content)
  
  
  
  
  
    - [Add/Edit/Delete Employees](https://guide.sprout.ph/sprout-hr?hsLang=en#add-edit-delete-employees)
    - [Announcements](https://guide.sprout.ph/sprout-hr?hsLang=en#announcements)
    - [Application Access](https://guide.sprout.ph/sprout-hr?hsLang=en#application-access)
    - [Application Filing](https://guide.sprout.ph/sprout-hr?hsLang=en#application-filing)
    - [Approval Center](https://guide.sprout.ph/sprout-hr?hsLang=en#approval-center)
    - [Approval, Rejection, and Cancellation](https://guide.sprout.ph/sprout-hr?hsLang=en#approval-rejection-and-cancellation)
    - [Assets, Visas, Benefits Types, Loans](https://guide.sprout.ph/sprout-hr?hsLang=en#assets-visas-benefits-types-loans)
    - [Attendance Application Policies](https://guide.sprout.ph/sprout-hr?hsLang=en#attendance-application-policies)
    - [Attendance Logs](https://guide.sprout.ph/sprout-hr?hsLang=en#attendance-logs)
    - [Attendance Management](https://guide.sprout.ph/sprout-hr?hsLang=en#attendance-management)
    - [Attendance Report](https://guide.sprout.ph/sprout-hr?hsLang=en#attendance-report)
    - [Attendance Report Policies](https://guide.sprout.ph/sprout-hr?hsLang=en#attendance-report-policies)
    - [Audit Trail](https://guide.sprout.ph/sprout-hr?hsLang=en#audit-trail)
    - [Biometrics](https://guide.sprout.ph/sprout-hr?hsLang=en#biometrics)
    - [Bulk Uploads](https://guide.sprout.ph/sprout-hr?hsLang=en#bulk-uploads)
    - [Certificate of Attendance Application Email Templates](https://guide.sprout.ph/sprout-hr?hsLang=en#certificate-of-attendance-application-email-templates)
    - [Company Profile](https://guide.sprout.ph/sprout-hr?hsLang=en#company-profile)
    - [Company Tools](https://guide.sprout.ph/sprout-hr?hsLang=en#company-tools)
    - [Date Tagging of Work Schedules](https://guide.sprout.ph/sprout-hr?hsLang=en#date-tagging-of-work-schedules)
    - [Employee List Report](https://guide.sprout.ph/sprout-hr?hsLang=en#employee-list-report)
    - [Employee Profile](https://guide.sprout.ph/sprout-hr?hsLang=en#employee-profile)
    - [Employee Profile Access](https://guide.sprout.ph/sprout-hr?hsLang=en#employee-profile-access)
    - [Filing and Editing Applications](https://guide.sprout.ph/sprout-hr?hsLang=en#filing-and-editing-applications)
    - [Form Generator](https://guide.sprout.ph/sprout-hr?hsLang=en#form-generator)
    - [Form Templates](https://guide.sprout.ph/sprout-hr?hsLang=en#form-templates)
    - [Frequently Asked Questions (FAQs)](https://guide.sprout.ph/sprout-hr?hsLang=en#frequently-asked-questions-faqs)
    - [Holiday Policies](https://guide.sprout.ph/sprout-hr?hsLang=en#holiday-policies)
    - [Leave Application Email Templates](https://guide.sprout.ph/sprout-hr?hsLang=en#leave-application-email-templates)
    - [Leave Report](https://guide.sprout.ph/sprout-hr?hsLang=en#leave-report)
    - [Locations](https://guide.sprout.ph/sprout-hr?hsLang=en#locations)
    - [Login](https://guide.sprout.ph/sprout-hr?hsLang=en#login)
    - [Memo Search](https://guide.sprout.ph/sprout-hr?hsLang=en#memo-search)
    - [Module Access](https://guide.sprout.ph/sprout-hr?hsLang=en#module-access)
    - [My Attendance](https://guide.sprout.ph/sprout-hr?hsLang=en#my-attendance)
    - [My Profile](https://guide.sprout.ph/sprout-hr?hsLang=en#my-profile)
    - [New Updates & Announcements](https://guide.sprout.ph/sprout-hr?hsLang=en#new-updates-announcements)
    - [Official Business Application Email Templates](https://guide.sprout.ph/sprout-hr?hsLang=en#official-business-application-email-templates)
    - [Other Policies](https://guide.sprout.ph/sprout-hr?hsLang=en#other-policies)
    - [Overtime Application Email Templates](https://guide.sprout.ph/sprout-hr?hsLang=en#overtime-application-email-templates)
    - [Overtime Report](https://guide.sprout.ph/sprout-hr?hsLang=en#overtime-report)
    - [Password](https://guide.sprout.ph/sprout-hr?hsLang=en#password)
    - [Payroll Summary](https://guide.sprout.ph/sprout-hr?hsLang=en#payroll-summary)
    - [Project Tagging](https://guide.sprout.ph/sprout-hr?hsLang=en#project-tagging)
    - [Reports Access](https://guide.sprout.ph/sprout-hr?hsLang=en#reports-access)
    - [Resolution Center](https://guide.sprout.ph/sprout-hr?hsLang=en#resolution-center)
    - [Scenarios](https://guide.sprout.ph/sprout-hr?hsLang=en#scenarios)
    - [Setup](https://guide.sprout.ph/sprout-hr?hsLang=en#setup)
    - [Single Sign-On (SSO)](https://guide.sprout.ph/sprout-hr?hsLang=en#single-sign-on-sso)
    - [Syncing](https://guide.sprout.ph/sprout-hr?hsLang=en#syncing)
    - [Timesheet Lock](https://guide.sprout.ph/sprout-hr?hsLang=en#timesheet-lock)
    - [Troubleshooting](https://guide.sprout.ph/sprout-hr?hsLang=en#troubleshooting)
    - [Undertime Application Email Templates](https://guide.sprout.ph/sprout-hr?hsLang=en#undertime-application-email-templates)
    - [Work Schedules](https://guide.sprout.ph/sprout-hr?hsLang=en#work-schedules)
    - [Feature Management](https://guide.sprout.ph/sprout-hr?hsLang=en#feature-management)
- [Referrly](https://guide.sprout.ph/referrly?hsLang=en#main-content)
  
  
  
  
  
    - [FAQs](https://guide.sprout.ph/referrly?hsLang=en#faqs)
    - [Applicant Guides](https://guide.sprout.ph/referrly?hsLang=en#applicant-guides)
    - [Employee Guides](https://guide.sprout.ph/referrly?hsLang=en#employee-guides)
    - [HR Guides - Job Openings](https://guide.sprout.ph/referrly?hsLang=en#hr-guides-job-openings)
    - [HR Guides - Applicants](https://guide.sprout.ph/referrly?hsLang=en#hr-guides-applicants)
    - [HR Guides - Reward Payouts](https://guide.sprout.ph/referrly?hsLang=en#hr-guides-reward-payouts)
- [Hubstaff](https://guide.sprout.ph/hubstaff?hsLang=en#main-content)
  
  
  
  
  
    - [Accounting and Invoicing](https://guide.sprout.ph/hubstaff?hsLang=en#accounting-and-invoicing)
    - [API](https://guide.sprout.ph/hubstaff?hsLang=en#api)
    - [Communication](https://guide.sprout.ph/hubstaff?hsLang=en#communication)
    - [CRM](https://guide.sprout.ph/hubstaff?hsLang=en#crm)
    - [Helpdesk](https://guide.sprout.ph/hubstaff?hsLang=en#helpdesk)
    - [FAQs](https://guide.sprout.ph/hubstaff?hsLang=en#faqs)
    - [Project Management](https://guide.sprout.ph/hubstaff?hsLang=en#project-management)
    - [Zapier](https://guide.sprout.ph/hubstaff?hsLang=en#zapier)
- [Billings and Invoices](https://guide.sprout.ph/billings-and-invoices?hsLang=en)
- [API Services](https://guide.sprout.ph/api-services?hsLang=en#main-content)
  
  
  
  
  
    - [Setup](https://guide.sprout.ph/api-services?hsLang=en#setup)
- [Peoplebox](https://guide.sprout.ph/peoplebox?hsLang=en#main-content)
  
  
  
  
  
    - [Setup](https://guide.sprout.ph/peoplebox?hsLang=en#setup)
    - [FAQs](https://guide.sprout.ph/peoplebox?hsLang=en#faqs)
- [Jazz HR](https://guide.sprout.ph/jazz-hr?hsLang=en#main-content)
  
  
  
  
  
    - [Setup](https://guide.sprout.ph/jazz-hr?hsLang=en#setup)
    - [FAQs](https://guide.sprout.ph/jazz-hr?hsLang=en#faqs)
- [Comply](https://guide.sprout.ph/comply?hsLang=en#main-content)
  
  
  
  
  
    - [Frequently Asked Questions](https://guide.sprout.ph/comply?hsLang=en#frequently-asked-questions)
- [Teamtailor](https://guide.sprout.ph/teamtailor?hsLang=en#main-content)
  
  
  
  
  
    - [FAQs](https://guide.sprout.ph/teamtailor?hsLang=en#faqs)

Copyright © 2025, Sprout Solutions