Extracting Text Data to Excel File for Import into ASC

[Christopher Wilson]

Hello everyone. I'm looking for an automated method to extract financial account activity data from a *.txt file and import it into an Excel file so we can import it into ASC. I'm sure it can be done via AI. I've tried to use Copilot with limited success. Python seems to be a possible solution. Thank you.

[C. B. Zeller]

ASC can natively import txt files. Is the file structured in any reasonable way? Have you tried using one of ASC's import wizards or their predefined importer specs, if one exists for the data source you're using?

If you want to take the approach of using code to extract/transform data before loading it into ASC, then a chatbot could probably help you write the code. I'd recommend that you know enough Python (or whatever language) to be able to read and understand the bot's output before relying on it in production. People on the internet seem to like Claude for that kind of task these days, but I can't offer any personal experience.

[justanotheradmin]

I agree with C.B. Zeller. 

Is the issue the file type? Because ASC takes .txt files for import just fine. 

Is the issue how the data is in the file? 

What import function in ASC are you trying to use? there are a variety of ways to import things into ASC. For example, investment imports where ASC has pre-programmed to work with certain major recordkeeper files. And then there are ASCRIPT custom imports which are super easy to use as well once you know what you are doing. Plus wizards and such. 

If the issue is how the data is in the file, and you don't want to manually edit the file then a macro or code to do that as CB suggests. 
You can just open the txt file in Excel, and then save it as an excel file type if you really just want to change the file type.