Character encoding and column types are important when opening exported scan results into a spreadsheet application. Incorrect import may change device names or ID fields.

Basic approach

CSV is a text format consisting of lines and fields. Fields containing commas, quotes, and line breaks must be escaped correctly. Table applications can interpret some values ​​as dates or numbers; It is safer to keep inventory IDs as text.

Application steps

  1. Check the encoding and separator from the import screen instead of double-clicking the file.
  2. Keep the IP, MAC, and serial number columns in text type.
  3. Compare the number of rows and a few sample records with the original scan result.

Practical example

If a device name contains a comma, it will appear as if a new column has been opened if the field is not quoted correctly. If Turkish characters are corrupted, it may be necessary to choose UTF-8 encoding. After the transfer, examine several different records, not just the first row.

Interpret the result correctly

Device names from external sources may start like a formula. Do not run untrusted text as a formula; Verify that the export software handles these fields securely. Before sharing, make sure you do not unnecessarily distribute internal network names and access information.

Source and follow-up reading

Protocol or command details: RFC 4180. The steps and example scenario are IPScans editorial narrative.