How do I add a CDM List (An .xlsx file) to a look up list in Splunk Ent. ? Thank u very much

[SamHTexas]

Please share the process of adding an .xlsx file to a Lookup list in Splunk Enterprise. Thank you a bunch.

[solarboyz1]

First, you will need to open you .xlsx file in Excel and save it as CSV. 

Then  settings -> lookups ->  Lookup Table File -> New Lookup Table File and upload your CSV file.

Now to combine your new lookup table file, by appending the new to the bottom of the current:

| inputlookup new_lookup.csv
| outputlookup append=t current_lookup

Which will append the entries of the csv you just uploaded to the bottom of your current CSV.