๐ง Work in Progress... ๐ง
A browser extension.
It will transform raw csv
data into a simple html
table, and show it online in the same tab.
Available free for Chrome and Firefox.
When quickly looking through csv data files online, you either have to:
- Open them with Excel, Numbers, etc.
- Try to skim through the data in its raw state.
CSV Reader allows you to look at the data formatted as a table, so you can make decisions faster.
CSV Reader detects if the current tab is a .csv
page (correctly most of the time).
It transforms the raw csv
data into a table, nicely formatted so it's easy to scan (see images below).
It allows the user to input some settings:
Feature | Default | Type | Result |
---|---|---|---|
Separator | , |
String | New column when this value is found |
Title row | false |
Boolean | Use the first line as the table header |
Skip at the top | 0 |
Number | Number of text lines to leave untouched at the top |
Links in text | false |
Boolean | Look for links in data and make them clickable |
- Install the extension (in Chrome or Firefox).
- Head to any
.csv
data page. - Click on the extension icon, fill the form:
- Choose the separator.
- Check if there is a title row for the data. This will format a header row in the table.
- Input the number of lines to skip at the top. Some csv pages have a few lines with info, we don't want to format those.
- Check if there are links in the data. They will be formatted as clickable links.
- Done, enjoy the table!
Visit a .csv
data file online. You can try this csv sample dataset or this other example.
Click on the CSV Reader extension icon.
In the popup, input the config options: separator, title row, etc. (In the example dataset, |
(pipe) as the separator, and check the title line option)
Click "Convert":
To go back to the raw data, click the "Reset" button on the extension popup:
If this extension was useful to you in any way, please consider leaving a โญ 5-star review.
๐จโ๐ป It will take you less than a minute, and will greatly help reach new audiences.
๐ Thank you very much!
Some features I'd like to work on (help appreciated):
- Chrome version.
- Improve the browser icons (dark/light, design).
- Style the table row on hover.
- Show progress: while the content is being processed, hide it and show a loading component.
- Add option to just rainbow-code csv (like the vscode plugin) instead of making a table.
- If separator is also in text, between
""
, detect and don't use as separator. - Add
<a>
tags to links if they are links (regex) and the config option is checked in the popup. - Detect if text looks like a link.
- Try to auto-detect separator.
- Update README and Firefox page with images and examples of usage.
- Add some useful data in the result page (number of rows and columns, etc.).
- Ask users in the result page to leave a 5โญ review please.
- Make table header sticky, so it stays at the top while scrolling.
- Remove
""
from the strings if they are at begining and end of string. - 'Doesn't work here' message: add 'if you feel this is an error please report it'.
- Try to stop .csv files from downloading, and instead open them in browser so thay can be converted.
- Make columns hideable.
- Maybe add the
reset
button at the top of the table instead of having to open the popup again. - Add an initial check to see if content is too big. If it is, change the parse method to a lighter but less precise one.
- If there is a title line, add option to transform data into JSON and export.