Exporting From Google Sheets

It is easy to download a CSV from Google Sheets to upload to Magellan Data. The entire process takes less than 5 minutes.

Preliminaries

Your CSV file must have at least three columns in this order:

  1. ID: A unique identifier for each company (can be a CRM ID, account number, or any unique value)
  2. Company Name: The name of the company
  3. Website/URL: The company's website

Important notes:

  • Column names can be anything (e.g., "ID" or "Account ID", "Company Name" or "Account Name", "Website" or "URL"), but you must have column headers
  • For the website column, either format works: amazon.com  OR https://www.amazon.com  — we'll extract the domain automatically
  • Any rows missing a website will be skipped during processing
  • Your CSV can have more than three columns, but the first three must be ID, Company Name, and Website

Exporting from Google Sheets

If your data is in Google Sheets:

Before you export, make sure your columns are in the correct order:

  • Column A: ID
  • Column B: Company Name
  • Column C: Website/URL

To export:

  1. Open your Google Sheet
  2. Click File in the menu
  3. Select Download
  4. Choose Comma Separated Values (.csv)

Google Sheets will download a CSV file of your current sheet to your computer's Downloads folder.