I have a long (very long) list of authors

heraclito2077

Hi
I have a long (very long) list of authors separated by commas (for example: name1 surname1, name2 surname2, name3 surname3 ..., etc.), is there a quick way to enter them in Zotero?
thanks in advence

bwiernik

You can paste a list of author names into the Author field. Separate the surname and name for each author by Tab, and put each author on a new line.

So, this format:
Surname1<tab>Name1
Surname2<tab>Name2

With your existing list in the format you describe, paste it into Excel or another spreadsheet program, then use the Text to Columns function to split on each comma. Copy the new columns and Transpose Paste them so they are one column with multiple rows. Then use Text to Columns again, this time splitting on a space character. Swap the order of the surname and name columns so surname comes first. Finally, copy the two columns names, paste into the Author field in Zotero, and type Enter.

heraclito2077

thanks