Log in Sign up

Importing Interactions Using a CSV File

CSV files are just Excel files saved with a particular setting. CSV stands for "comma separated values."

How to prepare your CSV file to upload into Karani

When you're importing interactions using a CSV file, it's most helpful to have a CSV with the column titles Donor ID, interaction title, interaction type, and the date of interaction.

If you do not have a Donor ID provided by your organization you can use anything unique to that contact, such as an email.

Interactions CSV

Once your spreadsheet is ready, go to "file" and click "save as."

Change the "Format" to "Comma Separated Values (.csv)" then click "Save."

Your CSV is ready to be uploaded to Karani.

How to import your interactions using a CSV file into Karani

  1. Go to the import page in Karani.

  2. Click on "interactions" under the heading ".CSV Importer"

    CSV Importer

  3. Click "choose file" to the right of where it says "Upload CSV"

    Upload Interactions CSV General

  4. Navigate your computer to find the CSV file you prepared to upload into Karani.

    Choose the CSV file you want to upload, click "Open" then click "Submit" to upload the file to Karani.

  5. If the CSV was uploaded correctly, you'll be taken to this screen:

    CSV Interaction Dropdown

    Match the fields on the right hand side using the dropdown boxes (donor ID = organization ID) with the fields on the left hand side.

    Here's what a completed version of the above screenshot looks like:

    CSV Interaction Dropdown Filled

  6. Click "Process CSV" and you're done!

For: https://karani.co/user-guide/importing-information/importing-interactions-csv-file

Current copy under "How to prepare your CSV file to upload into Karani" is incorrect. There is no "donor name" field when importing interactions.

Change to: When you're importing interactions using a CSV file, it's most helpful to have a CSV with the column titles Donor ID, interaction title, interaction type, and the date of interaction.

If you do not have a Donor ID provided by your organization you can use anything unique to that contact, such as an email.