Scribd
Upload
632 views

Tutorial Import Excel Ke QGis

ini adalah cara-cara melaukan plotting koordinat yang ada di data excel ke peta pada software QGis 2.18.13. Tulisan ini saya ambil dari beberapa blog yang saya jadikan menjadi sebuah tulisan sehingga dapat dengan mudah dibaca oleh pembaca

Uploaded by

Yusep Sugianto
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
632 views

Tutorial Import Excel Ke QGis

ini adalah cara-cara melaukan plotting koordinat yang ada di data excel ke peta pada software QGis 2.18.13. Tulisan ini saya ambil dari beberapa blog yang saya jadikan menjadi sebuah tulisan sehingga dapat dengan mudah dibaca oleh pembaca

Uploaded by

Yusep Sugianto
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Importing Spreadsheets or CSV files

Many times the GIS data comes in a table or an Excel spreadsheet. Also, if you have a list
lat/long coordinates, you can easily import this data in your GIS project.

Overview of the task


We will be importing a text file of earthquake data to QGIS.

Get the data


NOAAs National Geophysical Data Center produces a great dataset of all significant earthquakes
since 2150 BC. Learn more.
Download Significant Earthquake Database text file.
For convenience, you may directly download a copy of both the datasets from the links below:
signif.txt
Data Source [NGDC]

Procedure
1. Examine your tabular data source. To import this data to QGIS, you will have to save it
as a text file and need at least 2 columns which contain the X and Y coordinates. If you
have a spreadsheet, use Save As function in your program to save it as a Tab Delimited
File or a Comma Separated Values (CSV) file. Once you have the data exported this way,
you can open it in a text editor such as Notepad to view the contents. In case of the
Significant Earthquake Database, the data already comes as a text file which contains
latitude and longitude of the earthquake centers along with other related attributes. You
will see that each field is separated by a TAB.
2. Open QGIS. Click on Layers Add Delimited Text Layer.
3. In the Create a Layer from a Delimited Text File dialog, click on Browse and specify the
path to the text file you downloaded. In the File format section, select Custom
delimiters and check Tab. The Geometry definition secction will be auto-populated if it
finds a suitable X and Y coordinate fields. In our case they
are LONGITUDE and LATITUDE. You may change it if the import selects the wrong fields.
Click OK.

Note
It is easy to confuse X and Y coordinates. Latitude specifies the north-south position of a point
and hence it is a Y coordinate. Similarly Longitude specifies the east-west position of a point and
it is a X coordinate.
4. You may see some errors displayed in the next dialog. The erros in this file are mainly
due to missing X or Y fields. You may examine these errors and fix the problems in your
source file. For this tutorial, you may ignore these errors.
5. Next, a Coordinate Reference System Selector will ask you to select a coordinate
reference system. Since the earthquake coordinates are in latitudes and longitudes, you
should select WGS 84. Click OK.

6. You will now see that the data will be imported and displayed in the QGIS canvas.
QGIS: Add x and y coordinates from
a spreadsheet or CSV File
Software: QGIS 2.0 -2.8
LibreOffice

1. Open the spreadsheet in either LibreOffice or Microsoft Excel. Save as a


delimited text file. I chose to use commas as the delimiter. If you already have a
delimited text file youve saved a step.

2. Open QGIS.
3. Look for the manage layers toolbar. Click on the Add delimited text icon.

4. Under the layer menu you can now select Add Delimited Text Layer

5. Select the text file and provide a layer name. In this example my file name was
test.csv and the layer name was locations.

6. Select the delimiter. In my case it was a comma.

7. Select the column headings for the X and Y fields. In this example my column
headings were latitude and longitude.

8. You will be selected for a projection. In my case the projection was WGS84 or
EPSG 4326.

9. Enjoy your data!

You might also like