ataashihunter: (Default)
[personal profile] ataashihunter
While I am in the process of building a fancier thread tracker, here is my basic simpler excel html generator:

Step one:
Open Exel and set up a sheet like this:



In Colum A put the urls to the posts/threads, in B put what you want the text to be to show that url. If you like to seperate your links into groups with titles like I do, put the title of the group in C and leave A and B empty for that row

Step 2:
Add this formula to E2 and then copy it down for all the rows you are using
This is a cheap work around to get the correct formatting

Step 3:
Add this formula in G2 and then copy it down for all the rows you are using

Your excel should now look something like this:



Step 4:
Mark and copy the rows you want to use from Colum G and then paste it into dreamwidth in html format
If you don't have an account you can create one now.
No Subject Icon Selected
More info about formatting

Profile

ataashihunter: (Default)
ataashihunter

2025

S M T W T F S

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 14th, 2025 04:58 pm
Powered by Dreamwidth Studios