Census Records in Microsoft Excel
Ranked #8,692 in Computers & Electronics, #182,127 overall | Donates to Save the Children
American Community Survey Demographics Can Now be Imported to Excel
Have you heard about the American Community Survey, otherwise known as the ACS? It's the U.S. Census Bureau's replacement for the old "long form" part of the census taken every ten years. But instead of being a single snapshot of the U.S. population (which becomes outdated pretty quickly), it's a continuously updated, ongoing survey that's done throughout the year and throughout the decade. It provides a true moving picture of our American community - and it's a priceless source of social, economic, and housing information that businesses, non-profits and others can use for making good, data-based decisions, especially important in this tough economy. We're going to talk a little more about census records from the ACS and how you can access this demographic treasure trove with a neat little tool called CDXZipStreamTM
What is the ACS?
The American Community Survey formally launched in 2005 and since then, about 3 million randomly selected households across the country have been filling out this confidential survey every year. Just some of the topics covered by the ACS are: age, gender, race, school enrollment, income, family size, housing value, ethnicity, occupations, and commuting. For more information please take a look at the American Community Survey form.The main purpose of the ACS is to help our elected officials and community leaders make good decisions about how our tax dollars are spent. Where should we focus services for seniors and the disabled? How should we be spending transportation funds to reduce commuting time? What is the impact of the economic stimulus on income and poverty levels? The ACS provides a new real-time tool to help answer these kinds of questions and truly measure how well our government is working, something that just isn't possible with older census records obtained every ten years..
Now let's see how you can use CDXZipStream to tap into the wealth of information from the American Community Survey, on behalf of your business, non-profit group, or any other organization that uses (or should use!) demographic data.
Get Your Census Records!
Everyone has access to the census records from the American Community Survey. Just use the on-line tool American Factfinder on the Census Bureau website and get valuable demographic information for the location of your choice.
But if you want a lot of demographic data, or need to make multiple data requests, you should consider using CDXZipStream. CDXZipstream works entirely within Microsoft Excel, so you don't have to learn a new application. Need to get gender and age profiles for counties in the state of California? Just list the counties of interest in an Excel worksheet and use our patented interface to pick and choose from a list of demographic variables. Since the ACS data is stored locally on your computer, there's no waiting to download large files from the internet and no need to reformat the data into a usable form - it's immediately ready to chart and analyze in Excel.
Best of all, CDXZipStream is a very economical alternative to expensive private demographic databases that can cost thousands of dollars. And CDXZipStream has additional functionality that goes far beyond demographics - check out our Squidoo lens 5 Cool Things You Can Do with Microsoft Excel for details. You can also view the video below to see CDXZipstream in action:
But if you want a lot of demographic data, or need to make multiple data requests, you should consider using CDXZipStream. CDXZipstream works entirely within Microsoft Excel, so you don't have to learn a new application. Need to get gender and age profiles for counties in the state of California? Just list the counties of interest in an Excel worksheet and use our patented interface to pick and choose from a list of demographic variables. Since the ACS data is stored locally on your computer, there's no waiting to download large files from the internet and no need to reformat the data into a usable form - it's immediately ready to chart and analyze in Excel.
Best of all, CDXZipStream is a very economical alternative to expensive private demographic databases that can cost thousands of dollars. And CDXZipStream has additional functionality that goes far beyond demographics - check out our Squidoo lens 5 Cool Things You Can Do with Microsoft Excel for details. You can also view the video below to see CDXZipstream in action:
Try CDXZipStream
The demographics you need are just a click away
So whether you need to update your business plan, design a marketing campaign, or select the best location for a new franchise, try CDXZipStream as your source of demographic data from US census records. It's an easy-to-use, economical alternative to expensive private databases, and it works entirely within the familiar environment of Microsoft Excel.CDXZipStream has received numerous awards including the prestigious "5 Cow" award at Tucows.com. You can get a fully-functional, 30-day trial of CDXZipStream absolutely free. We provide complete technical support for both trial and purchased versions. If you decide to buy, pricing starts at $39.95, and the premium package including ACS data is $299.95. Quantity discounts and site licensing are also available. Keep in mind CDXZipStream is not a subscription service - you buy it one time and purchase data updates only if you need them - and if you aren't happy for any reason within 30 days after purchase, you'll get a full refund.
And Our Free On-Line Tool for Demographics ....
Sometimes you simply need demographic data for a single zip code, you may want to check out the CDX Technologies new, free on-line demographic tool. Just input the zip code of interest and select the kind of data you need. Your data request is displayed as a web page, but can also be exported to Microsoft Excel for further analysis, or to a presentation-quality pdf file. We'd like to incorporate your comments and suggestions as we add more features, so please feel free to contact us at support@cdxtech.com. Bonus Feature: How You Can Use Demographic Data
Some good resources to get you started
Demographics is not exactly rocket science, and anyone can learn to use data available from the American Community Survey. Get started by spending a few minutes with the American FactFinder tool on the Census Bureau website or simply download a free trial of CDXZipStream. Here are also some good resources on how you can make demographic data work for you:Know Your Target Market, by Elizabeth Wilson
Get a grasp on generational marketing with this guide to demographics, from Entrepreneur.com
Getting the Dirt on Your Market, by Rhonda Abrams
How to use market information, including population density and demographics, from Inc.com
The Age Curve: How to Profit from the Coming Demographic Storm, by Kenneth W. Gronbach
An insightful look at how demographics define the marketplace, with case studies.
The U.S. Small Business Association
The SBA has everything from on-line courses to one-on-one counseling services that can help you make the most of demographic data as you start and grow your business. You can also call them at 1-800-827-5722, then just press 0 to talk to a live person.
by bjhughes
bjhughes
I'm a chemical engineer by training, but turned to software design and programming when my kids were little. I work for CDX Technologies, a subsidiary... more »
- 4 featured lenses
- Winner of 6 trophies!
- Top lens » 5 Cool Things You Can Do with Excel
Feeling creative?
Create a Lens!
Explore related pages
- 5 Cool Things You Can Do with Excel 5 Cool Things You Can Do with Excel
- Simple Gantt Charts using OpenOffice.org (or LibreOffice) Simple Gantt Charts using OpenOffice.org (or LibreOffice)
- Personal Finances Excel Template: Free Download & Tutorial Personal Finances Excel Template: Free Download & Tutorial
- The Spreadsheet Diet: Calorie Counting Made Easy The Spreadsheet Diet: Calorie Counting Made Easy
- Microsoft Excel Spreadsheet Basics and Tips Microsoft Excel Spreadsheet Basics and Tips
- Is OpenOffice.org/LibreOffice better than Microsoft Office? Is OpenOffice.org/LibreOffice better than Microsoft Office?
Our CDX Technologies Blog
Fetching RSS feed... please stand byFeatured Lenses
