

Let’s face it: a lot of what government does is collect structured information from people.

CartoDB is free for up to five tables and five megabites of (public) data, with reasonable pricing after that.ĬartoDB Tutorial: Mapping New Hampshire election resultsĢ & 3: Easy Web Forms & Surveys: Google Forms and WuFoo It’s as easy as dragging and dropping your data file and clicking some buttons. Map your data! CartoDBĬartoDB is a web app (no installation necessary) that lets you easily put your data on a nice-looking map and share it publicly.
.jpg)
We hope some of these will help make your job easier!Ĭheck them out and let us know if you have favorite tools that you think could help other people in government at the bottom of this post. These tools are all easy to use, require no computer programing skills, and free (at least up to a certain usage).

Get "Text to columns" feature: split values in a column by any delimiter, string, or by position.Search all selected sheets for certain values, formulas, notes, and hyperlinks see a list of found entries, export or replace them in a click.Click once to AutoSum numbers in every row or column sum and count cells by color.Take advantage of the new smart toolbar with handy assistants: change case, flip values, calculations based on color, unpivot table, unmerge all cells on the sheet in a click.Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets.Įxtra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with:
