Skip navigation
FXCANADA
Currently Being Moderated

Batch convert .html to .csv on Mac

Apr 11, 2013 8:05 PM

I have over 2,000 html files developed in Dreamweaver that were regexed to text only without any html code so that three fields of data can be extracted into csv files for use with another program (which requires csv files).

 

What's the best way on a Mac to batch resave/convert the html files to csv files (with or without Dreamweaver)?

 

I will then need to concatenate all these csv files into a single file.

 

Update

 

I found a solution that might interest a few people now or later.

 

.csv files are very plain text files, and you can save a .html file with .csv at the end instead, and it will open in programs like OpenOffice. It's also possible to change the file extension manually with the file closed in Finder.

 

So all I had to do was download Name Munger 1.7.3 (free) to change the file extension to .csv on multiple files.

 

 

  Because the CSVs are text files, you can combine with them with the cat command in Terminal:  cat a.csv b.csv c.csv > outputfile

http://hintsforums.macworld.com/showthread.php?t=94561

 
Replies
  • Currently Being Moderated
    Apr 11, 2013 10:48 PM   in reply to FXCANADA

    Hi,

     

    Thank you very much for posting your solution here. I am sure that it will be very useful to someone in a similar situation.

     

    Thanks,

    Preran

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points