{"id":3398,"date":"2026-02-27T21:56:33","date_gmt":"2026-02-28T02:56:33","guid":{"rendered":"https:\/\/www.airsupervision.com\/wp-r\/docs\/organization-staff\/members-center\/importing-data-from-file\/"},"modified":"2026-02-28T11:07:21","modified_gmt":"2026-02-28T16:07:21","slug":"importing-data-from-file","status":"publish","type":"docs","link":"https:\/\/www.airsupervision.com\/wp-r\/docs\/organization-staff\/members-center\/importing-data-from-file\/","title":{"rendered":"Importing data from file"},"content":{"rendered":"\n

Importing from file helps you add multiple members faster, without typing each profile manually. The system checks your file before saving anything, so you can correct issues early and avoid partial data.<\/p>\n\n\n\n

\"\"<\/a>
Import CSV button highlighted in the grid toolbar<\/figcaption><\/figure>\n\n\n\n

What is a CSV file?<\/strong><\/h2>\n\n\n\n

A CSV file is a simple spreadsheet file where each line is one person and each column is one field\u00a0(for example Lastname,\u00a0Givenname,\u00a0Email).\u00a0You can create it in Excel,\u00a0LibreOffice Calc,\u00a0Google Sheets,\u00a0or similar tools,\u00a0then save\/export as\u00a0.csv.<\/p>\n\n\n\n

Think of CSV as a “table in text format” that systems can read quickly.<\/p>\n\n\n\n

\"\"<\/a>
Example spreadsheet showing column headers in row 1 and member data in rows below<\/figcaption><\/figure>\n\n\n\n

Before you start<\/strong><\/h2>\n\n\n\n

Make sure:<\/p>\n\n\n\n

    \n
  1. You have permission to add members.<\/li>\n\n\n\n
  2. Row 1 contains the column names (headers).<\/li>\n\n\n\n
  3. Each member is on one line only.<\/li>\n\n\n\n
  4. You review spellings and email addresses before upload.<\/li>\n<\/ol>\n\n\n\n

    If one row is invalid, the import is blocked and nothing is saved.<\/p>\n\n\n\n

    \"\"<\/a>
    Import CSV dialog opened before any file is uploaded<\/figcaption><\/figure>\n\n\n\n

    Required file schema<\/strong><\/h2>\n\n\n\n

    Use these header names in your CSV file. Header names are case-insensitive, but wording must match the list below.<\/p>\n\n\n\n

    Column header<\/th>Required<\/th>Purpose<\/th><\/tr><\/thead>
    lastname<\/code><\/td>Yes<\/td>Member family name<\/td><\/tr>
    givenname<\/code><\/td>Yes<\/td>Member first name<\/td><\/tr>
    email<\/code><\/td>Yes<\/td>Main email\/login address<\/td><\/tr>
    address<\/code><\/td>No<\/td>Mailing or contact address<\/td><\/tr>
    licence<\/code><\/td>No<\/td>License number<\/td><\/tr>
    phone1<\/code><\/td>No<\/td>Main phone number<\/td><\/tr>
    cell1<\/code><\/td>No<\/td>Main mobile number<\/td><\/tr>
    phone2<\/code><\/td>No<\/td>Secondary phone number<\/td><\/tr>
    cell2<\/code><\/td>No<\/td>Secondary mobile number<\/td><\/tr>
    birthday<\/code><\/td>No<\/td>Date of birth<\/td><\/tr>
    addinfo_1<\/code>, addinfo_2<\/code>, addinfo_12<\/code>…<\/td>No<\/td>Additional information slots (the number identifies which slot is filled)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

    Important:<\/p>\n\n\n\n