I am trying to do a crosstabulation analysis with QGIS. I have used the grass tool r.coin and I have got the coincide report in txt format. However, I want to work with that report in excel, but I don´t know how to import it in excel in a way it keeps the original columns and differentiates between pages, etc.

You can see in the following link how the output table of the tool looks like: https://grass.osgeo.org/grass70/manuals/r.coin.html

1 Answer 1


Two possible work flows: You could just copy-paste the r.coin output into a text file, change the pipe characters '|' to commas, then import into excel as comma separated values. A bit fiddly, but it could work.

Maybe more relevant would be the r.statistics module? This will give you a new raster with statistics from a cover raster in each category of a base raster.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.