--- title: "ZKBio Time.Net Import Employees From Excel | Qyvea" url: https://qyvea.co.ke/zkbio-time-net-import-employees-excel description: "Bulk-add staff to ZKBio Time.Net from an Excel or CSV sheet: the columns to prepare, how to import and how to check for duplicates before syncing." updated: 2026-10-20 --- > Markdown copy of https://qyvea.co.ke/zkbio-time-net-import-employees-excel for AI assistants. Prices and stock change; check the live page. We deliver products across Kenya · dispatched once payment is confirmed · delivered within 24 hours[CCTV Installation](https://qyvea.co.ke/cctv)[Access Control](https://qyvea.co.ke/access-control-systems-kenya)[Biometrics & Attendance](https://qyvea.co.ke/biometrics)[Electric Fencing](https://qyvea.co.ke/electric-fence)[Automatic Gates](https://qyvea.co.ke/automatic-gates)[Fire Alarm Systems](https://qyvea.co.ke/fire-alarm-systems)[Security Guards & K9](https://qyvea.co.ke/security-guards)[Solar Installation](https://qyvea.co.ke/solar-installation)[Solar & Power Backup](https://qyvea.co.ke/solar-solutions)[Electrical Installation](https://qyvea.co.ke/electrical-installation)[Smart Home Automation](https://qyvea.co.ke/smart-home-automation)[Building Management (BMS)](https://qyvea.co.ke/bms)[Networking & Wi-Fi](https://qyvea.co.ke/networking)[IT Support](https://qyvea.co.ke/it-support)[Cyber Security](https://qyvea.co.ke/cybersecurity)[System Integration](https://qyvea.co.ke/system-integration)[Intercom Systems](https://qyvea.co.ke/intercom)[PA Systems](https://qyvea.co.ke/pa-systems)[POS Systems](https://qyvea.co.ke/pos-systems)[Queue Management](https://qyvea.co.ke/queue-management-systems)[Business Supply (B2B)](https://qyvea.co.ke/business-supply-kenya)[Maintenance & Repairs](https://qyvea.co.ke/maintenance) Biometrics & Attendance · Guide # ZKBio Time.Net: Import Employees From Excel Typing 200 people one by one is a bad afternoon. Import them from a spreadsheet. [Shop ZKTeco K40 terminals →](https://qyvea.co.ke/products/zkteco-k40-fingerprint-time-attendance-terminal-67)[Get help on WhatsApp](https://wa.me/254113301244?text=Hi%20Qyvea%2C%20I%20read%20your%20guide%3A%20ZKBio%20Time.Net%3A%20Import%20Employees%20From%20Excel.%20I%20need%20help%20with%20my%20ZKTeco%20K40%20Pro.) Quick answer Prepare a sheet with Employee ID, name, department and hire date, use the Import option on the Employee screen (Personnel > Employee), fix any rejected rows, then sync to the terminal. **Buy your ZKTeco K40 from Qyvea**: Supplied and installed across Kenya. Delivered within 24 hours once payment is confirmed. [Shop ZKTeco K40 terminals →](https://qyvea.co.ke/products/zkteco-k40-fingerprint-time-attendance-terminal-67)[All attendance terminals](https://qyvea.co.ke/products?cat=biometrics&search=attendance)[Ask Qyvea on WhatsApp](https://wa.me/254113301244?text=Hi%20Qyvea%2C%20I%20read%20your%20guide%3A%20ZKBio%20Time.Net%3A%20Import%20Employees%20From%20Excel.%20I%20need%20help%20with%20a%20ZKTeco%20K40%20Pro.%20Please%20quote%20me.) ## Key takeaways - One row per person, unique IDs. - Create departments before importing. - Check for duplicates first. - Sync to the terminal after importing. ## Prepare the sheet - Columns for Employee ID, first name, last name, department and hire date (follow the template your version offers). - IDs: unique, digits only. - Department names must match departments already created. - Remove blank rows and merged cells. - Save as Excel or CSV as the import screen asks. **Tip**: Many versions offer a downloadable template on the import screen. Start from it so the columns match. ## Import 1. Open Personnel > Employee. 2. Click the Import button. 3. Choose your file and map the columns if asked. 4. Click OK and read the result message listing successes and failures. ## Fix rejected rows - Duplicate ID: the ID exists already. Change or remove the row. - Unknown department: create it first. - Wrong date format: use the format shown in the template. ## After the import Spot-check a few people in the list, then run Sync Data to push them to the terminal and enrol fingerprints. If the terminal already has users with the same IDs, sync carefully; see [duplicate employee IDs](https://qyvea.co.ke/zkbio-time-net-duplicate-employee-id). ## Keep the sheet Save the final sheet in your records. It is a handy backup of your staff list. ## A typical scenario A school with 180 staff prepared an Excel list from HR with ID, name and department. The first import rejected 12 rows because of unknown departments. Creating them first and re-importing loaded all 180 in minutes. *Illustrative example based on common cases, not a named customer.* ## Common mistakes - Importing with merged cells or blank rows. - Department names that do not match. - Duplicate IDs in the sheet. - Dates in the wrong format. - Importing before a backup. ## Quick checklist 1. Use the template 2. Unique IDs 3. Departments created 4. Remove blank rows 5. Import and read the result 6. Sync to the terminal ## Frequently asked questions Can I import from payroll software? Export the staff list to Excel, match the columns and import. Does importing enrol fingerprints? No. Fingerprints are enrolled on the terminal or through the software with a finger on the sensor. What if I import the same file twice? Rows with existing IDs are normally rejected as duplicates. Is there a limit on rows? It depends on your version and licence. Import in batches of a few hundred if it struggles. This guide is part of our [ZKTeco K40 and ZKBio Time.Net series](https://qyvea.co.ke/zkteco-k40-zkbio-time-net-guides-kenya). For the full start-to-finish walkthrough with screenshots, read [How to Configure a ZKTeco K40 Pro with ZKBio Time.Net](https://qyvea.co.ke/how-to-configure-zkteco-k40-pro-zkbio-time-net). ZKTeco and ZKBio are trademarks of ZKTeco Inc. Menu names on the K40 Pro and in the software vary slightly by firmware and software version; where yours differ, look for the nearest match. Qyvea is a ZKTeco reseller and installer in Kenya. **Want us to do this for you?**: We supply, install, configure the software, enrol your staff and train your HR team. [Shop ZKTeco K40 terminals →](https://qyvea.co.ke/products/zkteco-k40-fingerprint-time-attendance-terminal-67)[All attendance terminals](https://qyvea.co.ke/products?cat=biometrics&search=attendance)[Ask Qyvea on WhatsApp](https://wa.me/254113301244?text=Hi%20Qyvea%2C%20I%20read%20your%20guide%3A%20ZKBio%20Time.Net%3A%20Import%20Employees%20From%20Excel.%20I%20need%20help%20with%20a%20ZKTeco%20K40%20Pro.%20Please%20quote%20me.) ## Why customers choose Qyvea **Genuine brands**: Manufacturer warranty on what we sell, so you are not gambling on the box. **One team, start to finish**: The people who advise you also install and support it. **Fast answers**: WhatsApp replies usually within 30 minutes, and delivery within 24 hours in Nairobi. **Easy to buy**: Pay by M-Pesa, bank transfer or card. Free delivery in Nairobi on orders over KES 5,000. **Risk taken off you**: 7-day returns and exchanges on products, and a workmanship warranty on installations. **Customers say so**: Rated 4.6/5 from 57 Google reviews. **Your next step takes one minute:** send us a photo of the place on WhatsApp and we will tell you what it needs. ## Related articles [Biometrics & Attendance · Guide ZKBio Time.Net: Set Up Departments and Areas Departments organise people; areas organise devices and sites. Set both first. 2 min read**READ FULL ARTICLE →**](https://qyvea.co.ke/zkbio-time-net-departments-and-areas)[Biometrics & Attendance · Guide ZKBio Time.Net: Create a Timetable and Shift One timetable is one day's hours; a shift repeats timetables across a week. 2 min read**READ FULL ARTICLE →**](https://qyvea.co.ke/zkbio-time-net-create-timetable-and-shift)[Biometrics & Attendance · Guide Connect a ZKTeco K40 Pro to a PC with a LAN Cable Direct cable or switch: how to link the K40 Pro to your PC with fixed IPs. 2 min read**READ FULL ARTICLE →**](https://qyvea.co.ke/zkteco-k40-pro-connect-to-pc-with-lan-cable) ### Related guides [All ZKTeco K40 and ZKBio guides](https://qyvea.co.ke/zkteco-k40-zkbio-time-net-guides-kenya)[Configure a K40 Pro with ZKBio Time.Net](https://qyvea.co.ke/how-to-configure-zkteco-k40-pro-zkbio-time-net)[Use ZKTeco attendance software](https://qyvea.co.ke/how-to-use-zkteco-attendance-software) ### Related products [ZKTeco K40 terminal](https://qyvea.co.ke/products/zkteco-k40-fingerprint-time-attendance-terminal-67)[ZKTeco K40 price in Kenya](https://qyvea.co.ke/zkteco-k40-price-in-kenya)[ZKTeco attendance machines](https://qyvea.co.ke/zkteco-attendance-machine-price-in-kenya) ### Related services [Biometrics & attendance](https://qyvea.co.ke/biometrics)[Biometric attendance systems](https://qyvea.co.ke/biometric-attendance-systems-kenya) [← Previous**ZKBio Time.Net: How to Add an Employee**](https://qyvea.co.ke/zkbio-time-net-add-employee)[Next →**: How to Delete a User or Fingerprint on a ZKTeco K40 Pro**](https://qyvea.co.ke/zkteco-k40-pro-delete-user) ## Need this system installed? Talk to Qyvea. We design, install and maintain it. Chat with us — 30 min response --- **Qyvea Limited** · Westlands, Nairobi, Kenya (delivery only, no walk-in pickup) · serving all 47 counties Phone/WhatsApp: [+254 113 301 244](https://wa.me/254113301244) · Email: info@qyvea.co.ke · Shop: [qyvea.co.ke/products](https://qyvea.co.ke/products) · Facts: [qyvea.co.ke/qyvea-facts](https://qyvea.co.ke/qyvea-facts)