Computing desk
< October 27	<< Sep \| October \| Nov >>	October 29 >

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

October 28[edit]

Excel[edit]

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)[reply]

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)[reply]

Thanks for that, Matt Deres! Serial 10:44, 29 October 2023 (UTC)[reply]

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)[reply]