CSV file projection not aligned with Basemap

Question

I uploaded a CSV file with DMS coordinate systems in it into QGIS. The points appeared on the white background. When I add a GoogleImage background in the projected coordinate system WGSPsudoMercator, the points show on a black background. When I zoom to layer on the Google basemap, I see the points off the east coast of South Africa, they are supposed to be in Arizona, USA. Last time something similar to this happened I believe I changed the basemap from the WGS84Psudeomercator to WGS84 to align it with the points and the points showed up where I wanted them. This time, when I change the basemap projection to WGS84, the basemap disappears. I am using Degrees, Minutes, Seconds from a Juno Trimble 3B GPS. In terms of my data, I have tried switching the x field to the y-field and vise versa, adding optional numbers in front of the coordinate system such as N (for north) and W (for West), adding a negative infront of the west DMS column (the one that begins with 112). I have also tried using the other coordinates (I think LatLong or UTM), but the same problems occur. Here is the first few lines of my data in a CSV file.

Answer 1

Is this correct?

Here's my thought process:

First, your values are clearly latitude/longitude Degree, Minute, Seconds. They are not UTM (which would look something like North 12S 364320 m east, 3823542 m north) or some other CRS (for example EPSG:2868) unit of measure, such as 530753, 1290047 feet.

Second, knowing that Arizona is the area of interest, the first column (34...) likely represents latitude, and the second column (112...) likely represents longitude. However, longitude values west of Greenwich (Hello Prescott!) are, by convention, preceded by a negative sign. That will be fixed below.

Third, I retyped (Stackexchange Pro Tip: when entering values in your question, type - or copy/paste - the values, rather than entering a screen shot. That saves retyping and avoids potential mistakes) your values in a text editor, making the following edits:

1. Add a header line with field names, separated by commas
2. Within the lat/long values, replace any text and punctuation (such as degree symbols and apostrophes) resulting in a single blank between D, M, and S.
3. Insert a comma between each field value
4. Insert a negative sign in front of the longitude values

Here's what I came up with:

site_no,latitude,longitude
1,34 32 40.662,-112 28 43.551
2,34 32 40.606,-112 28 43.333
3,34 32 40.636,-112 28 43.139
4,34 32 40.713,-112 28 43.245
5,34 32 40.834,-112 28 43.416

I saved the file as plain text, with a .csv file extension.

Fourth, I added the .csv file to QGIS as Delimited Text. Here's a screenshot:

Note in particular that the DMS coordinates box is checked. Also, I selected EPSG:4326 as the data's CRS - a reasonable assumption, given that it is the typical CRS used by GPS field recorders.

Voila! The points display on the QGIS map. If desired, save the points to a layer format, such as Geopackage, shapefile, etc.