If you've encountered a CSV file and you're unsure what they're for, the good news is they're pretty straightforward and easy-to-use with apps you already know.

To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.

Now, opening a JSON file is not hard, however, it would make more sense to convert it to the Microsoft Excel (CSV) format for easier use. The question is, how does one convert a JSON file to Excel?

To create one, you convert Excel to CSV (comma delimited) format, so you start by populating your spreadsheet in the way you ordinarily would.