Data & Export

CSV vs JSON for Social Media Research

Choose CSV when you want to inspect Instagram or TikTok post data in a spreadsheet, and JSON when you want to process structured records in code. FeedRama supports both formats for available exported fields. Changing the format does not add hidden analytics, complete comment text, or the media files themselves.

Try the workflow in Chrome

Use FeedRama on a supported Instagram or TikTok page, and check the available range and actions in your account.

Add FeedRama to Chrome

Choose from the next tool in your workflow

NeedStarting format
Sort and annotate rows in a spreadsheetCSV
Use records in a scriptJSON
Share a simple table with a teammateCSV
Parse field names explicitlyJSON
Watch the video offlineA separate media download

The best format is the one your next tool reads reliably. Avoid converting several times when one direct export already serves the task.

Understand the shared limits

Both formats describe the available collected posts. A wider-looking file structure does not make a partial collection complete. Likewise, a JSON field with a missing or fallback value is not private account analytics.

For Instagram, the export includes fields such as Profile, URL, Date, Likes, Views, Comments, Caption, Type, and Transcription. TikTok adds Shares and Saves in its standard fields and differs in format-specific details. Inspect the actual file before writing a parser.

Keep parsing separate from interpretation

A CSV reader needs to handle quoted commas, quotes, and line breaks. Splitting the file on every comma can corrupt captions. A JSON reader should parse the data as JSON rather than extracting values with brittle text matching.

After installing FeedRama, use the TikTok profile workflow and export guide. Preserve the original file before normalizing fields or adding calculated values.

Make the handoff explicit

Tell the recipient the platform, profile, collection date, scope, and completion status. Include the meaning of any columns you added yourself. A calculated ratio should not be confused with a metric supplied by the platform.

If someone needs captions and videos, deliver the data export and permitted media downloads as separate, linked assets. Use source URLs to connect them. For Excel-specific conversion issues, see the CSV import checklist.

Frequently asked questions

Does JSON contain more analytics than CSV?

Not simply because it is JSON. The available exported fields and collection determine the evidence, not the file extension.

Which format is easiest for a spreadsheet?

CSV is a practical starting point, provided the import handles quoted text and column types correctly.

Does either format include the video file?

No. Download available media separately when needed and connect it to the data by source URL or identifier.

Can I split a CSV on commas in a script?

Use a proper CSV parser because captions can contain quoted commas and line breaks. Naive splitting can corrupt rows.

What metadata should accompany either file?

Platform, profile, collection date, scope, result count, completion status, and explanations of any added fields.

Put the guide into practice

Sort and review supported Instagram and TikTok content in desktop Chrome.

Add FeedRama to Chrome