Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. Save the export file on your computer.
  2. Open an empty spreadsheet in Excel.
  3. Click on the "Data" tab.
  4. In the "Get External Data" section, choose "From Text".
  5. Import the CSV file.
  6. Choose "Delimited" as file type.
  7. Choose "65001 : Unicode (UTF8)" as file origin.
  8. Check to box "My data has headers".
  9. Click on Next.
  10. Choose "Comma" as delimiter.
  11. Click on Next.
  12. Define the data format for columns that contain a date, especially, as "Text"
  13. Click on Finish.



How to remove the author identifiers form the column in Excel

  1. Mark the column

  2. Ctrl+H
    Find What: ::*||
    Replace With: ;
    then "Replace All"

  3. Ctrl+H
    Find What: ::*
    Replace With:    (empty)
    then "Replace All"