Cavuno
Sign InSign Up

CSV Import and Export

Import companies and subscribers via CSV. Export subscriber data for backup or use in other tools.

AJ
By Abi Tyas Tunggal and Jack Walsh

Import companies and subscribers into Cavuno using CSV files. Export your subscriber list for backup and analysis. This is the fastest way to migrate from another platform or manage data in bulk.

Import companies

Add employer profiles in bulk by uploading a CSV. This is useful when migrating from another job board or seeding a new board with companies.

Prepare your CSV

Create a CSV file with a header row. Column names are case-insensitive.

ColumnRequiredDescription
nameYesCompany name
is_publishedYes*Set to true, 1, or yes to import. Rows without a truthy value are skipped.
site_urlNoCompany website URL (used for domain deduplication)
logo_urlNoURL to the company logo (downloaded and stored automatically)
taglineNoShort summary displayed in listings (truncated to 280 characters)
description_htmlNoFull company description in HTML
twitter_handleNoX/Twitter handle, username, or full URL
linkedin_urlNoLinkedIn profile URL
facebook_urlNoFacebook page URL
emailNoContact email (stored but not displayed publicly)
tax_idNoTax identifier

Unrecognized columns are ignored. Column order does not matter.

How fields are processed

Website URLs are normalized. Bare domains like example.com become https://example.com.

The tagline is truncated to 280 characters with an ellipsis if it exceeds the limit.

X/Twitter accepts a handle (@acmecorp), bare username (acmecorp), or full URL. Handles are converted to https://x.com/acmecorp.

Logo images are downloaded from the provided URL and stored in Cavuno's asset storage. If the download fails, the company is created without a logo.

Domain deduplication prevents importing two companies with the same website domain. The first occurrence wins, and duplicates are skipped.

Example CSV

csv
name,site_url,tagline,is_published,twitter_handle
"Acme Corp",https://acme.com,"Building better widgets",true,@acmecorp
"Globex Inc",https://globex.com,"Innovation at scale",true,globex

Upload the file

  1. Go to Companies in the sidebar.
  2. Click Import.
  3. Select your .csv file.
  4. Click Import to start.

The import runs in the background. Large files process without blocking the UI.

Import job alert subscribers

Bring an existing email list into Cavuno so subscribers start receiving job alert digests.

Prepare your CSV

ColumnRequiredDescription
emailYesSubscriber email address
frequencyNoAlert frequency: daily or weekly (defaults to weekly)
unsubscribedNoAny non-empty value skips the row

The frequency column also accepts aliases like everyday, day, week, biweekly, and 2x/week. Unrecognized values default to weekly.

Example CSV

csv
email,frequency
jane@example.com,daily
bob@example.com,weekly

Upload the file

  1. Go to Job Alerts in the sidebar.
  2. Click Import.
  3. Select your .csv file.
  4. Click Import to start.

Imported subscribers are auto-confirmed. No confirmation email is sent. They begin receiving alerts on the next scheduled digest. Only import subscribers who have given you consent.

Export job alert subscribers

Download your full subscriber list as a CSV for backup, analysis, or import into other tools.

  1. Go to Job Alerts in the sidebar.
  2. Click the download icon in the toolbar.
  3. Your browser downloads job-alert-subscribers-{board-slug}.csv.

Exported columns

ColumnDescription
subscription_idUnique identifier
emailSubscriber email address
statusCurrent status: active, pending_confirmation, unsubscribed, or paused
confirmedWhether the subscriber confirmed their email
is_activeWhether the subscription is active
confirmed_atTimestamp of email confirmation
unsubscribed_atTimestamp of unsubscribe (empty if still subscribed)
last_digest_sent_atWhen the last alert email was sent
preferencesAlert preferences and frequency
created_atWhen the subscription was created
updated_atWhen the subscription was last modified

The export includes all subscribers regardless of status: active, pending, and unsubscribed.

File format requirements

  • Format: Standard CSV with comma delimiters.
  • Encoding: UTF-8 (files with a BOM are handled automatically).
  • Header row: The first row must contain column names.
  • Quoting: Wrap values containing commas or quotes in double quotes. Escape literal quotes by doubling them ("").
  • Extension: .csv.

Troubleshooting

Company import skips rows

  • Missing name: Every row needs a name value.
  • Not published: Rows where is_published is missing, empty, false, 0, or no are skipped.
  • Duplicate domain: Two rows with the same website domain are deduplicated (the first occurrence wins). Companies whose domain already exists on your board are also skipped.
  • Logo download failed: The company is still created without a logo. Check that the logo_url points to a publicly accessible image.

Subscriber import skips rows

  • Invalid email: Emails that fail validation are skipped.
  • Unsubscribed flag: Rows with a non-empty unsubscribed value are intentionally skipped.

General issues

  • Wrong file type: Only .csv files are accepted. Convert .xlsx or .tsv files to CSV first.
  • Encoding errors: Save as UTF-8. Some spreadsheet applications default to other encodings.
  • Empty file: The file must contain at least a header row and one data row.

Frequently asked questions