How to load .tsv files into Excel

Tabular versions of COUNTER reports are typically delivering in .tsv (tab separated value) format. We often get asked how to load .tsv files into Excel. While Microsoft offers plenty of support as part of the Office suite, Tasha has put together a short video using a sample Title Report to show you how it’s done.

• Open a blank Excel file
• Navigate to the Data tab and select the button “From Text/CSV”
• Select your report file from the file explorer
• Make sure the delimiter is set to “Tab” and verify that the column headings are where you’d expect them to be for the kind of report you are working with, then hit “Load”
• That’s it, your data will be imported to Excel and ready for use.