Frequently Asked Questions
Exporting to dedicated Columns in Google Calc / Spreadsheets
It is easily possible to convert the CSV output into a Google Spreadsheet and properly split it into columns.
This way you can easily grep only specific parts (like the URL).
- Open Google Spreadsheets (docs.google.com) and start a fresh Spreadsheets document
- Use the Clipboard and Paste the whole CSV export page into one Cell of the document
- On the bottom right of the pasted data you will find a "Paste Icon", Click it
- Select "Split text to columns" and choose "Custom" separator. Enter the '|' Symbol
Now the columns are properly filled.
A similar approach can be done in Microsoft Excel (CSV import with custom column separation)
A similar approach can be done programmatically by using the JSON export format, all programming languages support JSON data.