A one off import copies a spreadsheet in once. Linking a live CSV is different: your map reads its locations from a published spreadsheet each time it loads, so editing the sheet updates the map without touching the editor.
When to link a live CSV
This suits a list that someone keeps in a spreadsheet and changes often: stallholders, a room booking list, a directory a colleague maintains. They edit the sheet, and the map follows. If your locations are stable, a plain import is simpler. See Add locations in bulk with a spreadsheet.
Publish the sheet as CSV
The link has to point at a CSV the map can fetch, not a private document. In a spreadsheet tool like Google Sheets, use its publish or export option to get a CSV link, the kind that ends in something like export?format=csv. The columns are the same ones the importer uses, so Download example in the CSV tab shows you every supported header.
Link it
-
Open the CSV tab
In the editor, go to the CSV tab. The top field is Link CSV file (published Google Sheet CSV, etc.).
-
Paste the link
Paste your published CSV link into the field.
-
Try it first
Click Test in preview to load the sheet into the preview without saving, so you can check the locations look right.
-
Save it
Click Save link to keep it. Then publish the map to apply the change.
Locations load live from the link, so the sheet must stay published and reachable for the map to show them.
Stop using the live link
Click Clear to remove the live CSV link. Publish again to apply. Your map then goes back to using the locations held in the editor.
id column so each row stays stable as the sheet is edited.