Skip to main content

Uploading Street Address Data (Point Locations)

Uploading a spreadsheet with street addresses lets you visualize point-level data on a map.

Kaitlyn Foster avatar
Written by Kaitlyn Foster
Updated over a week ago

Also known as geocoding, assigning street address data to points on a map is perfect for building locations, service calls, or case logs.

Before you get started: Make sure your file meets format requirements. Not sure? Check out this guide.

📁 Step 1: Upload Your File

  • Go to Upload data from the left-hand menu.

  • Drag and drop your file into the big green box or click Browse computer to upload.

  • Supported formats include CSV, GeoJSON, SHP, XML, GML, and GDB (up to 50MB).

  • File must include at least one column with street addresses (e.g., 4746 Fairmount Ave).

🧭 Step 2: Match by Street Address

  • mySidewalk will scan your file and automatically detect that you’re using street address matching.

  • If this option isn’t automatically selected, you can always select the “Street Address” option by clicking on the “Change method” button.

✍️ Step 3: Select Address Fields

  • Choose the column (or columns) that holds your street address (e.g., Address, Street Address).

  • Add geographic detail if needed — a city or state that applies to all rows (e.g., “Kansas City Missouri”) — so it forms a full street address.

  • A search preview table shows how mySidewalk is building the addresses it will search for.

🗺️ Step 4: Confirm Matches on the Map

Once your addresses are matched to coordinates, you’ll see them mapped.

  • Use Map View to zoom and inspect coverage.

  • Switch to Table View to spot any missing or unmatched addresses.

  • Click Next when you're ready.

✅ Step 5: Confirm layer info & save

  • Add a layer name and description.

  • Check that numeric variables and any additional fields are accurate.

    • Consider updating labels so the label and capitalization is how you'd like them to show up in visualizations. Then you won't have to update labels manually when you build data components.

  • Click Done to save your data.

You did it!

After uploading, you’ll land on the newly created layer’s page where you can:

  • Add metadata or tags

  • Update the label names

  • Download the layer

  • Immediately start mapping, exploring, or sending to a report or dashboard.

Did this answer your question?