How to Turn Instagram Photo Metadata into a CSV File in 5 Simple Steps

A Little Story Before the How‑To

Last Saturday I was scrolling through my feed, admiring a friend’s sunset shot, and thought, What if I could analyze the exact settings she used? My curiosity turned into a mini‑project because I needed that data for a client who loved to compare lighting trends across influencers. After a few false starts, I finally landed on a workflow that turned Instagram’s hidden EXIF nuggets into a tidy CSV file. I’m sharing it here so you don’t have to reinvent the wheel.

Why Bother Exporting Instagram Metadata?

Instagram strips most EXIF data when you upload a photo, but if you own the original file—or if the uploader shared it via Direct—you can still retrieve useful information: camera model, aperture, shutter speed, GPS coordinates, and even the date the photo was taken. Having that data in a spreadsheet lets you:

• Spot patterns in lighting across a campaign.
• Build a quick reference sheet for future shoots.
• Feed the numbers into analytics tools without manual copy‑pasting.

If any of those sound like your kind of thing, keep reading.

What You’ll Need (and Why)

1. Your Instagram photos (original files)

The original JPEGs preserve EXIF. If you only have the compressed Instagram version, you’ll miss the juicy bits.

2. A free EXIF reader – I use ExifTool

It’s a command‑line utility that works on Windows, macOS, and Linux. You can download it from the official site and add it to your PATH for easy access.

3. A spreadsheet program (Google Sheets or Excel)

We’ll convert the raw output into CSV, which any spreadsheet can open.

5 Simple Steps to Convert Metadata to CSV

1. Gather your images into one folder Create a folder called instagram_meta on your desktop and drop every JPEG you want to analyze there.

2. Run ExifTool to export JSON Open a terminal (or Command Prompt) and type:

   exiftool -j *.jpg > meta.json
   

   The -j flag tells ExifTool to output JSON, which is easier to reshape later.

3. Convert JSON to CSV with a one‑liner If you have Python installed, run this short script (copy‑paste into a file called json2csv.py):

   import json, csv, sys
   data = json.load(open('meta.json'))
   keys = set().union(*(d.keys() for d in data))
   with open('metadata.csv','w',newline='') as f:
       writer = csv.DictWriter(f, fieldnames=sorted(keys))
       writer.writeheader()
       writer.writerows(data)
   

   Then execute:

   python json2csv.py
   

   A metadata.csv file appears next to your JSON.

4. Open the CSV and clean it up Load metadata.csv into Google Sheets. You’ll see a column for every EXIF tag. Hide the ones you don’t need (like FileModifyDate) and rename the rest for clarity.

5. Save or share Once you’re happy, download the sheet as a fresh CSV (File > Download > Comma‑separated values). Now you have a tidy dataset you can feed into any tool or simply keep for reference.

Tip: If you only care about a handful of fields, add the -csv flag to ExifTool and list the tags you want, e.g., exiftool -csv -Model -FNumber -ExposureTime *.jpg > simple.csv. This skips the JSON step entirely.

Frequently Asked Questions

Q: Does ExifTool work on mobile devices? A: Not directly. However, you can install a terminal app on Android (Termux) or use iSH on iOS to run the same commands. The workflow stays the same; you just need a file manager that can move photos to the app’s folder.

Q: My Instagram photos were taken with an iPhone. Will I still get useful data? A: Absolutely. iPhone photos store the same core tags (camera model, aperture, ISO). GPS data is also present if location services were enabled when shooting.

Q: What if I only have the Instagram‑compressed images? A: Unfortunately, Instagram removes most EXIF when it creates its web‑optimized version. The only workaround is to ask the creator for the original file, or use a third‑party downloader that preserves metadata (some browser extensions claim to do this, but results vary).

A Personal Wrap‑Up

When I first tried to pull data for a brand pitch, I felt like I was chasing a ghost—until I realized the original files were just a click away in my phone’s cloud backup. Running those five steps took me under ten minutes, and the resulting CSV gave my client a concrete visual of “what works at golden hour.” If you’re a content creator, marketer, or just a photography nerd, this tiny workflow can save you hours of manual note‑taking.

Feel free to tweak the script, add more tags, or even automate the whole thing with a scheduled task. And if you run into a snag, drop a comment—I'd love to help you troubleshoot.

Happy data hunting!