"With this tool you can play with the Data Export API by building queries to get data from your Google Analytics profiles. You can use these queries in any of the client libraries to build your own tools."

"Google-Analytics-export-to-CSV is a simple, command-line tool for exporting data out of Google Analytics and writing it to a CSV file." It uses the Google Data API, so you can actually extract more columns and rows using this than GA's built-in web export tools.