CSV Template

Moz Local locationsin the right order.

Collect every location's name, address and phone with a form that checks each row, and download a CSV with its columns in the order Moz Local's bulk upload reads them.

Moz Local's column orderTwo-letter country codesTry it free

Moz Local Locations

Try the template with up to 3 locations

What You'll Collect

Business Name

String
*Required

The name exactly as it should appear on every listing.

Address Lines 1 & 2

String
*Required

Line 2 is for a suite or unit. It can be blank, but the column is always included, as Moz Local needs.

City

String
*Required

The town or city of the location.

State or Province

String

Where the country uses one.

Postal Code

String
*Required

Kept as text, so leading zeros such as 02134 stay.

Country

String
*Required

Exactly two letters, such as US, GB or CA. Anything else is flagged.

Primary Phone

Phone
*Required

With the country code, such as +1 212 555 0100. Letters and too few digits are flagged.

Moz Local Plan Level

String
*Required

The plan for this location, written as it appears in your Moz Local account.

Need more than three locations?

Collect up to a thousand locations instead.

The free template is limited to three rows so you can try the workflow. Create your own Import Builder form when a client or franchise team needs to send you every location.

Create your own form

Up to 1,000 rows

Enough for multi-location brands and franchise networks.

Moz Local's column order

Columns come out in the order Moz Local reads them, blank address line 2 included.

Checked as they type

Missing addresses, bad country codes and phone numbers are fixed before you get the file.

Reusable forms

Send the same form to every new local SEO client.

How it works

From location list to bulk upload in three steps.

01

Collect

Send the form to whoever knows the locations: a client, a franchise manager or each branch.

02

Complete

They type, paste or import their list. Problems are highlighted until every row is fixed.

03

Download

Download the CSV and upload it in Moz Local's bulk location upload.

Why use a form?

One bad row can stop a whole upload.

Moz Local reads the columns by position, so a deleted or reordered column shifts every value into the wrong field. Clients also write countries in full and leave out phone country codes.

A form fixes those problems where they start, with the person who knows the right answer.

Columns out of order

People delete empty columns or insert new ones. The form's export always keeps Moz Local's order.

Missing required fields

Every location needs a name, address, city, postal code, country, phone and plan before the CSV can be downloaded.

Format mistakes

Country codes must be two letters and phones must be real numbers, checked as they're typed.

Moz Local bulk upload

Uploading locations to Moz Local

Moz Local distributes a business's name, address and phone number to directories and data aggregators, and keeps them consistent. Agencies and multi-location businesses add locations in bulk by uploading a CSV.

Moz Local's bulk upload expects nine columns in a fixed order: business name, address line 1, address line 2, city, state or province, postal code, a two-letter country code, the primary phone with its country code, and the Moz Local plan level. Address line 2 must stay in the file even when it's empty.

Consistent name, address and phone data is the whole point of local listings, so mistakes in the upload spread everywhere. This form checks each location as it's entered and always exports the columns in Moz Local's order.

Many of the same details go into a Google Business Profile bulk upload, which has its own template with store codes, categories and opening hours.

Need a CSV form of your own?

Create a custom Import Builder form with your own fields, validation and row limits.

Get started
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by Moz. Moz and Moz Local are trademarks of their owner.