Skip to content
English
  • There are no suggestions because the search field is empty.

File Formats, Processing, and Employee Data

This guide covers file formats, processing times, and how to handle common issues with employee data.

Before You Start

  • Download the Airbo CSV template before creating your file

  • Save your file as CSV (not Excel .xlsx)

Time needed: 5 minutes to read, varies for file preparation

 

Frequently Asked Questions

How long does processing take?

Census file processing takes 24 to 48 hours. You'll receive an email notification when your file has been processed.

Tip: Plan your uploads at least 2 days before you need employees to have access. Don't upload right before a campaign launch.

 

What file format do I need?

Airbo requires a CSV file (Comma Separated Values).

How to save as CSV from Excel:

  • Open your file in Excel

  • Click File > Save As

  • Choose CSV (Comma delimited) from the format dropdown

  • Click Save

Warning: If you upload an Excel file (.xlsx or .xls), it will not process correctly.

 

What columns are required?

At minimum, your file needs:

Column Required? Notes
Full Name or First/Last Name Yes One column or two separate columns
Email Address Yes Must be valid, working email
Phone Number No Optional, for SMS features

Note: Download the template from Airbo to see the exact column headers expected.

 

What happens when I upload a new file?

Airbo compares your new file to the existing employee list:

  • New employees are added automatically

  • Existing employees stay unchanged

  • Removed employees (in old file but not new) are deactivated

Important: Always upload a complete file with all current employees. Don't upload just the new hires.

 

What happens to terminated employees?

When an employee is not included in your new census upload:

  1. Their account is deactivated

  2. They can no longer access the board

  3. Their historical data is preserved for reporting

Note: You don't need to manually remove employees. Just exclude them from your next census file.

 

Can I add employees one at a time?

Yes! For small additions, use the manual add feature:

  • Go to your Board then click Users

  • In Add Users, under Manage Users, enter name and email

  • Click Add User

This is instant, no 24-48 hour wait required.

 

Why did my upload fail?

Common reasons for failed uploads:

1. Wrong file format

  • Uploaded Excel instead of CSV

  • Fix: Save as CSV and re-upload

2. Missing required columns

  • File doesn't have name or email columns

  • Fix: Use the Airbo template

3. Invalid email addresses

  • Typos or formatting errors in emails

  • Fix: Review and correct email addresses

4. Special characters

  • Names contain characters that break the CSV

  • Fix: Remove special characters or use UTF-8 encoding

 

How do I update an employee's email address?

Option 1: Upload a new census file

Include the employee with their new email. Airbo matches by name.

Option 2: Edit manually

  • Go to your Board then click Users > All Users

  • Search for the employee

  • Click their name

  • Update the email field

  • Save changes

 

How often should I update my census?

Most customers update monthly. Consider updating:

  • When new employees are hired

  • When employees leave

  • Before major campaigns or open enrollment

  • At least quarterly to keep data fresh

 

Troubleshooting Quick Reference

Problem Likely Cause Solution
Upload stuck processing Large file or system queue Wait 48 hours, then contact support
Employees not showing up Processing not complete Wait for confirmation email
Duplicate employees Uploaded twice Remove duplicates from file
Wrong employee count Partial file uploaded Upload complete employee list
Email errors Invalid email format Check for typos, add @ symbol

 

Tips for Success

  • Do this: Keep a master employee list that you update regularly

  • Avoid this: Creating new files from scratch each time

  • Remember: The template ensures your columns are formatted correctly

 

Related Articles

 

Need more help? Contact support@airbo.com