Add Multiple Seasonal Flu Shot Clinics

Using our Excel template file, you can send us many clinics at once.
Note: If you have just one clinic, or if the event details change for a clinic, please see How to Add Your Listing to Find A Flu Shot Clinic for more information.

As a way to deliver your clinic lists to the public as quickly as possible, we have automated the file submission process. Follow the steps below to add your list of clinics to the Find a Flu shot searchable database. Once you submit a file, and if your data is formatted correctly, then your clinics will be searchable by the public within seconds.

Steps:

1.

 Download the Flu Shot Clinic Template (Excel: 1KB). Open this file, then save it to your computer.
2.
 Add your clinic data into the Excel spreadsheet, using one line per clinic.
3.
 Submit the file using the Submission Form below.
  • Select your name from the vendor drop down list. If you do not see your vendor name there, enter it plus the contact name, phone number, email, etc.  This will allow MDH to review your clinic information and approve it.
  • Use the browse button to locate your spreadsheet file on your computer or network and select it.
  • Hit the Submit button
4. After you submit your list, we strongly encourage you to take just a minute and try to search for the clinic, much as consumers will be doing.  Use date ranges or ZIP codes that were on your list to ensure that you can find your clinics and that the information was loaded correctly.

Submission Form:

Vendor Name:
File to Upload:

Vendor Info ONLY if name does not appear in list above: (all fields required)

Vendor Name:
Contact Person:
Contact Phone:
Public Phone:
Contact Email:
Vendor URL:

About the Excel spreadsheet format

You must have your data formatted exactly as outlined below or else the file will be rejected.

Addresses will be verified using a special program so that we can provide accurate driving directions for consumers. Please ensure your addresses are correct. If our program cannot validate them, they will be rejected.

You will need to have your Excel spreadsheet in the following format:

Data Field Description
County Name of county
Clinic Name of store, clinic, school, church, LHP clinic, etc.
Street Street address
(Please verify the address by using Google Maps, Mapquest, Yahoo Maps, etc.)
City City
ZIP 5-digit ZIP
Date

Format mm/dd/yyyy (In Excel, format the dates by selecting Format --> Cells --> go to the Number tab, select Date under Category and under Type select 3/14/yyyy as shown below.)
Note: By formatting the date, according to the directions above, the spreadsheet will accept either a single or double digit month. A zero does not need to be entered before single digit months. screen shotscreen shot
Time

Format as 11:30 am - 4:00 pm
Cost

Exclude dollar sign
Age 0-3

yes/no
Age 4-8 

yes/no
Age 9 +

yes/no
Age 19 +

yes/no
Comments

250 characters, including spaces

 

 

Updated Monday, 22-Nov-2010 14:14:28 CST