GIS Tutorial
  • Home
  • About
  • Contact

Popular Posts

How to open Mapinfo TAB file on QGIS
QGIS,

How to open Mapinfo TAB file on QGIS

by adminJanuary 1, 20181 comment
How to Create a GeoPackage on QGIS 3.2
QGIS,

How to Create a GeoPackage on QGIS 3.2

by adminJuly 25, 2018no comment
How to Export Layer to Shapefile on QGIS
QGIS,

How to Export Layer to Shapefile on QGIS

by adminSeptember 21, 2018no comment
How to convert polyline to polygon on QGIS 3.0
QGIS,

How to convert polyline to polygon on QGIS 3.0

by adminJune 12, 2018no comment

Category List

  • ArcGIS (75)
  • Database (34)
  • Free Spatial Data (2)
  • General (5)
  • GIS Software (20)
  • Global Mapper (20)
  • Leapfrog Geo (15)
  • Mapinfo (40)
  • Micromine (28)
  • Programming (2)
  • QGIS (98)
  • Software Review (1)
  • Surfer (2)
  • Uncategorized (4)

Follow Us

Instagram

Instagram has returned invalid data.
GIS Tutorial
  • Home
  • About
  • Contact
QGIS,

How to Open Excel File in QGIS

by adminDecember 8, 20181 comment
0
Shares
Share on FacebookShare on Twitter
create points

Hello, welcome to QGIS Tutorial. In this article, I am going to show you how to open Excel file in QGIS. I am using QGIS version 3.4.2 on Ubuntu 18.10. You may want to read how to install QGIS on Ubuntu 18.04. It’s pretty similar to open Excel file in ArcGIS. QGIS supports Excel (.xlsx, .xls) as well as CSV and DBF file. After we open the file in QGIS, we can directly edit the Excel file in QGIS. In this example, I have an Excel file with coordinate information.

Steps to Open Excel File in QGIS

  • Open QGIS
  • Drag and drop the excel file from QGIS browser to Canvas
  • Or go to Layer
  • Click Add layer | Add Vector Layer
  • Browse your Excel file and then click Add

Since Excel file does not have spatial information, it will not be plotted in the Canvas. But, if the file has coordinate information, we can easily plot it using the X and Y data.

How to Create Points from Excel File

If you have X and Y data in your Excel file, you can plot or display it as points. First, open the Processing Toolbox and then double-click Create points layer from table.

Select the input layer and specify the X and Y fields. Hit Run to start the process.

excelqgis tutorial
Previous

How to Create Hillshade Raster from SRTM on ArcGIS 10.6

December 6, 2018
Next

How to Create PostgreSQL ODBC Connection on Windows 10

December 30, 2018

1 Comment

Neil

July 19, 2021

Is there a way to save this scratch file?
Also I can’t do this in an existing project and actually see the points. It only shows points as a layer in its own project.
I also have a spreadsheet plug in but it never shows a visible vector file.

Reply

Leave a Reply Cancel reply

Trending

  • How to Extract Raster Value to Point Layer in ArcGIS Pro

    How to Extract Raster Value to Point Layer in ArcGIS Pro

    2 weeks ago
  • How to Convert 5 GB Tiff into JPEG Easily

    How to Convert 5 GB Tiff into JPEG Easily

    2 weeks ago
  • Finally, I Can Run Oasis Montaj on My Macbook Pro M1

    Finally, I Can Run Oasis Montaj on My Macbook Pro M1

    2 weeks ago
  • How to Run ArcGIS Pro on Macbook Pro M1 and M2

    How to Run ArcGIS Pro on Macbook Pro M1 and M2

    3 weeks ago
  • ArcGIS
  • Database
  • Free Spatial Data
  • General
  • GIS Software
  • Global Mapper
  • Leapfrog Geo
  • Mapinfo
  • Micromine
  • Programming
  • QGIS
  • Software Review
  • Surfer
  • Uncategorized

Ads




Ads




Pages