Import a social-media CSV into Excel through its text/CSV import workflow when you need control over column types. Check URLs and any identifiers as text, confirm the delimiter, and inspect dates and counts before analysis. Opening a file successfully does not prove Excel preserved every value in the form you intended.
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 ChromeKeep the source file intact
Save an untouched copy of the CSV and record its collection date and scope. Then create an Excel workbook for analysis. This separates the evidence from transformations such as type conversion, deduplication, or added formulas.
Use Instagram export or TikTok export where available. The current export uses descriptive column headers; check those rather than assuming a remembered column position.
Control text and number conversion
Microsoft explains how to preserve text-like identifiers in its leading zeros and large numbers guidance. Long numeric identifiers can lose precision when treated as ordinary numbers. If you later add post IDs to your analysis, store them as text.
Keep full URLs as text too. Counts can be numeric when they are actually available; a missing value should remain distinguishable from a measured zero.
Inspect the import preview
| Check | Expected result |
|---|---|
| Delimiter | One field per intended column |
| Quoted caption | Commas remain inside the caption |
| Line breaks | Do not create false post rows |
| Date | Known format and interpretation |
| Identifier | Preserved as text when required |
Microsoft’s text import documentation explains delimiter and text-qualifier behavior. The exact workflow differs across Excel versions, so use the preview to verify the result before loading it.
Build a workbook you can reproduce
Use one raw sheet and one analysis sheet. Add a short notes sheet with profile, platform, collection scope, date, status, and any exclusions. A chart without that context can look authoritative while describing a narrow or incomplete sample.
Use FeedRama with the Instagram sorter for the next collection, then import it as a new dated snapshot. Do not overwrite the original observation if you intend to compare change over time.
Frequently asked questions
Should I just double-click the CSV?
That may work, but the text/CSV import workflow gives more control over delimiters and column types. Inspect the result either way.
Why should post identifiers be text?
Identifiers are labels, not quantities. Numeric conversion can change long IDs or remove formatting, making matching unreliable.
Are all zero metrics genuine zeros?
Not necessarily. Establish whether a value was observed or used as a fallback for unavailable data before analysis.
Why did a caption split incorrectly?
Check the delimiter and text qualifier in the import preview. Quoted commas and line breaks should remain within the intended field.
What should I preserve?
The original CSV, a raw-data sheet, and notes describing the collection and transformations. Keep calculations in a separate working area.