A csv file is just a comma separated text file. If you have a csv with lat/long coordinates in it (e.g. -3.12, 54.67) you can very easily plot these on a map in QGIS with a few clicks.
See my intro and intermediate QGIS courses for more: https://www.udemy.com/user/alasdair-r...