Ever had to convert a comma separated CSV file or a tab delimited file to a pipe delimited format? It can be a pain, unless you know these simple steps.
Converting between XLS, XLSX, and CSV formats is pretty easy. Just use Excel's built-in "Save As" function and change the format using the file type dropdown.
Update 1 - Is it possible to convert Notepad to Excel?
Click the link below to learn more.
This was a question I got via my contact form and the answer is yes...as long as you structure the file correctly. It is entirely possible to created a data file in Notepad and convert it to Excel or open it in Excel.