I want to create multiple csv files from the data in the main csv file
Solution 1:
Save the whole Excel file as csv named myfile.csv
In the same folder create file split.bat with content:
@echo off
set /a c=0
setlocal ENABLEDELAYEDEXPANSION
for /F "tokens=*" %%A in (myfile.csv) do (
set /a c=c+1
echo %%A > !c!.csv
)
Run split.bat and you will get 350+ csv files with one line inside