I want to edit my export data

In some situations you may need or want to open one of the Adminosaur export files. These are .csv files, and should open in any spreadsheet program. If you need to do this, below are some notes that may aid you:

  • When opening the file, you may need to change some settings to ensure the cells and columns are correctly separated. Our files are separated by comma’s, and the string delimiters are quotation marks (“).
  • When opening the file, you will likely need to tell the program you are using that phone numbers are ‘text’ columns, otherwise the zeros in front of the phone numbers will be removed. Most spreadsheet programs will have a function to change this when opening the file, usually by selecting the relevant column and changing the type.
  • Make sure you save the file back as a .csv if you need to import this into a database.