Wikipedia:Reference desk/Archives/Computing/2023 October 28

= October 28 =

Excel
I suppose it's to be expected—and rightly so, per WP:NOTGUIDE, NOTHOWTO etc—but our article on Excel does not make it quite clear how, in a csv file, one could split each row into its own separate file while renaming it after its first column. Serial 15:18, 28 October 2023 (UTC)


 * Agreed. So... are you asking how to do that thing? You're going to need a macro, which is a program written in VBA that gives Excel instructions on what you want it to do. Typing excel macro split csv into files and rename into your favourite search engine will start you on the right track, including YouTube tutorials that guide you though the process. Matt Deres (talk) 23:07, 28 October 2023 (UTC)


 * Thanks for that, !  Serial  10:44, 29 October 2023 (UTC)


 * Sounds like a Python job to me but I guess you can do it in VBA okay. NadVolum (talk) 10:52, 30 October 2023 (UTC)