Features

Import and export

Bring clients, consumers, providers, locations and assignments in from CSV or XLSX files, and export any main list whenever you need a copy.

2 min read Updated

Book a demoContact sales

See it on fetchfido.ai

Import and export sit on the toolbar of every main list. They cover clients, consumers, providers, locations, assignments, shifts and finance lists.

Import

  1. Open the list and choose Import from the import and export icon.
  2. Download the sample template, in XLSX or CSV. It includes your organization's own dropdown values, color-coded headers and an example row.
  3. Fill in the template and upload the file. Fido accepts CSV and XLSX files up to 10 MB.
  4. Review the result.

Large batches run in the background while you keep working. A progress bar shows at the top of the list, and you receive an in-app notice when the import finishes, and an email too when some rows are rejected. The result shows Success, Failed or Partial Success, with counts of rows processed, succeeded and failed.

Update in bulk

Leave the ID blank to create a record. Include a record's ID, or its email address, and the import updates that record instead of adding a copy. Fido matches rows this way:

List Matched by
Clients, consumers, providers, schedulers ID, then email address
Client locations, organization locations ID, then location name
Assignments, shifts, portal requests ID

When you update an assignment, shift or provider, a blank cell keeps the value already stored.

An error report for every run

Download a file listing each row that needed attention, with the row number and the reason. A dropdown value in a file, such as a service type or certification, matches the values defined in your organization, and the report names any value to correct. Phone numbers from any country work in imports.

Export

  • Export a full list as CSV or XLSX. The toolbar export covers every record your role can see.
  • Select rows first to export only those, from the bulk action bar.
  • A small export downloads right away. A larger one runs in the background and you receive an in-app notice and an email with a Download button. The file stays available for 24 hours and only you can see it.

Organizations own their data, and export is available from each module whenever it is needed. After an agreement ends, an organization can export for 30 days. See Security and privacy.

Who can import and export

A scheduler needs write permission on the module to import, and read permission to export or download a template. Administrators have both.

Lists that work the same way

Every main list lets you choose and reorder columns, act on selected rows, delete several rows with a confirmation, edit supported fields in place and duplicate a record to start the next one. Press Ctrl+K or Cmd+K to search from anywhere.

How it works

One sample job, step by step: what you see, and what Fido does behind it.

SampleClients import · clients.xlsx · Lincoln ISD

  1. Monday
    What you see: Dana K. opens the import menu on the Clients list and downloads the sample workbook.
    What Fido does: The workbook carries the organization's own dropdown values, color-coded headers and an example row, so the sheet matches the account.
  2. Monday
    What you see: Dana fills in her rows and puts a client's ID on one existing row.
    What Fido does: A row with an ID that Fido finds updates that record. Other clients are matched by email, and a row with no match is created.
  3. Tuesday
    What you see: Dana uploads the file and keeps working while a progress bar counts the rows.
    What Fido does: The import runs in the background and creates each record through the same service the screen uses, so the usual notifications and history entries fire.
  4. Tuesday
    What you see: An in-app notice and an email tell her the import finished with a few rows to fix.
    What Fido does: The person who ran the import gets both messages. The progress bar shows Partial Success with the rows processed, succeeded and failed.
  5. Tuesday
    What you see: Dana downloads the error report, fixes those rows and uploads again.
    What Fido does: The error file lists each failed row with its ROW NUMBER and ERROR MESSAGE, in the same CSV or XLSX format she uploaded.

Bring your own lists to a demo

A live walkthrough built around your kind of work.

Book a demoContact sales