I have an excel sheet with UTM coordinates (Easting and Northing) for four points. I want to create a shapefile (rectangle) in QGIS, but am very new to the program and following all the guides I can't seem to get it to work.
I have converted the excel spreadsheet to a Tab Delimited Text file, and gone on to QGIS and gone on to "Add a delimited text layer". I have imported the .txt file, changed the file format to 'custom delimiters', where it is checked on 'tab'. But the issue comes when I try to set the x and y coordinates. I can see in the sample data box at the bottom that it has not imported my .txt file as a table at all (which is how it is appearing on all the tutorials). So as there no longer two columns with my x and y data, it will not let me set the correct titles to allocate the x and y data. I can see that certain tabs have also merged when converted to a .txt i.e. it is combining one of my coordinates with the tab title to the left of it.
I was then going to use the delimited text layer created, and then convert it to a shapefile from there. Would this be correct?
Sorry if this is a very simple question or is not very clear, I am very new to QGIS and mapping.