I’m using QGIS3 and I’m trying to import a deliminated text layer into QGIS from a google sheet document. Whenever I import the file into QGIS it comes with an error icon stating that the layer is unavailable. I think it might be something to do with the co-ordinates i’m using.
r/QGIS – Issue Importing Deliminated Text File from Google Sheets in QGIS3
Below is an example of the X and Y columns (I believe it’s British National Grid). I tried removing the commas by using the Find and Replace feature and then also formatted the number so it showed as plain text.
I’ve also tried copying and pasting the data into a new google sheets document and trying to import that into QGIS.
However, when I take these steps, it still shows up as an unavailable layer and i’m not sure why. Is anyone able to give some advice on what’s going on here?
Thank you 🙂
I tried removing the commas by using the Find and Replace feature and then also formatted the number so it showed as plain text.
I’ve also tried copying and pasting the data into a new google sheets document and trying to import that into QGIS.
- Formatting: Make sure the numbers are correctly formatted without any commas, as QGIS expects purely numerical values for coordinates. QGIS handles CSV files well, so ensure you export your data from Google Sheets to CSV format. In Google Sheets, go to File > Download > Comma-separated values (.csv, current sheet).
- Consistency: Check that all entries are consistent in format and there are no hidden characters. Sometimes, copy-pasting from Google Sheets to other formats can introduce invisible characters that may cause errors.
- Redacted Data: If the ‘–REDACTED–‘ values are placeholders for actual data, make sure that the real data is entered before trying to import into QGIS. QGIS won’t be able to plot points with incomplete coordinate data. If you don’t have the missing data, you should consider deleting the incomplete coordinate rows.