How Do I Add Excel Data to GIS? in QGIS
Somebody sent me a message last week that stuck with me: “I have 400 rows of plot owners in Excel, with coordinates my surveyor gave me, and I just want to SEE them on a map. Why is this so hard?” That question is the whole article, honestly. Because the answer isn’t complicated the problem is that most tutorials teach you to click buttons without ever explaining why the buttons exist, so the moment something goes wrong (and something always goes wrong the first time), you’re stuck.
So let’s not do that here. I’m going to walk you through this the way I’d walk a student through it in a GIS lab session, or a client through it over a screen-share slowly enough that you understand what’s actually happening to your data at each step, not just where to click.
Why Excel Data Doesn’t “Just Appear” on a Map
Here’s the thing people miss first: Excel doesn’t know what a coordinate is. To Excel, a column labelled “Latitude” with the value 5.0378 is just a number exactly as meaningless to the spreadsheet as a column of phone numbers or exam scores. GIS software is what actually reads that number, understands it as a position on Earth’s surface, and converts it into a visible point on a map.
So “adding Excel data to GIS” really means one of two separate things, and knowing which one you need saves you a lot of frustration:
Your Excel sheet has coordinates (X/Y, or latitude/longitude) or addresses, and you want GIS software to plot each row as a point on a map. This is the most common request, and it’s what most of this guide covers.
Your Excel sheet has attribute data (names, values, categories) tied to a location that already exists as a shapefile or boundary like a list of plot owners that corresponds to parcels already mapped and you want to join that table to the existing spatial layer instead of creating new points.
Different goal, different method. Confusing the two is honestly where half the “my data isn’t showing up” frustration online comes from.
Preparing Your Excel Data Before You Touch Any GIS Software
This is the step almost every tutorial rushes past, and it’s the step that determines whether the next ten minutes are smooth or miserable.
Put your coordinates in separate numeric columns one for X (longitude) and one for Y (latitude), or clearly labelled Easting/Northing if you’re using a projected system. Don’t combine them into one cell like “5.0378, 7.9227.”
Format the coordinate columns as Number, not Text. This trips up more people than anything else on this list. If a coordinate is stored as text, GIS software either rejects it outright or, worse, silently misreads it.
Remove degree symbols, N/S/E/W letters, and any other formatting characters from the coordinate cells. A value like 5°02’16″N will not work directly it needs to be in plain decimal degrees (5.0378) unless you’re specifically using a tool built to parse degrees-minutes-seconds format.
Keep your data in the first worksheet/tab of the Excel file. Most GIS software, ArcGIS Pro included, reads from the first sheet by default and will ignore data sitting on a second tab unless you specifically point it there.
Give every column a clear, single-word-style header with no merged cells, no blank header rows above your data, and no special characters in the column names.
Check for blank rows in the middle of your data. A single empty row can cause the import to stop early or behave unpredictably.
Before you import anything, sort your coordinate columns from smallest to largest and scan for anything wildly out of range a latitude of 50.3789 when the rest of your data sits around 5.0378 is almost always a typed decimal point in the wrong place, and catching it now saves you from chasing a “missing point” for twenty minutes later.
Now that your data is clean, let’s actually get it onto a map and because different people reading this use different software for different reasons, I’ll walk through the three realistic paths: ArcGIS Pro (industry standard, often required for professional/government work), QGIS (free and increasingly the default for students and independent practitioners across Nigeria, the UK, Germany, Canada, and beyond), and the lighter-weight options for people who just need a quick map without installing GIS software at all.
Method 1: Adding Excel Data to ArcGIS Pro (XY Data)
Add your Excel table to the project. On the Map tab, click Add Data, browse to your Excel file, and select the specific sheet (ArcGIS Pro will show your tabs as separate selectable items once you open the file).
Right-click the table in the Contents pane once it appears, and choose “Display XY Data” (in some versions this appears as “Create Points from Table” followed by “XY Table to Point”).
Set the X Field to your longitude column and the Y Field to your latitude column. This is where the mix-up happens constantly X is always longitude (east-west), Y is always latitude (north-south). Swap them, and your points will land in a completely wrong part of the world.
Set the correct Coordinate System. If your coordinates are plain decimal degrees from a GPS device or Google Maps, this is almost always WGS 1984 (EPSG:4326). If your surveyor gave you Nigerian UTM or local state plane coordinates, you need to select that specific system instead guessing wrong here produces points that look fine on screen but are actually positioned incorrectly relative to real-world features.
Click OK, and your points should appear on the map, layered over your basemap.
Export the result to make it permanent. An XY event layer created this way is temporary by default it’s generated fresh from the Excel file every time, and if the Excel file moves, gets renamed, or the link breaks, the layer breaks with it. Right-click the layer, choose Export Features, and save it as a proper feature class or shapefile to lock the data in permanently.
Method 2: Adding Excel Data to QGIS
QGIS has two realistic paths depending on your version and whether you have the Spreadsheet Layers tool enabled.
If your QGIS has Spreadsheet Layers support (most current versions do):
- Go to Layer, then Add Layer, then Add Spreadsheet Layer.
- Browse to your Excel file and select it. If it has multiple sheets, QGIS will let you pick which one to import.
- If your sheet has coordinate columns, you’ll still need to run Processing Toolbox, then search for “Create Points Layer from Table,” and set your X and Y fields there to actually generate point geometry simply loading the spreadsheet gives you a table, not a mapped layer, until this step.
If you prefer the CSV route (works reliably across every QGIS version):
- In Excel, use File, then Save As, and choose CSV (Comma delimited) format.
- In QGIS, go to Layer, then Add Layer, then Add Delimited Text Layer.
- Browse to your CSV file. QGIS will detect the columns automatically set the X field and Y field dropdowns to your longitude and latitude columns.
- Set the correct Geometry CRS (Coordinate Reference System) again, WGS 84 for plain GPS-style decimal degrees, or your specific local/projected system if that’s what your coordinates are in.
- Click Add, and your points appear as a new layer, ready to style, label, and analyze alongside any other spatial data in your project.
Before You Build Your Map: Never assume your coordinate system confirm it with whoever supplied the coordinates. The most common and hardest-to-spot GIS error isn’t a missing point, it’s a point that appears to be in a perfectly reasonable-looking location but is actually offset by hundreds of metres because the wrong coordinate system was applied during import.
What If You Have Addresses Instead of Coordinates? (Geocoding)
A huge number of people searching this question don’t actually have latitude and longitude at all they have a list of street addresses in Excel and want them turned into map points. That process is called geocoding, and it’s a separate step from everything above.
In ArcGIS Pro, you can use a Locator (Esri’s own, or one built from your own address data) and the Geocode Addresses tool, which reads an Excel/CSV table of addresses and returns coordinates for each row, ready to map.
In QGIS, the MMQGIS plugin includes a “Geocode” function that can batch-convert addresses using an online service.
For a quick, no-software option, Google’s My Maps (part of Google Maps) lets you import a CSV or Excel file directly and will attempt to plot each row by address automatically genuinely the fastest option if you just need a usable map and don’t need full GIS analysis capability.
Address quality matters enormously here incomplete addresses, inconsistent formatting, or missing city/country information cause geocoding accuracy to drop sharply, so clean, complete addresses (street, city, state/region, country) will save you from a map full of misplaced points.
Joining Excel Data to an Existing Shapefile (Attribute Join)
This is the second scenario from earlier you’re not creating new points, you’re attaching information to boundaries or features that already exist as a spatial layer.
Make sure both your Excel table and your shapefile share a common field with matching values a plot number, parcel ID, or unique reference code that appears identically in both.
In ArcGIS Pro, right-click the shapefile layer, choose Joins and Relates, then Add Join, and select your Excel table along with the matching field on both sides.
In QGIS, open the shapefile’s Properties, go to the Joins tab, click the plus icon, and select your Excel/CSV table and the matching field.
Once joined, every record in your Excel sheet now lives as attribute data attached to the correct spatial feature so a list of plot owners, land values, or survey notes becomes queryable and mappable directly on the boundaries they belong to.
This is actually the method most relevant to real planning and land administration work matching an allocation register, a rates database, or an ownership list to plots that are already surveyed and mapped, rather than creating new points from scratch.
Common Errors (And What’s Actually Causing Them)
“I added the Excel table but nothing shows on the map.” Adding the table only loads it as a plain data table you still need to run Display XY Data (ArcGIS) or Create Points Layer from Table / Add Delimited Text Layer (QGIS) to actually generate visible geometry.
“My points are all stacked in the Atlantic Ocean, off the coast of Africa.” This is the single most common GIS joke in real life because it’s the single most common GIS mistake it means your X and Y fields got swapped, or one of your coordinate columns is blank or reading as zero. The coordinates 0,0 sit exactly in the ocean off West Africa, so this specific failure pattern is almost always a missing or mixed-up field.
“My points appear but they’re in the wrong country entirely.” Wrong coordinate system was applied during import your data might genuinely be in decimal degrees, but you told the software it was in a projected system (or vice versa), so everything shifted.
“The join worked but half my attribute fields are blank.” Your matching field doesn’t actually match exactly between the two tables a leading space, a text “001” versus a number 1, or inconsistent capitalization will all silently break a join even though the values look identical to your eye.
“My data still shows the degree symbol and won’t import at all.” Decimal degrees formatted as 5°02’16″N need to be converted to plain decimal numbers first (5.0378) most GIS import tools expect clean numeric values, not formatted degree-minute-second text.
Honestly, if you’ve battled with any of these, you’re not alone I’ve watched final-year students in a GIS lab spend forty minutes convinced their software was broken, when the real problem was one coordinate column quietly saved as text instead of number. Na so this GIS thing be the computer no dey vex, na your data dey vex am. Once you sort the data, the map go behave itself immediately.
Keeping Your Map Updated When Excel Data Changes
Here’s something that catches people out after the fact: once you export an XY event layer to a shapefile or feature class, it becomes a static snapshot editing the original Excel file afterward does nothing to the map unless you re-run the import process. If your data updates frequently (a live plot allocation register, for instance), you have two realistic choices: either keep re-running the Display XY Data / Add Delimited Text Layer process each time the source changes, or set up the Excel file as a live-linked data source where your GIS software supports it, so the map reflects the spreadsheet in closer to real time. For most practical planning work, a scheduled re-import is simpler and more reliable than chasing a live link.
Exporting Mapped Data Back Out of GIS
Sometimes the direction reverses you’ve done your analysis in GIS and need the results back in Excel. Both ArcGIS Pro and QGIS let you open a layer’s attribute table and export it directly to CSV or XLSX format, which Excel opens without any conversion needed. This is the quiet, unglamorous step that makes GIS actually useful in a non-GIS office environment your planning team can run the spatial analysis once, then hand everyone else a familiar spreadsheet instead of asking them to learn new software.
Lighter-Weight Options If You Don’t Need Full GIS Software
Not every situation calls for ArcGIS Pro or QGIS. If you just need to visualize a list of locations quickly without analysis:
Google My Maps imports CSV/Excel directly, geocodes addresses automatically, and produces a shareable map link in minutes genuinely the fastest path for a simple “where are these 50 locations” question.
Excel’s own 3D Maps (Power Map) feature, built into Excel on Windows, can plot geographic data directly from your spreadsheet without leaving Excel at all, useful for a quick internal visualization rather than a professional deliverable.
Mapline and similar web-based mapping tools offer drag-and-drop spreadsheet-to-map conversion aimed specifically at non-GIS users who need a presentable map without a learning curve.
None of these replace proper GIS software for actual spatial analysis, overlay work, or professional planning deliverables but for a quick visual, they solve the problem faster than opening ArcGIS for a five-minute task.
Why This Matters Beyond the Technical Steps: Real Planning Use
This isn’t just a software tutorial for its own sake mapping Excel data is one of the most common real tasks in physical planning and land administration work. A state lands bureau’s plot allocation register, a developer’s buyers’ list for an estate layout, a community’s household survey data, a utility company’s meter locations all of these typically start life as an Excel spreadsheet before they become genuinely useful, which only happens once they’re mapped and spatially analyzable rather than sitting as rows in a file nobody can visualize. Every skill in this guide cleaning coordinate data, choosing the right coordinate system, joining to existing boundaries is the actual bridge between “we have a spreadsheet” and “we have a usable spatial database” that a planning office, surveyor, or estate developer can act on.
A Quick Word for Readers Outside Nigeria
If you’re reading this from the US, UK, Germany, Canada, Australia, Switzerland, UAE, Singapore, Luxembourg, Qatar, or Iceland, everything above applies identically the only thing that changes by country is which coordinate/projected system your local data typically arrives in. US data is frequently in State Plane coordinates, UK data often uses the British National Grid (OSGB36), much of Europe uses national UTM zones or ETRS89, and Gulf countries and Australia commonly work in their relevant local UTM zones. The method never changes; only the coordinate system you select at the import step does. When in doubt, ask your data source which system their coordinates are in before you import it’s a thirty-second question that prevents an hour of “why are my points in the wrong place.”
If you regularly receive coordinate data from multiple sources surveyors, clients, government agencies keep a simple note of which coordinate system each source typically uses. It turns a guessing game into a two-second lookup every time new data arrives.
A Second Moment of Honesty (And a Joke, Because This Genuinely Happens)
I’ll admit something: even with 15 years of field experience, I have personally imported a dataset, watched all my points land cleanly in the middle of nowhere, and spent a solid ten minutes convinced the software was at fault before discovering my longitude column had somehow been formatted as a date by Excel’s autocorrect. If this hasn’t happened to you yet, it will, and when it does, just remember: Excel no dey format your data because e hate you na just Excel being Excel. Breathe, check your column formats, and continue. Every GIS practitioner alive has this exact story.
Frequently Asked Questions
Can I add Excel data to GIS without any coordinates at all?
Only if you have addresses instead, through geocoding, or if you’re joining attribute data to a shapefile that already has geometry. Without coordinates, an address, or a matching join field, there’s nothing for the GIS software to position on a map.
Why does my Excel data show up as a table but not as points on the map?
Adding the file only loads it as data you still need to run the specific “Display XY Data” (ArcGIS) or “Create Points from Table” / “Add Delimited Text Layer” (QGIS) step to generate actual map geometry from the coordinate columns.
What coordinate format does GIS software expect from Excel?
Plain decimal degrees (such as 5.0378) in a numeric-formatted column, not degrees-minutes-seconds text and not a combined “lat, long” string in a single cell.
Is QGIS good enough for this, or do I need ArcGIS specifically?
QGIS handles everything covered in this guide XY data, geocoding via plugins, and attribute joins at no cost, and is a completely legitimate professional choice. ArcGIS Pro is often required in specific government, enterprise, or academic environments that have standardized on Esri software, but the underlying method is nearly identical either way.
My points are showing up in the wrong location what’s the most likely cause?
In order of likelihood: X and Y fields swapped, wrong coordinate system selected during import, or a coordinate column accidentally formatted as text or date instead of number.
Can I update my map automatically whenever I edit the Excel file?
Not by default an imported XY layer is typically a static snapshot. You’ll need to re-run the import after changes, or configure a live data connection where your specific GIS software supports it.
Conclusion
Adding Excel data to GIS isn’t really a software problem it’s a data-discipline problem wearing a software costume. Clean coordinate columns, the correct field order, the right coordinate system, and a clear understanding of whether you’re creating new points or joining to existing geometry will solve this faster than any button-clicking tutorial alone. Once you’ve done it correctly once, you’ll never again be the person whose plot owners ended up floating somewhere in the Atlantic.
If you’re working through a planning, estate layout, or land data project and want this handled professionally rather than figuring it out from scratch, our Services page outlines how we support GIS and spatial data work alongside architectural and planning projects. Browse our Plans Library for layouts already structured around real plot and survey data, or visit Plan School to build up your broader planning and design knowledge. You can also explore more practical guides like this one on our Homepage.
- How Do I Convert GIS Data Between Formats? for Nigerian Land Planning Guide
- How Do I Convert CAD Drawings to GIS? GIS for Land-Site Planning in Nigeria
- How Do I Convert Shapefile to KML? — Nigerian GIS and Site Mapping Tutorial
- How Do I Convert Google Earth Data to GIS? for Nigeria’s Site Mapping Guide
- How do I georeference an image? Nigeria site mapping and building plans
Author
Massodih Okon is a Nigerian built-environment professional with academic and professional experience in urban and regional planning, geography, architectural design, Landscape Design, GIS and land development.
He holds a Master’s degree in Urban and Regional Planning from the University of Uyo and a first degree in Geography and Regional Planning.
Through MassodihPlans, he publishes practical guides on Nigerian house plans, building design, physical planning, site planning, development approval and residential construction. Read the full author profile →
