title_body: Calibre - switching title and series column I have a problem with Calibre. I have imported many ebooks and the metadata were taken from the file name. In most cases the file name was author - title.epub. All went well, the metadata were imported correctly to Calibre. 
  
  The problem is: For books which are part of a series, Calibre added the title of the book to the series column whereas the name of the series is in the title column. (Therefore searching for metadata e.g. comments on the net is not working because Calibre does not know that the title is found in the series column.) 
  
  Example: Author: Agatha Christie - Series: Hercule Poirot Mystery - Title: Death on the Nile. "Death on the Nile" would be in the series column, "Hercule Poirot Mystery" in the title column.
  
  Is there a one-click solution to switch the title and series columns for several books? Or is there a specific setting that has to be used during the metadata downloading process that tells Calibre that the book title is in the series column?
  
  P.S.: Reimporting the books is not an option for me for I don't have the files anymore.
upvoted_answer: No, there isn't a one click solution for swapping series and title. You can only swap title and author (in bulk metadata edit mode). If you want to automate this you have to write a (small) program that reads the metadata file (which is XML), does the swap for you, and feed it the offending files.
  
  Not helpful for the files you already imported but maybe useful to know for new ones, is that you can change the regular expression ( Preferences -> Adding Books) that tries to extract metadata from the filename. The default there however does not put something in the series field, so you might already have changed that.
  
  Biggest problem IMO is that Calibre uses the filename to guess the author/title etc, even if you add a file which has correct metadata available. I normally don't use Calibre's drag and drop feature, instead relying on programmatically adding files with the metadata extracted from the file internal data (for PDF/Epub etc) when available.