Moz Local CSV Populator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCD
1
Instructions:
1. Go to File > Make a copy... in order to use the doc.
2. Fill out the column labeled "Only Fill Out This Column."
3. Required fields are highlighted in green. Otherwise fill out as much as you can. Leave the rest blank.
4. Go to "Paste this" tab and copy all of Row 3.
5. Paste as text into the Moz Local CSV .
6. Rinse and repeat for multiple locations.
7. Go to Moz Local and upload away!
http://moz.com/local
http://bit.ly/ez-moz-local
@georgefreitag
@Portent

George is not affiliated with Moz.
2
Read more here:
https://moz.com/local/help/documentation
http://professionalgeorge.org/tools.php#moz-local-helper
3
Field Name
Only Fill Out This Column
DescriptionExample
4
Store CodeIf you have multiple locations, put a store code here. 60 characters max, this store code should never change.MyBusiness_0001
5
Business NameBusiness name, as it would appear on a letter or in a phone book. Don't stuff it with keywords or location stuff.Ray's Music Exchange
6
Address Line 1Line 1 of address300 East 47th
7
Address Line 2Line 2 of addressSuite 1
8
CityCityChicago
9
State2-Letter state addressIL
10
Country CodeUSCountry Code (Moz only works in the U.S. for now so it's just this)US
11
Postal Code5-digit Zip Code60653
12
Primary Phone Number
LOCAL phone number (no 800 numbers); best format for numbers is as it's written in the example ==>(773) 285-2900
13
Additional PhoneIf you have another number, apart from an 800 number, mobile, or fax you can leave it here. You'll probably leave this blank.
14
Mobile PhoneIf you have a specific mobile number. Again, this will probaby be blank.
15
Fax NumberYou fax number in case you occassionally serve customers from 1996.(773) 555-1234
16
Home Page URLIf you have multiple locations, use that location's contact page; If you just have one, use your homepage.http://www.raysmusic.biz/calumet-city
17
EmailYou need an email address. If you have an @yourdomain.com that's ideal.ray@raysmusic.biz
18
Sunday hoursHIGHLY RECOMMENDED:

Enter your open and close time using AM/PM or 24 hour format.
Leave it blank if it's not open that day.

If you're open 24/7 use
12:00AM-11:59PM
as your hours for every day of the week.
19
Monday hours10:00:AM-7:00PM
20
Tuesday hours10:00:AM-7:00PM
21
Wednesday hours10:00:AM-7:00PM
22
Thursday hours10:00:AM-7:00PM
23
Friday hours10:00:AM-7:00PM
24
Saturday hours10:00:AM-1:00PM
25
Image 1 URLYou can link to up to 5 images from your site. These are sometimes used in online directories. These could be pictures of the front of your business or an interior shot or a picture of a product.

Be sure you're linking right to the image file that ends in .jpg, .gif, .png or .jpeg
http://www.raysmusic.biz/images/ray.jpg
26
Image 2 URLhttp://www.raysmusic.biz/images/piano.jpg
27
Image 3 URL
28
Image 4 URL
29
Image 5 URL
30
Payment TypesEnter payment types, separated by commas.cash, check, visa, mastercard
31
Primary CategoryMost Relevant Category picked from here: https://moz.com/local/categoriesMusic Store
32
Additional CategoriesSeparated by commas; You need to pick from these categories: https://moz.com/local/categories

If you don't pick from that list, Moz will throw you an error.
Musical Instrument Store, Used Musical Instrument Store, Musical Instrument Repair Shop
33
DescriptionMINIMUM 250 CHARACTERS. Moz won't accept the spreadsheet if it's any shorter. Also, I recommend typing rather than pasting it in since Moz will give you an error if there's any non-ASCII characters in this field.

Total pain, I know.
Welcome to Ray's Music Exchange. We have a strict policy concerning the handling of the instruments. An employee of Ray's Music Exchange must be present. Come on in today and we'll throw the black keys in for free.
34
LatitudeLatitude, if you want to add this.41.80929852
35
LongitudeLike latitude, but the other way.-87.61956234
36
NeighborhoodAdd the neighborhood if you want like "Downtown" or "Queen Anne".Calumet City
37
Business TypeCHOOSE ONLY FROM THE FOLLOWING: "Brick and Mortar", "Service Area", or "Home Based"Brick and Mortar
38
Containing LocationIf it's another building like a mall or another store, write that here.Westfield Mall
39
Logo URLURL of the logo. Again, make sure's to the image file. It's best to use a square image.http://www.raysmusic.biz/images/logo.jpg
40
Display URLSome search engines let you use a "vanity url" or "pretty url" you want that to be seen instead of the actualy one. It'll still go to the URL above.http://raysmusic.biz/calumet-city
41
Social URL 1Here, you're going to link to all your social network pages; like Facebook, Twitter, etc.

One URL per cell.
http://www.facebook.com/rays.music.exchange
42
Social URL 2http://www.twitter.com/raysmusic
43
Social URL 3http://plus.google.com/+raysmusic
44
Social URL 4
45
Social URL 5
46
Promotional URL 1If you have a menu, product list, discount offer, or something else like that online, list those URLs here. Otherwise leave it blankhttp://www.raysmusic.com/product-list.html
47
Promotional URL 2
48
Promotional URL 3
49
External Media 1Links to videos, infographics, or anything else like that. Leave it blank if you don't have anything like that.https://www.youtube.com/watch?v=rN5V-6yCbpg
50
External Media 2
51
External Media 3
52
External Media 4
53
Certifications & Specialities
Certifications or specialities, separated by comma.Certified Reseller
54
Brands CarriedBrands carried, if you want to list those.Fender, Gibson, Moog
55
TaglineTagline, max 150 characters. Recommended.Shake your tail feather at Ray's
56
Out of BusinessIf you're closing a business mark, a Y here otherwise leave it blank
57
Category OverridesMoz will let you override the primary category for a directory. Your'e probably going to want to leave this blank but if you want to learn more, visit this link for a list of all categories: https://moz.com/local/help/documentation
58
Exclude EnginesYou'll most likely leave this blank too
Loading...
Main menu