正道沧桑

Bookmarks to CSV Format#

1. Use Google to Export Files#

2. Google Plugin "Export History/Bookmarks to JSON/CSV/XLS"#

   1. After launching, use "Chrome bookmarks.json"
   2. The built-in json->csv format is not very useful

3. Use Json to CSV Tool or TableConvert (you can delete unwanted columns)#

   1. Convert the date to DD.MM.YYYY (seems not very useful)

4. Place the file exported from JSON to CSV tool into the cursor project#

5. Use cursor agent, input the statement:#

   • Reorganize the @waiting_to_convert_csv.csv file according to the first row title of @target_file.csv, and match the titles of the @template file by yourself (let's get to work)
   • I have a source CSV file @waiting_to_convert_csv.csv, and I want to convert it to match the format of @target_file.csv. The title row of target_file.csv is: title,note,excerpt,url,tags,created
   • Please reorganize the data of @waiting_to_convert_csv.csv according to the title row of @target_file.csv.
   • Conversion Requirements:
     • The order and names of the columns must be consistent with the title row of @target_file.csv.
     • Columns not present in @waiting_to_convert_csv.csv (such as tags and note, etc.) should be intelligently filled with values that match the website content.
     • The title names in @waiting_to_convert_csv.csv and @target_file.csv may not match exactly in case, but have the same meaning (e.g., dateAddedLocal and created). Please intelligently recognize and match.