Data & Export

Import Instagram or TikTok CSV Data into Google Sheets

To analyze a FeedRama CSV in Google Sheets, import the file into a new spreadsheet or a separate raw-data sheet, then verify its columns before adding formulas. Keep the original CSV unchanged. An imported file is a snapshot of the collected posts, not a live connection that updates Instagram or TikTok metrics automatically.

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

Prepare the export and its context

Record the platform, profile, scope, collection date, and whether the collection completed. Use Instagram export or TikTok export where available. The file should have a header row that tells you what each column contains.

Keep the local CSV even after importing. It provides a stable reference if a later edit or automatic type conversion changes the working sheet.

Import into a raw-data sheet

  1. Create or open the destination spreadsheet and use its file-import workflow to select the CSV.
  2. Import into a new sheet or other location that does not overwrite unrelated work.
  3. Check that captions with commas remain in one cell and that the header row aligns with the data.
  4. Name the sheet with the source and collection date, then make a separate analysis sheet.

Google documents spreadsheet file interchange in its Sheets and Excel guidance. Inspect the available import options in your current interface rather than assuming every dialog looks identical.

Verify before calculating

FieldCheck
URLStill readable as the full source link
DateInterpreted consistently, with unknown dates left unknown
CountsNumeric where actually available
CaptionCommas, quotes, and line breaks preserved
RowsMatches the exported sample, excluding the header

Do not use a blanket “convert everything to numbers” step. Captions and URLs are text, and missing metrics need deliberate handling.

Keep snapshots separate from live data

Google’s IMPORTDATA function reads CSV or TSV from a URL. That is different from importing a local FeedRama file, and it does not turn a static export into a live social-platform connection.

Use FeedRama and the TikTok sorter for a new collection when needed, then save a new dated snapshot. Analyze a copy so your original evidence remains intact.

Frequently asked questions

Does importing a CSV update metrics automatically?

No. A local CSV import is a snapshot. Collect and import a new dated file when you need a new observation.

Should I edit the raw-data sheet?

Keep it unchanged where practical and do cleaning or formulas in a copy or analysis sheet. Preserve the original CSV too.

Why did a caption split into columns?

Check the import delimiter and quoting behavior. A proper CSV parser should preserve a quoted caption containing commas as one field.

Is IMPORTDATA the same as uploading my CSV?

No. IMPORTDATA reads a CSV or TSV from a URL. Uploading a local export does not create a live social-platform integration.

What should I check first?

Headers, row count, URLs, dates, counts, and captions. Confirm the collection scope before interpreting the data.

Put the guide into practice

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

Add FeedRama to Chrome