Spreadsheet Format
New customers can use the following starter templates to compile initial listing data.
Learn how to export your SOT
Starter Templates
The Rooftop Template and Professional Template both contain:
- Detailed instructions and resources
- Starter level and advanced level templates
- Correctly formatted examples for each field
- Color coding system designating mandatory fields
Categories
Download the latest list of categories available for Business Listings. See how these categories map to Google, Apple, Bing, Facebook, and more.
Hours of Operation
When entering hours of operation for each day of the week, use the following formatting:
Hours of Operation | Example Input |
---|---|
Open (e.g., 9am-6pm) | 09:00-18:00 |
Closed | x |
Open 24 Hours | 00:00-00:00 |
Split Hours (e.g, 9am to 12pm and 3pm to 6pm) | 09:00-12:00;15:00-18:00 |
“By Appointment Only” is not a valid input as it is not accepted by listings sites like Google.
Photo Requirements for Google My Business (GMB)
Google My Business has specific requirements for photos that are added to your business listings through the platform, which then update on their website. Please review the following:
GMB Photo Requirements | Specifications |
---|---|
Logo | Recommended Dimensions: 250 x 250 pixels Minimum Dimensions: 250 x 250 pixels (!) Maximum Dimensions: 5500 x 5400 pixels Max File Size: 7 MB Image Formats: JPG or PNG |
Cover | Recommended Dimensions: 1080 x 608 pixels Recommended Aspect Ratio: 16:9 (!) Minimum Dimensions: 480 x 270 pixels (w/h) (!) Maximum Dimensions: 2120 x 1192 pixels (!) Max File Size: 2 MB Image Formats: JPG or PNG |
Additional | Recommended Dimensions: 720 x 720 pixels Minimum Dimensions: 250 x 250 pixels (!) Maximum Dimensions: 5200 x 5300 pixels Max File Size: 4 MB Image Formats: JPG or PNG |
Photo Requirements for Facebook
Facebook has specific requirements for photos that are added to your business listings through the platform, which then update on their website. Please review the following:
Facebook Photo Requirements | Specifications |
---|---|
Profile | Recommended Dimensions: 720×720 pixels Recommended Aspect Ratio: 1:1 Minimum Dimensions: 100 x 100 pixels (!) Max File Size: 12 MB Image Formats: JPG |
Cover | Recommended Dimensions: 820 x 312 pixels Recommended Aspect Ratio: 2:7:7 Minimum Dimensions: 480 x 270 pixels (w/h) (!) Max File Size: 4 MB Image Formats: RGB, JPG, or PNG |
Photo Requirements for Bing
Bing has specific requirements for photos that are added to your business listings through the platform, which then update on their website. Please review the following:
Bing Photo Requirements | Specifications |
---|---|
Default Photo | Recommended Dimensions: 1024 x 768 pixels Required Aspect Ratio: 4:3 (!) Minimum Dimensions: 480 x 360 pixels (!) Max File Size: 10 MB |
Physician Requirements
In addition to the required fields for all listing sources (as shown in the template), the following fields are required for physician listings only:
Column | Requirement | Example Input |
---|---|---|
first name | - | Jane |
last name | - | Smith |
degree | - | MD |
npi | National Provider Identifier | 12121212121 |