GSC export TSV format

Client

TSV remains the lingua franca for Sheets and many BI tools. GSC export TSV format remaps messy Google headers to query, clicks, impressions, ctr, and position tabs.

TSV output details

Field order follows meta.columns keys—stable across weekly exports for VLOOKUP or join scripts.

CSV or pasted table → AI-ready output

?

Paste tab-separated data copied from Excel or upload a .csv export. Same column detection as the Excel tool—English and Chinese GSC headers supported.

Common use cases

  • Re-import cleaned data to Google Sheets with QUERY() formulas.
  • Feed legacy Perl/Python scripts expecting tabs.
  • Avoid comma collisions in query text.

Common mistakes to avoid

  • Manual tab cleanup in Excel

    Let this tool emit consistent field order instead.

  • Losing CTR precision

    Decimals are preserved in TSV output.

  • Mixing TSV from different properties

    Tag exports with property meta when converting to JSON instead.

FAQ

TSV vs CSV here?

Output is TSV; input paste can be tab or comma.

Header row?

First line uses normalized English field names.

Excel compatible?

Yes—paste TSV into Sheets or Excel.

Common search terms

Phrases people search for that match this tool. See the full long-tail keyword index.

  • gsc tools online
  • search console tools browser
  • google search console helper
  • seo search console export tools
  • search console ai workflow

More tools

Related utilities you can open in another tab—mostly client-side.