I have a polygon layer (although I have also converted it to points and tried it that way). I would like to copy this layer into excel and add it back in after editing some things. I've attempted to do this by copying the attribute table, pasting it into excel, making my edits, saving the sheet as a CSV, and using "add a delimited text layer" to put it back into my QGIS project. I have not altered the "well-known text" column, and have used that when QGIS asks for the geometry (although I have also tried using the X and Y fields when attempting to do this when the layer is converted to points).
My problem is that the layer appears in the wrong place when I add it back in (the original is in New England, and the version I add back in is off the northern coast of Quebec, when compared to a Google Maps layer imported from the QuickMapServices plugin). The original layer is in the right place, before and after I add what should be its identical twin back in.
Should this be theoretically possible? And/or am I missing a step?
Other things I've tried:
Switching project and/or layer CRSs. I have not found one that fixes the problem - and in any case, the original layer is in the right place, and according to its attribute table, has the same geometry as my copied layer.
Just using a join. The original layer has one point for each geometry - I'd like to have multiple points in some locations (with the other fields differing). I don't see a way to do that outside of excel, other than manually drawing new features, which would be prohibitively time-consuming.