<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Noto Sans";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Ian,<o:p></o:p></p>
<p class="MsoNormal">I think QGIS will work very well for what you want to do. <o:p>
</o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Yes, you can import Excel files into QGIS. It’s more common for people to import tabular data as .csv files, but QGIS can read Excel too. If the data you’re downloading comes in .csv format, I’d recommend that you download that format instead
(Excel can mangle data when it makes assumptions… particularly if it thinks anything is a date), but either format will work. Since your tabular data doesn’t have spatial information, you’ll need to join it to a vector file of the states. For this, I would
recommend Natural Earth <a href="https://www.naturalearthdata.com/">https://www.naturalearthdata.com/</a> This dataset is designed for cartography and should have the country identifiers you need to complete your join. A Google search should turn up blog
posts on how to import your tabular data and how to do the join. My intro workshop is here:
<a href="https://ucdavisdatalab.github.io/Intro-to-Desktop-GIS-with-QGIS/">https://ucdavisdatalab.github.io/Intro-to-Desktop-GIS-with-QGIS/</a> It doesn’t cover joining data, but it does have some other skills you might need. And this is my cartography for
academic figures workshop: <a href="https://github.com/MicheleTobias/Workshop-Cartography-Journal-Figures">
https://github.com/MicheleTobias/Workshop-Cartography-Journal-Figures</a> <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">There are ways to move directly from QGIS to an online interactive website. I’ll leave the specifics to the folks on the list who know more about this. (I build my own with Leaflet.)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I hope you give QGIS a try. I use it for my cartography work so I think you’ll find it to be more than sufficient.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Michele<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><b><span style="color:#1F497D">Michele Tobias, PhD<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:#1F497D">Geospatial Data Specialist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">DataLab: Data Science & Informatics<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">UC Davis Library <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">370 Shields Library<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">(530)752-7532<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><a href="mailto:mmtobias@ucdavis.edu"><span style="color:#0563C1">mmtobias@ucdavis.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">ORCID: </span><span style="font-size:9.0pt;font-family:"Noto Sans",sans-serif;color:#494A4C;background:white"><a href="https://orcid.org/0000-0002-2954-8710"><span style="color:#0563C1">0000-0002-2954-8710</span></a>
</span><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Pronouns: she, her, hers<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Qgis-us-user <qgis-us-user-bounces@lists.osgeo.org>
<b>On Behalf Of </b>Ian Feinhandler<br>
<b>Sent:</b> Tuesday, June 20, 2023 8:05 AM<br>
<b>To:</b> qgis-us-user@lists.osgeo.org<br>
<b>Subject:</b> [Qgis-us-user] Is QGIS right for me?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Hello, and thank you in advance for any replies.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Background:</span></b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> I am a college professor looking for software to do some basic map-making - primarily
for use in the classroom, but also for my own research. My college has moved to using free, open-access textbooks, and the maps are often out of date, and of poor quality compared to those found in expensive textbooks. I want to produce maps that contain current
data, and that are easy for students to interpret. I took GIS classes in graduate school, but that was 20 years ago. I do not have a huge amount of time to learn new software.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Intended Use:</span></b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> I want to take open-access data from sources like the U.N. Human Development
Report, the World Bank, etc. and map the data by country, or by geographic units within a country (state, county, etc.). The open-access data is typically available in Microsoft Excel, which is the format I prefer to download, as I am quite comfortable doing
basic data-analysis in Excel, and producing tables and graphs in Excel for displaying the data.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Key Question:</span></b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> Can I upload an Excel file to QGIS?
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Very Simple Example:</span></b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> I have an Excel file with country names in column 1, and their GDP in
column 2, and their rank in column 3. I want to make a map of the world that presents each country by GDP, using five different shades of a color (e.g. the darker the color, the higher the GDP). I assume that there are shapefiles that list countries with a
"country code" (e.g. Afghanistan = 1, Albania = 2, or something like that). If I had a fourth column in my Excel file that was "country code" would I be able to upload the Excel file to QGIS and quickly produce a simple map?
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Online Compatible?</span></b><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"> It would be pretty cool if I could post the maps online, and have them
be interactive, so that a student could click on a country and see the specific data (e.g. GDP, as mentioned above). This would be a nice feature, but not a necessary one.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Thank you very much for taking the time to read through this long post, and for any advice.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Ian<o:p></o:p></span></p>
</div>
</div>
</div>
</body>
</html>