Chrome History Analysis to CSV

Easily export your Chrome browsing history analysis to CSV

We do not collect any personal data. ◆ FEATURES: • Export History: Easily export your Chrome history to a CSV file with just one click. • Chrome History Takeout Conversion: Convert Chrome History JSON files from Google Takeout into a CSV format. • Calculated Columns: Automatically calculate additional metrics for analysis. • Excel Compatibility: The CSV file is formatted for easy viewing and analysis in Excel, Google Spreadsheets or other spreadsheet programs. ◆ HOW TO USE: ➤ 1. Exporting Chrome History: • Install the Extension: Download and install the extension from the Chrome Web Store. • Open the Extension: Click on the extension icon in your Chrome toolbar. • Select a Range: Choose the date range for the history you wish to export (up to 3 months). • Export History: Press the "Download History as CSV" button. Your selected range of browser history will be saved as a CSV file on your computer. • View in Excel: Open the CSV file in Excel or any compatible spreadsheet software to view and analyze your browsing history. ➤2. Converting Chrome History JSON from Google Takeout: To bypass Chrome's 3-month history limitation, follow these steps outlined below and refer to the Important Notes section for additional details. • Download Takeout Data: Use Google Takeout (https://takeout.google.com/) to download your full Chrome browsing history as a JSON file. In the "Create a New Export" section of Google Takeout, select only "Chrome > History" and follow the steps to receive a "History.json" file containing your browsing history. • Upload JSON: In the extension, use the "Upload" option to select the Chrome "History.json" file from your computer. • Convert to CSV: The extension will convert the JSON file to a CSV format and automatically download it to your computer. • View in Excel: Open the converted CSV file in Excel or any compatible spreadsheet software to view and analyze your complete browsing history. ◆ COLUMNS INCLUDED IN THE CSV: • client_id: The client ID associated with the visit (Each browser has a different client_id). • local_id: The local identifier for the visit (Associated with client_id). • url: The full URL of the visited page. • url_clean: The cleaned version of the URL (protocol and query parameters removed). • url_domain: The domain name extracted from the URL. • title: The title of the visited page. • time: The exact date and time of the visit, formatted as YYYY-MM-DD HH:MM:SS. • hour: The hour of the visit. • day_of_week: The day of the week when the visit occurred (0 for Sunday, 6 for Saturday). • is_weekend: Indicates whether the visit occurred on a weekend (1 for yes, empty otherwise). • day_of_month: The day of the month when the visit occurred. • week_of_month: The week of the month when the visit occurred. • month_of_year: The month of the year when the visit occurred. • total_history_days: The total number of distinct days included in the file. • seconds_until_next_visit: The number of seconds until the next visit to any URL (if no next visit, the current date is used). • seconds_until_next_visit_url: The number of seconds until the next visit to the exact same URL (if no next visit, the current date is used). • seconds_until_next_visit_url_clean: The number of seconds until the next visit to the cleaned URL (if no next visit, the current date is used). • seconds_until_next_visit_domain: The number of seconds until the next visit to the domain (if no next visit, the current date is used). • page_transition: The type of transition that led to the visit (e.g., link, bookmark https://developer.chrome.com/docs/extensions/reference/api/history#type-TransitionType). • id: The visit ID assigned by Chrome. • ref_id: The ID of the visit that referred this visit. ◆ ARCHITECTURE: • Chrome API Usage: Utilizes chrome.history.search to retrieve browsing history based on user-defined time ranges. • IndexedDB: This extension uses storage to efficiently manage and process large datasets, particularly when dealing with big Google Takeout JSON files. By utilizing IndexedDB, a robust client-side storage solution, the extension can store and retrieve large amounts of data locally without overloading the browser's memory (RAM). This approach ensures that even when handling big files, the extension remains responsive, preventing performance issues and allowing for smooth data processing. IndexedDB is cleared after the script runs to free up memory, ensuring that no unnecessary data is retained. • Asynchronous Processing: Implements batch processing to handle large files efficiently without blocking the browser's main thread. Ensures smooth performance even when processing extensive datasets. ◆ PROPER USE: Large Google Takeout JSON files (>100MB) may take time to process, can be memory intensive, and may cause the interface to lag. For files larger than 300MB, it is recommended to use Python for processing to avoid performance issues and ensure more efficient handling of large datasets. ◆ IMPORTANT NOTES: • Chrome's 3-Month History Limit: The extension by default can only export history from the last 3 months due to Chrome's storage limits. • Older History: To access history older than 3 months, use Google Takeout to retrieve your full Chrome browsing history as a JSON file, which can then be converted to CSV using this extension. If you still cannot access history older than 3 months, you need to disable the "Web & App Activity" auto-delete option in your Google account's Data and Privacy settings at (https://myactivity.google.com/activitycontrols). ◆ CHANGELOG: • v2.6: Resolved an issue affecting the processing of Google Takeout JSON files. • v2.5: Added support for large Google Takeout JSON files along with memory optimizations. • v2.4: Changed hours until next visit to seconds. • v2.3: Bug fixes. • v2.2: Bug fixes. • v2.1: Added additional calculated columns for analysis. • v2.0: Added support for converting Chrome History JSON files from Google Takeout to CSV. • v1.1: Fixed issues with CSV export, specifically concerning titles not displaying correctly. • v1.0: Initial release with basic functionality for exporting Chrome history to CSV. ◆ Next Steps If you're looking to visualize the results of your browsing history analysis, our experts have designed a comprehensive Looker Studio template that seamlessly integrates with the CSV output from this extension. This customizable dashboard allows you to easily interpret the data by providing visual insights into your browsing patterns, visit frequencies, and domain usage. By utilizing this template, you can transform raw data into an interactive experience, making it easier to identify trends, monitor productivity, and optimize your online habits. See a live demo - https://justdataplease.com/product/chrome-browsing-history-analysis/