How the Import Data tool works
The Import Data tool lets you make updates in bulk in the application itself (as opposed to using an API).
Use the Import Data tool:
-
Access the page where you want to perform bulk updates.
-
Click Import Data.
Note that on some pages, the button is labeled Import instead of Import Data.
The Import Data dialog opens.
-
Select the data you want to import from the Import Data menu.
Options vary based on the page you are on.
-
Export Current Values for the selected import data.
The data downloads in the selected format (CSV, Excel, or tab delimited).
-
Open the exported file.
-
You can do the following in the file to make bulk updates.
In the Action column:
-
Enter Edit and update values for the corresponding site.
-
Enter Add and enter values for a new site on the corresponding row.
-
Leave blank to keep the existing values for the corresponding site.
-
-
Save the file after making your updates.
-
Go back to the Import Data dialog click Choose File.
Make sure the format (CSV, Excel, or tab delimited) matches the file in which you made your edits.
Your file explorer opens.
-
Open the updated file.
The file appears in the Import Data dialog.
-
Click Import.
A dialog opens, prompting you to validate and confirm the changes made to your sites.
-
Click Continue.