Export using the Import/Export Assist

[ElycePowter]

I am having an issue Exporting data, It keeps exporting to a Notepad document rather than an excel. I need it to export to excel so then I can use the same format to create and import. Does anything know how to change this or if I can just copy the information into excel and that will work for the Import? 

[Mike_James]

Hi @ElycePowter , welcome to the forum.  The wizard only creates, or accepts, text files, so after the export is complete, select the link to open the file, select all the text, copy, then open Excel and paste it into a new worksheet. 

If you need to import it, save the worksheet as a new text file.