Data Formats (CSV, JSON, Excel)

Once you've scraped data, you need to store it. This lesson covers the most common output formats.

Choosing a Format

Saving to CSV

Reading CSV

Saving to JSON

JSON Lines Format

Saving to Excel

Using Pandas for Data Export

Appending Data

Handling Special Characters

Complete Export Example

Key Takeaways

• CSV is best for simple, tabular data
• JSON handles nested structures well
• JSON Lines is great for streaming/appending data
• Excel is ideal for business stakeholders
• Pandas simplifies all export operations
• Always use UTF-8 encoding for special characters
• Consider JSONL for large-scale scraping
• Match the format to your use case