Importing your spreadsheet

The file

The importer reads a CSV file or an Excel workbook (.xlsx), up to 1 MB, with a header row. Only one column is required: the person's name. Every other column can be missing.

In an Excel workbook, Currity reads every sheet that has a header row and a row under it. If more than one sheet has rows in it, you choose which one holds the crew. Empty sheets are left out.

The two shapes it reads

• One row per person, with a column for each credential. Each credential column holds that card's expiry date. The heading is matched to your credential types, so a column headed Fall Protection expiry is read as the expiry of Fall Protection. A heading with completed or issued in it (or complete, completion or issue) is read as the card's issue date instead: the free template's OSHA 10 (completed) column holds the day the course was done, because an OSHA 10 card does not expire.
• One row per credential, with one column naming the credential and columns for its expiry and issue dates. Currity reads a file this way when it finds both a credential column and an expiry column.

If Currity picks the wrong shape, change it under This file has.

Cards from a state or city guide

A column headed with the exact name a state or city guide gives a card is read as that card, even when your credential types do not have it yet. The spreadsheet from What does my crew need? is headed this way, so it imports on a new account with nothing to set up first.

The column's picker says New card type, from the Nevada guide (or whichever guide names it). Pressing Import adds the card to your credential types, with the name, length and issuer the guide gives, and files the dates under it.

• Only an exact name counts. A heading that only looks like a guide card, such as Fire Marshal, is matched to your own credential types as usual, or set to Ignore this column.
• A credential type you already have with that name is always used instead. Nothing is added twice.
• Before you import, you can change the column to any of your own credential types, or ignore it. Then nothing is added.
• Importing never decides which roles need a card. When it is done, follow Choose the roles on State rules to mark them.
• Only an owner or an admin can add credential types, so only they are offered this.

Column names it recognizes

Case and punctuation in a heading do not matter.

• Name: name, employee name, full name, worker, employee, crew member, person.
• Role: role, job title, title, trade, position, classification, craft.
• Site: site, jobsite, job site, location, crew, project.
• Email: email, email address, e-mail.
• Phone: phone, phone number, mobile, cell, cell phone, telephone.
• Employee ID: employee id, employee #, emp id, id, badge, badge number.
• Language: language, preferred language, crew language, lang, idioma, lengua. A cell reading en, english, es, spanish or español sets the crew member's language. Anything else is left as English and listed for you.
• For one row per credential, the credential: credential, certification, cert, training, course, type.
• Its expiry: expires, expiry, expiration, expiration date, expires on, valid until.
• Its issue date: issued, issue date, issued on, completed, date completed.

Steps

1. 01Open Import in the menu.
2. 02Press Choose your spreadsheet and pick the CSV or Excel file. For a workbook with more than one sheet of rows, choose the sheet that holds the crew.
3. 03Check This file has: one row per person, or one row per credential.
4. 04Under How each column is read, check each column. Change any guess that is wrong and the preview updates straight away. Set a column to Ignore this column to leave it out.
5. 05Read the preview: each person with their role, site and the credentials found, and any rows that need a look.
6. 06Tick Send everyone added with an email a card request now if you want the crew to send photos of their cards.
7. 07Press the import button. It counts the people, as in Import 42 people.

Before anything is saved

Nothing is written until you press Import. Before that you see every person and every date Currity found.

• Dates are read in most shapes: 09/17/2027, 2027-09-17, 17 Sep 2027, and Excel's date numbers.
• In an Excel file, a cell formatted as a date is read as the day Excel shows, so it never needs checking.
• A date typed as text that could be read two ways, day first or month first, is flagged so you can check it.
• A date that cannot be read is listed for you, not guessed at.
• A row with no name is skipped, and the list says which row.
• In a file with one row per person, a column that matches none of your credential types, and names no guide card exactly, is set to Ignore this column. Check it before you import.
• In a file with one row per credential, a credential that is not in your credential types is skipped, and the list says so.

People already on the board

• A row is matched to someone already on the board by name, ignoring case and spaces at either end.
• Nobody is added twice. A matched person keeps their role, site, email and crew language as they are on the board.
• New credentials in the file are added to the matched person. A card already on file with the same expiry is skipped.
• Two rows with the same name in one file become one person.

When it is done, Currity says how many people were added, how many were already on the roster, how many credentials were recorded, and which card types it added from a guide.

Have us import it for you

Rather hand it over? On the home page, go to Have us import your spreadsheet. Enter your email address. Your name, company, crew size and a note are optional. Press Book the import and we email you to book a time for a call, where we load your list while you watch.

Bring the list in whatever shape it is in. You can also email it to hello@currity.com.

Good to know

• CSV and .xlsx only. An older Excel file (.xls) has to be saved as .xlsx or CSV first: in Excel, choose File, Save As.
• A file over 1 MB is refused. That is usually pictures or extra sheets: save a copy with only the crew list, or save it as CSV.
• The importer adds a credential type only for a column that names a state or city guide's card exactly. For any other card you do not have yet, add it first with Other: add your own… in the credential list on the board, then import.
• The importer does not read card numbers or who issued a card. Add them on the person's file, under Number and issuer, optional.
• To change someone already on the board, edit their file. Importing again does not change them.
• A read only account cannot import. See Billing, the trial and cancelling.