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.