How to Upload Facebook Business Locations Using a Spreadsheet
Upload Business Locations Using a Spreadsheet
You can add and edit Business Locations in Business Manager on Facebook using a spreadsheet.You upload an Excel, UTF-16 or CSV file.
To upload your Business Locations using a spreadsheet:
- Download Facebook spreadsheet template here.
- In the template, the Tips to fill this out tab gives helpful instructions.
Ex: how to format particular fields, explanation of our sub-categories.
If you have already created Facebook Pages representing your business locations, fill in the Existing Locations Template tab.
If any of these stores have now shut, put a Y in the Closed column.
- If you haven't created Facebook Pages, you can fill in the New Locations Template tab.
Tip: Some advertisers choose to export their business location data from Shopify, Magento or other tools, then reformat the information to fit this template. - Move the tab you've chosen to fill in to the 'tab 1' position in your spreadsheet. Our tool only reads the first tab.
- To upload the spreadsheet in Business Manager, open Business Locations (learn how). Click the Add Locations button in the top right.
- To upload the spreadsheet via your Facebook Page, use the Import Multiple Locations button. Learn how
- Choose Upload Locations.
- Click Choose File to upload your spreadsheet.
- If your upload is successful, you'll get a confirmation message. Click Save Changes to confirm.
If your spreadsheet contains any errors, you'll get a message letting you know how many locations have an error. You'll have the option to upload all the locations without errors or download your spreadsheet with instructions on what the errors are and how to fix them. You can then re-upload your spreadsheet.
You have now uploaded your Business Locations using a spreadsheet.
Related Articles
Add and Edit Business Locations in Business Manager
If your business or brand operates from multiple stores, dealerships, salons or restaurants, uploading details of these locations to Business Manager will help customers find you. It will also allow you to run ads tailored to each location. For ...Facebook Global Pages
What is a Global Page? Global Pages allow advertisers to provide localised versions of their content for their customers all over the world, but with one universal brand name, total fan count and vanity URL, and with global insights across their ...Managing Roles for Global Pages
Admins of the root Page can manage the roles for the Global Pages structure. On the root Page you can: Manage by adding, editing and removing people's roles. Organise the Global Page structure. People managing the root Page will also have access to ...Managing Your Facebook Location Pages
Facebook is becoming a place for local discovery; in fact, people on Facebook are likely already discussing your business on user-generated Facebook Pages. Setting up location Pages for your stores gives you more control over your brand and helps ...Location Images Guideline
Image Guideline While collecting photos for your locations, keep in mind the following guidelines! Format Photos must be in one of these formats: JPG, GIF, PNG Size Each photo must be smaller than 5MB. We recommend adding photos that are larger than ...