How to export list of MAC addresses to an Excel spreadsheet?

Don’t open the CSV in Excel, instead create a new workbook, click on the data tab on the ribbon and select ‘Get External Data’, ‘From Text’.

Select ‘delimited’ if your data is seperated with a specific character. You’ll have to specify the delimiting character on the next step. If you have a header row, enter a value for ‘Start Import at row…’

Click ‘Next’ and select your delimiting character. In this case, it’s a semi-colon ‘;’

If you wish to shape your data, you can enter field types here. For example, I want the ‘Barcode’ field to be rendered as Text as it may contain leading zeros or be summarised by Excel if it’s treated as a number.

Next, select your existing worksheet and press OK to import your data.

Sep 11, 2017

Product: Find MAC Address    mac address , excel , find mac address , csv
Product Info
April 24, 2023
Fully-featured 10-day trial