How to import locations & service lines in bulk

If you would like to import both your locations and service lines at once, this article has you covered.

If you'd like to bulk import new locations & service lines at once, or edit existing data in bulk, you'll want to utilize the 120Water Locations & Service Lines template or your state specific template (if available). 

We recommend this process if you are creating or updating more than 100 records at once, or if you already have existing spreadsheets pulled from billing systems, work order systems, etc. 

Watch the video below to learn how this process works: 

💡120Water Pro Tips:

• It's critical that you do not edit the column headers on the 120Water template. This will cause your import to fail. 
• The only required fields are street address, city, and zip code. Other fields may be required for your inventory submission, however, these are the only required fields for import. 
• It's also important to follow the guidelines listed in the 120Water Template Documentation. This may look daunting, but only focus on the fields you are working to complete such as address and material classification. That makes this more digestable. You'll need to make sure your data is entered exactly as prescribed in this guidance to reduce errors. 
• Depending on the file size and number of customers importing at once, it may take up to 30 minutes for the import to complete. If you've waited longer than that, reach out to support@120water.com and our team can investigate any issues that may be occurring.