Our import tool helps you add employees under payroll to Lano. Upload a comma-separated value file (CSV), or type info directly into the single employee import tool.

Before you start

Here are some things to know before you begin this process.

  • To get started, you'll need a blank sheet in a spreadsheet program like Microsoft Excel or Google Sheets, saved or exported as a comma-separated value (CSV) file.

  • Certain fields, like birthday and contract start date, must be formatted in a specific way. Make sure you're familiar with our format guidelines before you import your file.

Import new contacts

The file import process has two parts: First, you'll prepare your spreadsheet of employees outside of Lano and save it as a CSV file. Next, you'll use our import tool to upload your file and invite your employees to Lano.

Prepare for Import

To prepare your file for import, follow these steps.

  1. In a spreadsheet program like Excel or Google Sheets, open your blank worksheet OR download our template file, and fill it in as per our guidelines.

  2. Create and label columns for:

    • Email Address

    • First name

    • Last name

    • Job title

    • Birthdate

    • Contract start date

    • Annual gross salary

    • Currency

    • IBAN

  3. Paste your employees’ information into the relevant fields in the spreadsheet.

  4. Save the file in CSV format. This option can usually be accessed from the File menu in your spreadsheet program, labeled as "Export as .CSV" or "Download as .CSV". Different spreadsheet programs will vary a little bit.

Nice job! Now that you've prepared your CSV file, you're ready to import.

Please note: Need some help saving your spreadsheet file in CSV format before you import? Check out these CSV tips from Excel and Google Sheets. Or, download our sample CSV import file and replace the sample emails with your own data.

Import your payroll employees

Step 1: Go to My Network > Team members and then upload the CSV file of your employees that you’ve created.

Step 2: Once the file is uploaded, the gaps in your CSV will be identified and you will be asked to change invalid data points before submitting.

Step 3: After required modifications, you will be able to import your employees and the new ones will be successfully created in Lano.

Update existing contacts

In order to update existing employee details, you have to go through the employee profile details. You can access it via My Network > Team member > select your employee > Edit.

Did this answer your question?