The Power Add On allows you to import CSV files with several options. One of those options is “duplicates handling”. Duplicates handling determines how to deal with locations in your CSV file that may match pre-existing locations on your site.
There are several options available for duplicates handling including Add, Skip, and Update.
Location Imports are handled via a CSV file for users that signed up for the MySLP Power service or are using the WPSLP Power Add On.
CSV Import Format
Getting the proper CSV format can be a challenge when using spreadsheet apps like Excel or Numbers. Here are some tips to getting a valid CSV format out of a spreadsheet app:
Make sure you always have a header row. That tells the import process what data is in each column. The column headers have meaning, so be precise.
When a cell is a text field that STARTS WITH A LEADING ZERO, make sure you explicitly mark the cell as text. The easiest way to do this is to type a single apostrophe then the number when adding data to the cell as in ‘01886 for the zip code 01886.
Always export with UTF-8 support enabled.
Export to a CSV format. Comma delimited not tab delimited and quoted strings if given the option.