![Import csv file into excel](https://cdn1.cdnme.se/5447227/9-3/2_64e61dfa9606ee7f98e9879b.png)
![import csv file into excel import csv file into excel](https://www.wallstreetmojo.com/wp-content/uploads/2019/10/CSV-Files-into-Excel-Example-1.17.png)
Once you have the data exported this way, you can open it in a text editor such as Notepad to view the contents. 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. 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.
![import csv file into excel import csv file into excel](https://i.ytimg.com/vi/qTYouqGLcNA/maxresdefault.jpg)
Learn more.ĭownload Significant Earthquake Database text file.įor convenience, you may directly download a copy of both the datasets from the linksĮxamine your tabular data source.
![import csv file into excel import csv file into excel](https://i.ytimg.com/vi/2PmU1IXsQw8/maxresdefault.jpg)
NOAA’s National Geophysical Data Center produces a great dataset of all significant earthquakes since 2150 BC. We will be importing a text file of earthquake data to QGIS. Also, if you have a list lat/long coordinates, you can easily import this data in your GIS project. Many times the GIS data comes in a table or an Excel spreadsheet. A new and updated version is available at Importing Spreadsheets or CSV files (QGIS3)
![Import csv file into excel](https://cdn1.cdnme.se/5447227/9-3/2_64e61dfa9606ee7f98e9879b.png)