Spreadsheets
Import and map Excel, CSV and Google Sheets data for location-based visualization.
Last updated
Was this helpful?
Import and map Excel, CSV and Google Sheets data for location-based visualization.
Last updated
Was this helpful?
Tabular data such as spreadsheets can reference geography in many forms: explicitly with lat/lon points and geometries, or implicitly with zip codes, place names, or street addresses.
Uploads can include geographic data in unprojected decimal degrees latitude and longitude
Geographic fields should be given easy-to-find names, such as:
geometry, wkt, or geom_wkt
x & y
lat & lon, latitude & longitude, or lat & lng
Whole geometries must be in one of these formats:
examples: POINT(-122 37), LINESTRING (-122 37, -123 38)
Hex-encoded Well Known Binary
example:'01010000000000000000805ec00000000000804240'
GeoJSON Geometry Objects
example: {'type': 'Point', 'coordinates': (-122.0, 37.0)}
Felt uses AI to identify the geometry columns in your data but we don’t always get it right first time. Fortunately, you can always pick the right ones - even if the upload failed!
Simply open the data table, and click spreadsheet settings to select the appropriate columns and map them to the right field types.
Selecting address columns will result in Geocoding Addresses, while country names or ZIP codes will result in Geomatching Regions.
Sometimes, our data doesn’t have explicit coordinates, such as latitudes and longitudes. Instead, we might have implicit geospatial data, such as names of street addresses. Geocoding is the process of converting address data into points.
Felt can infer address data for up to 10,000 addresses per upload.
Address fields should be given easy-to-find names, such as:
address for single fields with complete address
number & street for house numbers and street names
city or locality for place names
zip for postal code
state, region, or province for first-order administrative divisions like U.S. states
country for countries
Geocoding isn’t a perfect process. Much like a search engine, sometimes you might not find exactly what you’re looking for, depending on both your input and the data that’s available.
Fortunately, Felt lets you review the quality of your geocoding upload, and also download the results so you can fine-tune your input if needed.
You can toggle the Geocoding Results any time you want from the table view by clicking "See full report" in the Found column and even download the results to fix issues and reupload
Tables often reference countries, states, or other regions without including the geometry themselves. Historically, you’d have to join this data with other datasets to work with it on a map. Felt does this automatically with Geomatching.
Data will be checked for the geographic regions listed below and converted to polygon geometries when possible. Optionally, hints present in the column name can be used to choose among valid matches, such as “zip” used to name a column of U.S. ZIP codes.
Countries
Names: United States, Ukraine
ISO 3166-1 alpha-2 codes: US, UA
ISO 3166-1 alpha-3 codes: USA, UKR
country, nation, adm0, admin0, admin-0
Global First-Order Admin Areas
Names: California, Kiev
ISO 3166-2 codes: US-CA, UA-32
Admin-1 codes: USA-3521, UKR-321
state, province, adm1, admin1, admin-1
Global Time Zones
Names: America/Los_Angeles, Europe/Kyiv
tz, tzinfo, timezone, time zone
EU Statistical Units (NUTS 1)
Names: Thüringen, Αττική
NUTS codes: DEG, EL3
state, province, region, nuts
EU Statistical Units (NUTS 2)
Names: Lazio, Θεσσαλία
NUTS codes: ITI4, EL61
state, province, region, nuts
EU Statistical Units (NUTS 3)
Names: Eure-et-Loir, Essex Thames Gateway
NUTS codes: FRB02, UKH37
state, province, region, nuts
EU Local Admin. Units (LAU)
Names: Eggendorf im Traunkreis,Čejč LAU codes: AT_41004, 586099 GISCO
codes: AT_41004, CZ_586099
municipio, municipality, commune, comuni, gemeinde, lau
US States
Names: California, New York
Postal codes: CA, NY FIPS codes: 06,04000US36, 0400000US48
state
US Counties
FIPS codes: 06001, 05000US36061, 0500000US48453
county
US CBSAs
Names: San Francisco-Oakland-Berkeley, CA, New York-Newark-Jersey City, NY-NJ-PA Metro
Area FIPS codes: 41860, 33000US35620,
3300000US12420
cbsa
US Zip Codes
ZIP codes: 94612, 06511
zip, zipcode, postcode
US Census Tracts
FIPS codes: 06001402900, 14000US09170141900, 1400000US48453001103
tract
Sometimes, you want to change the geometry drawn by Felt to customize the way your data is shown on the map. Making these changes allows you to color-code the data the way you need it displayed.
Choosing different columns in a spreadsheet to ensure the right location data is used. See Choosing Columns for more information.
Change the points on a map to fill up their associated province, state, or zip code region
Symbolize an area or region as a point instead
Being able to change the default geometry selected by Felt based on different data attributes is possible because Felt can find the location of data using a number of different methods including: -
Addresses (this process is called geocoding)
Provinces, states, zip codes, countries (this process is called geomatching)
Latitude & Longitude coordinates
To change the selected geometry:
Select the uploaded layer
Click the "View Data" icon. This will open a view of the CSV in Felt
Click the gear icon in the table to open spreadsheet settings
Select the columns you want Felt to use for the geometry for example, if addresses were used you would get points but if you want polygons you can instead choose the option to draw features with a State attribute
For reference
Coordinates and Addresses types are typically used for drawing points.
Natural Earth v1, US Census, 2020, and Eurostat, 2021 types should be used for drawing areas/polygons.
WKT and WKB are more advanced types that can be used for drawing points, lines, or areas.
Click Update spreadsheet to get the new results
See the Troubleshooting page for common upload failures and how to fix them.
United States point of view
States, provinces, etc.
