Kari Spiegelhalter — June 17, 05:43PM
How to bring ebird data into excel?
I downloaded the ebird dataset for Houston, Texas, and am having trouble bringing the data into excel because all of the file types are "Text Documents" and can't be read by excel. Where am I going wrong?
Tom Johnson — June 18, 07:05PM
The ebird download you receive in your email is a zip file that must be extracted (automatically on my computer) to a .csv file. Any spreadsheet program will open it, but you will have to search Google for the version of Excell you have. For example search this in Google "How to import CSV into Excel 2016". Basically you have to import it as delimited with comma separators. Best of luck. -Tom
Kari Spiegelhalter — June 19, 08:44AM
Thank you Tom! I was able to import it! I just needed to change my excel settings to imported it with "delimited" with "comma separators" as you said. I appreciate the help!