All Tutorials

How to Import Directory Listings from a Spreadsheet

8 min read
Beginner
On this page 4 sections
  1. Set Up Your Fields First
  2. Prepare Your Spreadsheet
  3. Upload and Map Columns
  4. Import

Got a spreadsheet full of listings? Import them all at once instead of adding them one by one.

Step 1: Set Up Your Fields First

Before importing, set up the fields you want each listing to have. This makes it easier to match your spreadsheet columns to the right places.

Go to Listing Fields and add any fields you need—phone numbers, website links, categories, etc.

For help with this step, see How to Set Up Custom Fields.

Once your fields are ready, come back here.

Step 2: Prepare Your Spreadsheet

Your file needs to be a CSV (comma-separated values). Most spreadsheet apps can export to this format:

  • Google Sheets: File → Download → Comma-separated values
  • Excel: File → Save As → CSV
  • Numbers: File → Export To → CSV

Requirements:

  • First row should be column headers
  • One row per listing
  • Include a column for the listing name (required)

Example:

Name Address Phone Website Category
Joe's Coffee 123 Main St, NYC 555-1234 joescoffee.com Coffee
The Book Nook 456 Oak Ave, LA 555-5678 booknook.com Books

For tags or categories with multiple values, separate them with commas: Coffee, Breakfast, Wifi

Step 3: Upload and Map Columns

Go to Manage Listings → Import from CSV and upload your file.

You'll see your spreadsheet columns listed. For each column, select which field it should map to:

  • Name → your listing name column (required)
  • Address → your address column (for map placement)
  • Description → your description column
  • Your custom fields → match to your spreadsheet columns
  • Skip → ignore columns you don't need

A preview updates as you map, so you can check everything looks right.

Step 4: Import

Click Import to start. You'll see a progress bar as listings are added.

When it's done, go to Manage Listings to see everything. Click any listing to edit it or add more details.

Need to add more listings later? Just repeat this process with a new CSV file—new listings will be added alongside existing ones.

Ready to get started?