I am using sh404sef and i have about 1000 html pages (containing forms,links,meta-tags,etc) I would like to import all those pages into joomla 1.53. Can this be done with your product?
CSV Import doesn't import html pages, it imports CSV files so you have to properly format this file and do some testing.
How can i ensure the correct SEF urls are created from the import ?
This is not related to CSV Import at all. The urls are created by Joomla. You'll have to use a sef component to add a custom url for each page.
how can i get the meta-tags to be placed properly on the page ?
Right now CSV Import doesn't allow you to import meta data, but these are in 2 columns in a single database table, so you could import it directly via phpmyadmin.
How can i get the links and the form to function as they do on a regular html webpage?
Partly answered above. This is beyond the scope of any of my components. You have to test things yourself to see how it works.