Share via

BAT file for insert excel function in CSV

Anonymous
2023-08-27T17:52:15+00:00

I have a code for merging multiple csv files to one csv file but I need to insert excel formula in newly created csv file in certain column 1 to 100 rows for calculating duplicate values in CSV through batch file. Can some one helps? Here is summary of Ask

Merge Multiple CSV files to one CSV ( All files are same format and exist in same folder)

Insert excel formula or batch script to find all A column data duplicates

Open the new CSV automatically

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2023-08-28T04:00:51+00:00

    Use Power Query.

    You can import files from folder or multiple single files and append them in PQ.

    Furthermore you can create additional columns and calculate the values you need.

    Load the result into a worksheet (if really needed).

    In the sheet you'll get a table, in there you can also add additional columns and use formulas.

    If you refresh the query, the new CSV data is loaded and your additional columns are preserved (also sorting, etc.).

    Andreas.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-08-28T00:18:31+00:00

    insert excel formula in newly created csv file in certain column

    As far as I know,.csv file are pure text file which can not contain any Excel formula.

    Was this answer helpful?

    0 comments