A daily task is the import of tables, QGIS allows to create a layer of points from delimited text files (if the data come from Excel it is necessary to export them type *.txt or *.csv).
How to import XY Table in QGIS 3?
The procedure is extremely simple, for which it is necessary to go to the following address:
Layer > Add layer > Add Delimited Text Layer
Within the File name dialog box browse and add the table type text, in File Format select CSV, Regular or Custom delimiters, depending on the type of delimiter mark comma, tabulator, space, colon, semicolon or others.
In Geometry Definition > Point coordinates select the fields corresponding to the coordinates X and Y, in the preview of the table it is necessary to make sure that the structure is correct, then accept.
Subsequently in Geometry CRS specify the CRS or reference system, for the present exercise WGS 84 / UTM zone 17S (EPSG:32717).
To save the new layer of points right click on it and select Export > Save Features As , the new window allows to store in various formats, such as: shp, kml, gpx, cad, tab, dng, among others.
Wow