Search

How to Upload Employee Data in Bulk (Bulk Upload Employee)

Article author
Learning Center Mekari
  • Updated

Currently, Mekari Expense offers the Bulk Upload Employee feature to facilitate non-Talenta company users in easily uploading employee data in bulk. Here are the steps.

  1. Go to the Users menu.

  2. Then click “Bulk upload employee”.
    1.png

  3. Next, select the “Upload CSV” tab to upload employee data.
    3.png

  4. Click ‘Download template” to download the document template that will help you organize employee data.
    4.png

    - When filling in employee data, you must fill in Employee code, Employee name, Employee email, Phone, Employment status, Role, Bank Code, and Bank Account Number.
    - Filling in Join Date, End Employment Date, Job Position, Branch, Organization, Grade, Upper position, and Job Level is optional.

  5. After filling in the employee data, upload the document in CSV format by clicking “Browse” or you can also drag the document into the box as shown below.
    5.png

    - The file must be in CSV format with a maximum size of 5 MB. Here are the steps to convert an XLS file to CSV format:
    1. Open your Excel file.
    2. Click "File" then select "Save as".
    1.png
    3. Enter the file name.
    4. Then, choose where you want to save the file (such as desktop or drive).
    2.png
    5. In the 'Save as' dropdown, select "CSV" (Comma delimited).
    3.png
    6. Then, click "Save".
    4.png7. You may receive one or two warnings about .csv formatting; click "Yes".
    - You can upload a maximum of 1000 data entries.

  6. Once all data has been uploaded, click “Submit”.
    8.png

  7. A notification will appear stating that you have successfully uploaded employee data.
    7.png

  8. The uploaded employee data will appear on the main Users page.
    9.png

  9. All uploaded data on the main Users page will also be available on the Upload log page found in the Bulk upload employee menu.
    10.png

    If the uploaded data status is Failed, you can click “View details” as shown above to see detailed information about the failed uploads. You will then be directed to the Bulk upload employee details page as follows. On this page, you can see the Note containing the reasons for the upload failure.
    11.png

That concludes the explanation of how to upload employee data in bulk. Next, you can also learn about syncing employee data from Talenta and how to change access status here.