You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it.

Learn how to merge multiple CSV files into one Excel sheet. You can combine or join more than one CSV file into one Excel Worksheet.

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

How do I convert Excel data to a calendar? To turn Excel data into a calendar, you can create a table in Excel with columns for Date, Time, Event, Location, etc. Then, save the data as a .csv file.

A VBA macro in Excel definitely sounds like the way to go. Load the CSV file, load your template spreadsheet, and shuffle the values around. It's pretty straightforward stuff.

Part Two of this three-part article covers how to import your Outlook contact list—the CSV file—into Excel, then how to refine, maintain, and manage that database so, in Part Three, you can ...