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!
George is not affiliated with Moz.
|Read more here:|
Only Fill Out This Column
|Store Code||If you have multiple locations, put a store code here. 60 characters max, this store code should never change.||MyBusiness_0001|
|Business Name||Business 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|
|Address Line 1||Line 1 of address||300 East 47th|
|Address Line 2||Line 2 of address||Suite 1|
|State||2-Letter state address||IL|
|Country Code||US||Country Code (Moz only works in the U.S. for now so it's just this)||US|
|Postal Code||5-digit Zip Code||60653|
Primary Phone Number
|LOCAL phone number (no 800 numbers); best format for numbers is as it's written in the example ==>||(773) 285-2900|
|Additional Phone||If you have another number, apart from an 800 number, mobile, or fax you can leave it here. You'll probably leave this blank.|
|Mobile Phone||If you have a specific mobile number. Again, this will probaby be blank.|
|Fax Number||You fax number in case you occassionally serve customers from 1996.||(773) 555-1234|
|Home Page URL||If you have multiple locations, use that location's contact page; If you just have one, use your homepage.||http://www.raysmusic.biz/calumet-city|
|You need an email address. If you have an @yourdomain.com that's firstname.lastname@example.org|
|Sunday hours||HIGHLY 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
as your hours for every day of the week.
|Image 1 URL||You 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
|Image 2 URL||http://www.raysmusic.biz/images/piano.jpg|
|Image 3 URL|
|Image 4 URL|
|Image 5 URL|
|Payment Types||Enter payment types, separated by commas.||cash, check, visa, mastercard|
|Primary Category||Most Relevant Category picked from here: https://moz.com/local/categories||Music Store|
|Additional Categories||Separated 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|
|Description||MINIMUM 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.|
|Latitude||Latitude, if you want to add this.||41.80929852|
|Longitude||Like latitude, but the other way.||-87.61956234|
|Neighborhood||Add the neighborhood if you want like "Downtown" or "Queen Anne".||Calumet City|
|Business Type||CHOOSE ONLY FROM THE FOLLOWING: "Brick and Mortar", "Service Area", or "Home Based"||Brick and Mortar|
|Containing Location||If it's another building like a mall or another store, write that here.||Westfield Mall|
|Logo URL||URL 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|
|Display URL||Some 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|
|Social URL 1||Here, you're going to link to all your social network pages; like Facebook, Twitter, etc.|
One URL per cell.
|Social URL 2||http://www.twitter.com/raysmusic|
|Social URL 3||http://plus.google.com/+raysmusic|
|Social URL 4|
|Social URL 5|
|Promotional URL 1||If you have a menu, product list, discount offer, or something else like that online, list those URLs here. Otherwise leave it blank||http://www.raysmusic.com/product-list.html|
|Promotional URL 2|
|Promotional URL 3|
|External Media 1||Links 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|
|External Media 2|
|External Media 3|
|External Media 4|
Certifications & Specialities
|Certifications or specialities, separated by comma.||Certified Reseller|
|Brands Carried||Brands carried, if you want to list those.||Fender, Gibson, Moog|
|Tagline||Tagline, max 150 characters. Recommended.||Shake your tail feather at Ray's|
|Out of Business||If you're closing a business mark, a Y here otherwise leave it blank|
|Category Overrides||Moz 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|
|Exclude Engines||You'll most likely leave this blank too|