Using some relatively simple VB coding syntax, you can design a command button or other control option to create a new workbook and export data to it for use in Excel.

Learn how to import or export data from a Text file to convert a Text (.txt or .csv) file into an Excel (.xlsx) spreadsheet easily using this procedure.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.