There are a couple of ways. I've done it by downloading an extract from https://download.geofabrik.de/, using GDAL (ogr2ogr) to convert it to GPKG, then opening it in QGIS and friends. https://github.com/osmzoso/osm2sqlite is another option, which I've never used.