Referring to the screenshot, I'd like to know how to fill the output column with unique values that either have the same name as the input files or otherwise have some unique value in each cell. If I fill in the first output cell, and then right-click and use fill, it fills the entire column with the same file name as used in the first cell, therefore I only get one output file. If I don't fill in the output column at all, I get unique file names for each cell, but they are saved to the default gdb which gives me difficulty. What I'd like to do is to save unique file names to a directory that I choose. Is there a way to do this?

enter image description here

2 Answers 2


As far i can recall, you can select all tables from this batch tool and copy into microsoft excel and modify input parameters of the tool in excel (apply some excel formula to change the output to lessen manual labor). After that you can select all in the tool and paste this excel rows back into the tool.


  • Good Idea, I put the input column in excel and use the replace function to change the directory of each cell to match the desired output directory. This eliminates any need to change the actual file names. I use Excel's concatenate function to add .shp extension. I try to copy and paste the desired output column into arcmap. For a split second it shows all the cells correctly filled in, but then the paste disappears and leaves only the first cell. So close, yet so far :)
    – AF2k15
    May 17, 2015 at 16:35
  • Finally! I was not paying attention to your demo image which shows that you pasted all columns, not just the output column from excel, and you first selected all rows. This did the trick.
    – AF2k15
    May 17, 2015 at 16:48
  • Yap this is the select all practice.. and easy too.I think your are now done?
    – Learner
    May 18, 2015 at 4:44
  • Thanks alot! saved a lot of time for my work !! @SIslam
    – Sahadeep
    Jan 18, 2020 at 17:55
  • The batch to itself needs a batch tool Jan 12, 2021 at 15:54

I would recommend to build a simple model to iterate through all rasters in your workspace and then convert each of them to Polygon.

To add an iterator, In model builder go to: Insert > Iterators > Rasters

You final model should look like this:

Model to iterate rasters

and your Calculate Value Should look like this:

enter image description here

The code block:

def t(s):
 return 'C:\Users\Documents\ArcGIS\Default.gdb\RasterToPoly'+s.split('.')[0]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.