I know this question has been asked before in one form or another, but those answers didn't solve my issue.
I'm using QGIS 2.14.0 and trying to upload lat/lon coordinates from a csv file. When I drag the file into the QGIS window it loads up the attribute table perfectly, but will not show any of my points. When I try to upload the csv file manually (layer->add delimited text layer etc) and check off the correct stuff (csv, first record has field names, point coordinates) it says there's no data in the file while simultaneously combining different cells together; for example, it keeps xlat as a heading, but then combines my ylon with the location name for the first point. So like I said, dragging and dropping it into QGIS loads up the data correctly on the attribute table, but still won't show my points. I'm completely at a loss.
An important note: when I load the csv file into ArcGIS, the points come up perfectly, but for the purposes I need these points for, I need to use QGIS and its plugins.
This is a sample within the csv file:
location xlat ylon 2ndary sc -3.9115 35.78992 nd water -3.91238 35.78988 lily pond -3.91587 35.78909 old pump -3.91706 35.7888 drk pump -3.91691 35.78885 fatuma s -3.90755 35.81442 kaku shop-3.90756 35.81433 parts shop-3.90743 35.81444 aquilina h -3.90785 35.81469 diana hou-3.90909 35.81462 traffic sur -3.90654 35.81398 goat wo -3.90938 35.81441 lucian ho -3.91062 35.81454 lucas hou -3.87172 35.82846